Using ACC2007 and calling Excell 2007
I ran this module without issue last night but today it is throwing me a compile error as "object library feature not supported" with oSheet highlighted.
The line causing the problem is
oSheet is dimmed as Excel.Workbook and there is a reference to Microsoft Excell 12.0 Object Library. The purpose is to manipulate formatting on a worksheet.
The only difference is I have added a line at the bottom to open the Excel file on screen
However, if I comment this out the compile still fails so it isn't that.
Any thoughts as to why/what?? Any help much appreciated. Thanks
I ran this module without issue last night but today it is throwing me a compile error as "object library feature not supported" with oSheet highlighted.
The line causing the problem is
Code:
Set oSheet = xlwkb.Sheets("qryGMExport")
The only difference is I have added a line at the bottom to open the Excel file on screen
Code:
FollowHyperlink strPathFile
Any thoughts as to why/what?? Any help much appreciated. Thanks