Discussion Article

[ Home | Contents | Search | Reply | Previous | Next ]

Subject:
VB for access- process a VB macro on multiple files
Name:
John Saunders
Email (spam proof):
Email the originator of this post
Date:
Monday, April 05, 2004
Hits:
54
Discussion (Terms and Conditions):
I'd like to run a VB macro in excel on multiple files (over 125). I'd like the VB to open each file, then copy a range into a specific (static) sheet. right now, i just copied and pasted "Workbooks.Open Filename:= _ " for each filename with the Application.Run__ after it. However, i'd much rather not have to keep adding this command for each file. Anyway to improve it? Thanks! John

Sponsored by the best FTP application on the internet: