Workbooks.Open problem
 

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?

Workbooks.Open problem
 

check if the file is read-only on disk...

HTH

Philip

"Xav" wrote:

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?

Workbooks.Open problem
 

Are you sure it isn' an .xlt?
that is how templates are named.
Lou


"Philip" wrote:

check if the file is read-only on disk...

HTH

Philip

"Xav" wrote:

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?