Open only existing Excel Files in a given Range

  • Thread starter Thread starter Matty C
  • Start date Start date
M

Matty C

Hi All,

I need to compile data from multiple Excel files into one. The file
are named "string" + # + "string" and the #'s are within the range o
274 to 307 but there are some numbers missing. Is there any way t
tell my macro to only open existing files within my range?

Thank
 
try opening each f using an onerror statement to bypass those that don't
exist.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Excell 2021 0
Check a range to see if a value exists in it 5
inconsistent dir() behavior 1
Make Macro Work On A Different PC 5
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Post my named ranges in column A 10
Copy Data from Closed File to Existing File 0

Back
Top