I have a file in Excel 2007 that pulls data with the ODBC from a LAN. It is set to refresh upon opening. However, this file will be used by many within the company and the user must enable external data for the current data to come through.
Here is my question. Is there a way (through VBA or other means) to check if the user has external data enabled and then have maybe a message box pop up asking them if they want to enable it? Clicking "OK" would enable the connection?
P.S. The average computer skill level for users is low to moderate.
Any ideas are appreciated. Thanks.
Here is my question. Is there a way (through VBA or other means) to check if the user has external data enabled and then have maybe a message box pop up asking them if they want to enable it? Clicking "OK" would enable the connection?
P.S. The average computer skill level for users is low to moderate.
Any ideas are appreciated. Thanks.
