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 wrote: > PFA > > Cheers!! > > > On Wed, Jun 4, 2014 at 1:51 AM, Nasir Khan > wrote: > >> Hello, >> I am

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
please Thanks On Wednesday, May 28, 2014 5:15:22 PM UTC+4, Vabz wrote: > > Hi > > Check this .. > > Cheers!! > > > On Wed, May 28, 2014 at 12:47 AM, Nasir Khan > wrote: > >> Hi, >> Thanks for your reply but it is not getting the desired result. >&g

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

2014-05-27 Thread Nasir Khan
the destination then it copies the files from source to Destination. As you can see files from the Source should directly go into the respective folders in the destination. Hope it is clear now. Regards. Nasir On Monday, May 26, 2014 10:21:55 AM UTC+4, Nasir Khan wrote: > > Hello All, >

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

2014-05-25 Thread Nasir Khan
Hello All, I have lots of folder in the path C:\Libraries\Documents\ Viz: Folder A, E, H, L, P etc Each folder has many workbooks where the workbook names has the folder Prefix Eg. Folder A will have many workbooks with name xxx-xxx-*A*-xx xxx-xxx-*A-*xx and so on Folder E

Re: $$Excel-Macros$$ Macro to Import Word Tables to Excel from a folder

2013-10-05 Thread Nasir Khan
Dear Ashish, Any further help in this matter please. Regards Nasir Khan On Fri, Oct 4, 2013 at 12:38 AM, Nasir Khan wrote: > Yes I did. > But as mentioned in my reply I need the code to > 1) run on all the files in the given Path = Your code run a single folder > at a time...there

Re: $$Excel-Macros$$ Macro to Import Word Tables to Excel from a folder

2013-10-03 Thread Nasir Khan
name should be named for eg if the file being imported is abc.docx then sheet name would be abc and so on Hope I am clear. Thanks once again for all your time and help Nasir Khan On Thu, Oct 3, 2013 at 6:18 PM, ashish koul wrote: > have you tried the code which i shared > > > On Thu,

Re: $$Excel-Macros$$ Macro to Import Word Tables to Excel from a folder

2013-10-03 Thread Nasir Khan
ted is from all the document in all the folders in the Path 2) The table should come as individual sheet from each document and if possible the excel sheet is renamed with the name of the file imported. Hope you will help please Nasir Khan On Wed, Oct 2, 2013 at 9:09 AM, ashish koul wrote:

$$Excel-Macros$$ Macro to Import Word Tables to Excel from a folder

2013-09-30 Thread Nasir Khan
:=path & MyArray(N) *'<>* *Call ImportWordTable* ActiveDocument.Save ActiveDocument.Close file = Dir() Next N End Sub Can the runtime error 429 be rectified from Macro 2 Any help would be appreciated. Regards Nasir Khan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT))