VBA to action over 500 documents in a folder

**VBA learner ITG** · 06-28-2017, 05:08 AM

Hello,

I am new to VBA and still learning.

I was wondering if my peers could help me at all.

I have the below code which i am looking to run on over 500+ documents.

However the code has been written to action a single document at a time. Is there a smarter way of cycling through all documents in a folder?

Please Login or Register  to view this content.

**kasan** · 06-28-2017, 09:21 AM

Hi,
Try this way:

Please Login or Register  to view this content.

**VBA learner ITG** · 06-28-2017, 10:10 AM

Hi Kasan,

Thank you for replying.

I have tried your amended code and also stepping into the code and it hasn't worked.

are you able to elaborate on your code?

VBA to action over 500 documents in a folder

LinkBack

Thread Tools

Rate This Thread

Display

VBA to action over 500 documents in a folder

Re: VBA to action over 500 documents in a folder

Re: VBA to action over 500 documents in a folder

Thread Information

Users Browsing this Thread

Similar Threads

Convert Word Documents in a folder to PDF

[SOLVED] Perform an action in each sub-folder independently

Macro to open a folder containing documents

get list of all files in folder, perform action on each

How do I print a LIST of documents in a folder

excel documents won't open from my documents folder

Creating Folder Folder in My Documents VBA - HELP

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions