Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.crashesgpfs,microsoft.public.excel.programming
|
|||
|
|||
Workbooks.Open fails after upgrade to XL2000 from XL97
Frank,
What exactly is failing? I can run your three lines of code in Excel XP without error. Have you tried placing a break point in your code so you can see exactly what line of code is causing the error? "Frank" wrote in message ... I have a workbook with a number of macros and forms in it. It had been working fine under XL97. I have upgraded to XL2000 and now it fails. The code is: bookVBInput = Application.GetOpenFilename(, , "Open VB Input File") If bookVBInput = False Then Exit Sub Workbooks.Open FileName:=bookVBInput When the Workbooks.Open statment is executed I get a dialog saying: Runtime error '1004' Application-defined or object-defined error The code is in ThisWorkbook object and is in routine: Public Sub Components_CreateFromVB() The routine is called from a form button code which is: Private Sub CommandButtonCreateComponents_Click() Call ThisWorkbook.Components_CreateFromVB End Sub When I get the dialog and click on the Debug button, the execution point is back at the call, not on the open statement. Any ideas? Thanks, Frank Clifton |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL2000 Links Between Workbooks | Excel Worksheet Functions | |||
Web Query fails with "you need to upgrade flash" message | Excel Discussion (Misc queries) | |||
XL97 changes filenames upon open | Excel Discussion (Misc queries) | |||
cannot open an xl97 file | Excel Discussion (Misc queries) | |||
Can not open .wb1 file with XL2000 and XL2002 | Excel Discussion (Misc queries) |