Re: $$Excel-Macros$$ Re: Copy Workbooks to respective folders according to the names of folder in the workbook name

2014-06-04 Thread Nasir Khan
Thank you very much my friend. Works to my requirement. Your help will save me lot of time. Regards Nasir On Wed, Jun 4, 2014 at 2:53 PM, Vaibhav Joshi v...@vabs.in wrote: PFA Cheers!! On Wed, Jun 4, 2014 at 1:51 AM, Nasir Khan nasirkhan.du...@gmail.com wrote: Hello, I am enclosing a

Re: $$Excel-Macros$$ Re: Copy Workbooks to respective folders according to the names of folder in the workbook name

2014-06-04 Thread Vaibhav Joshi
Cheers Dude.. On Thu, Jun 5, 2014 at 1:32 AM, Nasir Khan nasirkhan.du...@gmail.com wrote: Thank you very much my friend. Works to my requirement. Your help will save me lot of time. Regards Nasir On Wed, Jun 4, 2014 at 2:53 PM, Vaibhav Joshi v...@vabs.in wrote: PFA Cheers!! On

Re: $$Excel-Macros$$ Re: Copy Workbooks to respective folders according to the names of folder in the workbook name

2014-06-04 Thread finu kodokodan
Hi Vaibjav... you are great On Thu, Jun 5, 2014 at 9:08 AM, Vaibhav Joshi v...@vabs.in wrote: Cheers Dude.. On Thu, Jun 5, 2014 at 1:32 AM, Nasir Khan nasirkhan.du...@gmail.com wrote: Thank you very much my friend. Works to my requirement. Your help will save me lot of time.

Re: $$Excel-Macros$$ Re: Copy Workbooks to respective folders according to the names of folder in the workbook name

2014-06-02 Thread Vaibhav Joshi
hi Can you share me whole excel sheet .. This will help.. Cheers!! On Sun, Jun 1, 2014 at 12:59 AM, Nasir Khan nasirkhan.du...@gmail.com wrote: Hello, Please see the screenshot in yellow. This is how my folders are set up. The destination does not show the files in the sub folder after

Re: $$Excel-Macros$$ Re: Copy Workbooks to respective folders according to the names of folder in the workbook name

2014-05-30 Thread Nasir Khan
Hello, I am getting a #VALUE error in the Destination when I click the List Files button I have taken screenshot of Evaluate Formula screen for Pre and Post Error. Pre screenshot shows the Evaluate Formula just before the #Value error pops up which is shown in the Post Screenshot See attached

Re: $$Excel-Macros$$ Re: Copy Workbooks to respective folders according to the names of folder in the workbook name

2014-05-30 Thread Vaibhav Joshi
Hi You will get value for files stored in main folder. e.g. here C:\Test\Macro\. Since we intended to transfer only files from sub folders. HTH On Fri, May 30, 2014 at 8:29 PM, Nasir Khan nasirkhan.du...@gmail.com wrote: Hello, I am getting a #VALUE error in the Destination when I click

Re: $$Excel-Macros$$ Re: Copy Workbooks to respective folders according to the names of folder in the workbook name

2014-05-28 Thread Vaibhav Joshi
Hi Check this .. Cheers!! On Wed, May 28, 2014 at 12:47 AM, Nasir Khan nasirkhan.du...@gmail.comwrote: Hi, Thanks for your reply but it is not getting the desired result. Pl see attached files. Folder List is what is source structure of the Folder File list is a sample of file in the