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

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 nasirkh...@gmail.com javascript: wrote: Hi, Thanks for your reply but it is not getting the desired result. Pl see attached files. Folder List

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

2014-05-26 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 nasirkhan.du...@gmail.comwrote: 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

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

2013-10-03 Thread Nasir Khan
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 koul.ash...@gmail.com wrote: try this Sub import_word_table_to_excel() Application.DisplayAlerts = False

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 koul.ash...@gmail.com wrote: have you tried the code which i shared

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

2013-09-30 Thread Nasir Khan
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)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page