Open workbooks with variables in filename using loop

**as1234** · 05-31-2011, 11:25 AM

I am trying to open several workbooks with variable names using a loop. All of the filenames are of the form "variable GSC 2011_04.xlsx"

My code is below, with the problem area highlighted.

Please Login or Register  to view this content.

Thanks!

**Mordred** · 05-31-2011, 11:28 AM

I have no idea if this will be right but try:

Please Login or Register  to view this content.

**as1234** · 05-31-2011, 11:34 AM

Sadly, no it doesn't.

I received the error message:
'1 GSC 2011_04.xlsx' could not be found.

Thanks for trying though!

**Mordred** · 05-31-2011, 12:21 PM

Maybe this:

Please Login or Register  to view this content.

**as1234** · 05-31-2011, 01:08 PM

It worked!!! Thank you soooo much!

**Mordred** · 05-31-2011, 01:17 PM

You are most welcome.

Open workbooks with variables in filename using loop

LinkBack

Thread Tools

Rate This Thread

Display

Open workbooks with variables in filename using loop

Re: Open workbooks with variables in filename using loop

Re: Open workbooks with variables in filename using loop

Re: Open workbooks with variables in filename using loop

Re: Open workbooks with variables in filename using loop

Re: Open workbooks with variables in filename using loop

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions