Odd reference issue (1 Viewer)

[Malcy]

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

    Set oSheet = xlwkb.Sheets("qryGMExport")

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

FollowHyperlink strPathFile

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

 

[Rabbie]

It may be worth dimming oSheet as Excel.Worksheet

 

[Malcy]

Thanks Rabbie but it already is!

    Dim oSheet As Excel.Worksheet

That is what is so puzzling.

 

[Rabbie]

Thanks Rabbie but it already is!

    Dim oSheet As Excel.Worksheet

That is what is so puzzling.

Sorry in post 1 you have

oSheet is dimmed as Excel.Workbook

That's what confused me

 

[Malcy]

Sorry my stupid - too much haste!
Anyway issue now sorted. For future reference what I did was uncheck the reference to Excel 12.0 then close references and save VBA. Then reopen VBA and re-check the Excel 12.0, save, and away it went without so much as a by your leave.
At a loss to explain!
Thanks for the help anyway

Malcy