Script to open filename with suffix at the end of it?

This is the plain text version of what the script needs to do:

1. Capture current workbook name and save as variable

2. Open C:\files\(saved variable)001.xls

3. Make (saved variable)001.xls the active window

Then from here on out I will take over with the rest of the script I already have.

Thanks!

Maybe:

Please Login or Register  to view this content.

Originally Posted by JOHN H. DAVIS

Maybe:

Please Login or Register  to view this content.

Thanks, but unfortunately the active workbooks path is not the same as where its 001 counterpart is stored. The 001 copies are all stored in C:\files, so how would that change the formula?

Please Login or Register  to view this content.