I using Microsoft Access (2013) and Excel (2013) Automation and VBA inside an Access module to open an Excel "xls" file which I was given. That xls file is evidently a report with tab delimiters which was someh0w converted to an xls file. Wehn the file is opened I get a cautionary message to which I must manually respond which I must avoid.
Using VBA in this mode and Open.Workbook PathandFile, sometimes to workbook opens and is visible on the screen, other times the workbook is hidden. It's repeatedly open, but never consistently is displayed.
Is there any code to avoid the cautionary message. Docmd.SetWarnings = False has no effect. The message still fires.
Is there VBA code which will "unhide" the hidden workbook.
Surely, someone has encountered this before.
I'll post the VBA code I use and the message tomorrow. Without, someone might have an answer.
Thank you in advance for your courtesies.
Using VBA in this mode and Open.Workbook PathandFile, sometimes to workbook opens and is visible on the screen, other times the workbook is hidden. It's repeatedly open, but never consistently is displayed.
Is there any code to avoid the cautionary message. Docmd.SetWarnings = False has no effect. The message still fires.
Is there VBA code which will "unhide" the hidden workbook.
Surely, someone has encountered this before.
I'll post the VBA code I use and the message tomorrow. Without, someone might have an answer.
Thank you in advance for your courtesies.
