Wowww MarcL... is there any meter to measure happiness of learning new things , i will be at upmost in same.
will use same way in all my future coding
thanks very much Marc L & SirJB7
Thanks SirJB7 my problem was problem till yesterday night but now it is been resolved all files are compiling fine
coding shared by MarcL is working and tried my best to remove most of select and activate
i am very happy with this.
new coding ====
Sub test()
Dim mwb As Workbook
Dim MyPath As...
Thanks Marc L
code is working fine with first workbook but giving error in opening in next file
runtime error 1004
"Q'2 file001.xlsmQ'2 file002.xlsm"could not be found
error is showing 1st and 2nd file names together, above error consists of two file names
1st - Q'2 file001.xlsm
2nd - Q'2...
when loop was not working properly i have changed related contents into remarks => line no. 15, 33 & 34 were changed into remarks when loop was not working f9
Hi All,
i need little help in getting my code work properly. my codes are below what i want to do is i have folder(dir) named as "DAR" where are 150 workbooks but there are 30 workbooks with .xlsm format type and i am trying to compile them. but on running code first file (alphabetically first...
Hi All,
My name is Gaurav from capital of India, i.e. Delhi. Fairly telling I am a intermediate in excel and learner in VBA. Came to know this website through cotexture and learning alot from the begining of chandoo's iim admission to recents post.
I have given basis training on basic excel...