Re: $$Excel-Macros$$ Re: Pasting Data from Different Files in One Worksheet

2014-10-21 Thread Vaibhav Joshi
cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Oct 21, 2014 at 5:08 PM, Hasnain Raja wrote: > Thanks guys for your help actually I was able to fix my code with line > from Vabz. > > I wasn't able to open the file sent due to firewall at my company bu

$$Excel-Macros$$ Re: Pasting Data from Different Files in One Worksheet

2014-10-21 Thread Hasnain Raja
Thanks guys for your help actually I was able to fix my code with line from Vabz. I wasn't able to open the file sent due to firewall at my company but anyways much appreciated. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Fa

Re: $$Excel-Macros$$ Re: Pasting Data from Different Files in One Worksheet

2014-10-18 Thread Vaibhav Joshi
add this line before... wsMain.select : wsRD.select cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Oct 18, 2014 at 7:31 PM, Hasnain Raja wrote: > Yes exactly. > > On Saturday, 18 October 2014 14:29:09 UTC+1, Hasnain Raja wrote: >> >> Hi All, >> >>

$$Excel-Macros$$ Re: Pasting Data from Different Files in One Worksheet

2014-10-18 Thread Hasnain Raja
Yes exactly. On Saturday, 18 October 2014 14:29:09 UTC+1, Hasnain Raja wrote: > > Hi All, > > I am getting different files from different customers (in same format) and > saving it in a folder. Now to combine all the data, I am trying to write a > macro (vba code) which open each file in the fol