- Thank you received: 9
Welcome to the fracta.net forum!
Share your coding ideas or ask questions.
Share your coding ideas or ask questions.
Question Re: Excel VBA list all files in a folder & subfolder
- shinho62
- Visitor
11 years 7 months ago #135
by shinho62
Replied by shinho62 on topic Re: Excel VBA list all files in a folder & subfolder
Hi, well that seems to have nailed it with one small issue
although the ' has been removed from Wd.Close, it is still asking for me to confirm the save As
i have to cancel the docs it opens any ideas
although the ' has been removed from Wd.Close, it is still asking for me to confirm the save As
i have to cancel the docs it opens any ideas
Please Log in or Create an account to join the conversation.
11 years 7 months ago - 11 years 7 months ago #136
by roller
Replied by roller on topic Re: Excel VBA list all files in a folder & subfolder
Replace the wd.Close with wd.Close (0) to get rid of the Save As.
You can add Application.ScreenUpdating = 0 at the begining of the sub to speed things up. Make sure you also add Application.ScreenUpdating = 1 at the end of the sub if you do this. The screen will not show the progress until the macro finishes.
Also add wdapp.quit just before Set wdapp = Nothing in the other sub.
You can add Application.ScreenUpdating = 0 at the begining of the sub to speed things up. Make sure you also add Application.ScreenUpdating = 1 at the end of the sub if you do this. The screen will not show the progress until the macro finishes.
Also add wdapp.quit just before Set wdapp = Nothing in the other sub.
Last edit: 11 years 7 months ago by roller.
Please Log in or Create an account to join the conversation.
- alex20850f
- Visitor
11 years 7 months ago #137
by alex20850f
Replied by alex20850f on topic Re: Excel VBA list all files in a folder & subfolder
where can I find documentation on Formula= and the file properties?
I am also curious how you show how many records have been added to the spreadsheet.
I am also curious how you show how many records have been added to the spreadsheet.
Please Log in or Create an account to join the conversation.
- shinho62
- Visitor
11 years 6 months ago #141
by shinho62
Replied by shinho62 on topic Re: Excel VBA list all files in a folder & subfolder
, well thanks for the assist on this, it works a charm and has saved a lot of work
i have managed to correctly catalogue over 8,250 word files into their correct groups for correspondance reply, it helped alot
fancy earning another donation
i have managed to correctly catalogue over 8,250 word files into their correct groups for correspondance reply, it helped alot
fancy earning another donation
Please Log in or Create an account to join the conversation.
11 years 6 months ago #142
by roller
Replied by roller on topic Re: Excel VBA list all files in a folder & subfolder
That's good, glad to help.
Please Log in or Create an account to join the conversation.
Time to create page: 0.544 seconds