hindersaliva
asked on
Dev in Excel 2016 - but problems in Excel 2010 (Option Explicit)
I developed an Excel VBA application in Excel 2016, to be deployed for running in Excel 2010.
In Excel 2010 I get an error "Can't find project or library"
On looking into this I find that ...
Excel 2010 seems to default to Option Explicit. Although I should (!) I have not declared all my variables. How can I turn Option Explicit on?
BUT more interestingly ....!
When I go to the IDE and look in Tools, References is greyed out. So I can't even check if any component is 'missing'.
What's going on here?
Thanks
In Excel 2010 I get an error "Can't find project or library"
On looking into this I find that ...
Excel 2010 seems to default to Option Explicit. Although I should (!) I have not declared all my variables. How can I turn Option Explicit on?
BUT more interestingly ....!
When I go to the IDE and look in Tools, References is greyed out. So I can't even check if any component is 'missing'.
What's going on here?
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Haaaaaaa!
Yes. The 'greyed out' because I was in break mode. Doh!
The reason I getting an 'Option Explicit' mystery (and yes I thought so too Norie, re. it being a default as I had never come across that in my 2010 days) .... I had 'Missing Outlook 2016 Library'. But oddly the code I was running had no need to use that library! So it's still a mystery though I think I'm on my way to clearing this.
In short, I need select the Outlook 2010 Library in Tools > References. Did that and it works.
Yes. The 'greyed out' because I was in break mode. Doh!
The reason I getting an 'Option Explicit' mystery (and yes I thought so too Norie, re. it being a default as I had never come across that in my 2010 days) .... I had 'Missing Outlook 2016 Library'. But oddly the code I was running had no need to use that library! So it's still a mystery though I think I'm on my way to clearing this.
In short, I need select the Outlook 2010 Library in Tools > References. Did that and it works.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I created a small Excel 2016 test of minimal code getting data from an Access 2016 db via ADO. On this it does not mind variables not being declared AND I can get into Tools > References.
This is rather puzzling!
Any thoughts welcome.