Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error message on open
I have recently been playing around with writing VBA in a file. Got the file
working great thanks to the support of this forum, but recently when I opened a file with no VBA, I got the following message just trying to open a regular basic file. Box is titled: Microsoft Visual Basic Message: Class does no support automation or does not support expected interface Options: "OK" or "Help" Does anyone know what this is? -- Thank you for your time! John |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error message on open
John,
the information provided is really not enough to assess the issue, can you try this? 1) close all excel file and open the file that has no VBA and see if this exists? 2) restart your computer and see if this still exists? 3) if that does not fix the issue then open the file again, and this time when you get the error message, hit CTRL+Break key, if for any reason any of your macros/VBA is being triggered then this should break the execution of the code and take you to the VBA code causing this error. let me know the outcome? -kc *Click YES if this helps "Very Basic User" wrote: I have recently been playing around with writing VBA in a file. Got the file working great thanks to the support of this forum, but recently when I opened a file with no VBA, I got the following message just trying to open a regular basic file. Box is titled: Microsoft Visual Basic Message: Class does no support automation or does not support expected interface Options: "OK" or "Help" Does anyone know what this is? -- Thank you for your time! John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
chart error message / work sheet not open ? | Charts and Charting in Excel | |||
After File Open View Preview get error message | Excel Discussion (Misc queries) | |||
Error message when using Excel to open text file | Excel Discussion (Misc queries) | |||
File won't open. Error message "too many different cell formats" | Excel Worksheet Functions | |||
Trying to open Excel/Word files error message "Unable to read file | Excel Discussion (Misc queries) |