Hi there,
I have an excel enabled file that needs to open another Excel file and copy an image from that file, however, this Excel file that I wish to open has a "Private Sub Workbook_Open()" macro that runs and has a couple of messages that require a response.
As I wish to have the opening of the file performed by vba, how do I suppress the workbook open macro?
My code at present is
Workbooks.Open Filename:=strFile
where strFile is the path and file name of the file I wish to open.
Thanks in advance.
I have an excel enabled file that needs to open another Excel file and copy an image from that file, however, this Excel file that I wish to open has a "Private Sub Workbook_Open()" macro that runs and has a couple of messages that require a response.
As I wish to have the opening of the file performed by vba, how do I suppress the workbook open macro?
My code at present is
Workbooks.Open Filename:=strFile
where strFile is the path and file name of the file I wish to open.
Thanks in advance.