- Joined
- Apr 26, 2007
- Messages
- 1
- Reaction score
- 0
Hello
When I open an EXCEL file which has links and macro's using Access VBA. I get the usual dialog boxes asking 1) To establish links or not and 2) Enable /disable macros.
I am using the GETOBJECT(FileAddress) cmd to open the Excel file
How can I pre-answer these in Access VBA e.g Can I specify 1) do not establish links & 2) do not enable the macro's and then open the Excel file. Resulting in no pop up boxes to answer.
thanks
When I open an EXCEL file which has links and macro's using Access VBA. I get the usual dialog boxes asking 1) To establish links or not and 2) Enable /disable macros.
I am using the GETOBJECT(FileAddress) cmd to open the Excel file
How can I pre-answer these in Access VBA e.g Can I specify 1) do not establish links & 2) do not enable the macro's and then open the Excel file. Resulting in no pop up boxes to answer.
thanks