METHOD "SELECT" OF OBJECT '_WORKSHEET' FAILED when opening a file

M

Mat

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
 
Top