Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
workbooks.open problem | Excel Programming | |||
Problem with Macro working in new workbooks that I open | Excel Programming | |||
Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed | Excel Programming | |||
Workbooks.Open Beeping Problem | Excel Programming | |||
Excel: workbooks.open problem | Excel Programming |