Workbooks.Open problem

  • Thread starter Thread starter Xav
  • Start date Start date
X

Xav

When I use this method iit opens the file pass by variable and add a
"1".
For instance Test.xls becomes Test1.xls and basically I am manipulating
another excel file created from the Test.xls orginal one. If I try to
use the Save method I got an error saying the file already exists and
if I want to overwrite it. Any idea?
 

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

workbooks.open - another option 2
two same workbooks opened -- don't want this 1
error 9 'subscript out of range' using workshhets function 3
Change file name from folder using VBA 3
Checking for open workbooks Repeat/Loop VBA code 1
SaveAs Type Problem 3
Need Marco Help please 4
Retrieve Center Header String 3

Back
Top