| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CorruptLoad param of Workbooks.Open
I have a VB app that opens an excel workbook, makes some modifications /
additions, and then saves / closes the workbook. It was working fine until I upgraded to Excel 2003. Now attempting to open the workbook results in an [color blue]Error 1004 - Method 'Open' of object 'Workbooks' failed[/color]. I've determined that the issue is an invalid Worksheet name, so I added the CorruptLoad:=xlRepairFile parameter to my Workbooks.Open instruction. Excel now repairs the worksheet name on open, however now I get a confirmation dialog box that asks if I want to save the repaired file. Is there any way to open the workbook, repair/correct the worksheet name, and continue on making my changes without showing any dialog boxes? Thanks for your help! Charlton |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| when i open an Excell file 3 workbooks open.Why? | Excel Discussion (Misc queries) | |||
| open a spreadsheet with param | Excel Discussion (Misc queries) | |||
| When I open Excel, workbooks open automatically. How can I stop t | Excel Discussion (Misc queries) | |||
| Workbooks.Open closes other workbooks | Excel Programming | |||
| Workbooks.Open / .Open Text - How do you stop the .xls addition? | Excel Programming | |||
Threaded Mode
