Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
METHOD "SELECT" OF OBJECT '_WORKSHEET' FAILED when opening a file
Hello,
I created a macro that opens a file which has links to Bloomberg. The VBA code stops when trying to open this Bloomberg Excel file. Is there a way to just open the file without the links. I already put application.displayalert=false and said NO to update the links. I need to put some data in it, save and close. Even when I'm opening the Bloomberg Excel file without the macro I still ahve this problem so maybe its within this file the problems which also have macros built-in. If this is the case, is there a way to do an auto_open which would disable the Bloomberg links and would use a different code than updatelinks:= 0 Thx Mat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"method 'execute' of object 'find' failed" | Excel Discussion (Misc queries) | |||
Method 'MailEnvelope' of object '_Worksheet' failed | Excel Discussion (Misc queries) | |||
Method 'Paste' of object '_Worksheet' failed | Excel Discussion (Misc queries) | |||
VBA error 1004 "Select method of Range class failed" | Excel Programming | |||
"Run-time error '1004'" Method 'Range' of object '_global' failed. | Excel Programming |