A
Andrew Tapp
I have just come across an issue when opening a macro enabled spreadsheet
within Access 2000.
I would normally use the code;
Dim appXLS As New Excel.Application
Dim xlsWB As Excel.Workbook
Set xlsWB = appXLS.Workbooks.Open("c:\Skew.xls")
.....
to open a spreadsheet within Access, however it would appear if this
spreadsheet has underlying code within it (i.e. when you open it within Excel
you are asked for the comfirmation if you want to enable/disable macros) then
the Open statement within Access freezes. It the spreadsheet does not have
any code then it opens correctly within Access and i can then process the
contents.
Has anyone seen this, and can you suggest a way around?
Many thanks.
within Access 2000.
I would normally use the code;
Dim appXLS As New Excel.Application
Dim xlsWB As Excel.Workbook
Set xlsWB = appXLS.Workbooks.Open("c:\Skew.xls")
.....
to open a spreadsheet within Access, however it would appear if this
spreadsheet has underlying code within it (i.e. when you open it within Excel
you are asked for the comfirmation if you want to enable/disable macros) then
the Open statement within Access freezes. It the spreadsheet does not have
any code then it opens correctly within Access and i can then process the
contents.
Has anyone seen this, and can you suggest a way around?
Many thanks.