Open Excel from Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to open an Excel Worksheet from Access. I have no problems with
the actual code when doing this. However, I have macros in the Excel file. I
receive a prompt that asks me if I want to enable Macros. I also get a
Continue or Edit Links option. Is there a way through VBA that I can enable
these functions from Access without having the buttons appear each time Excel
is opened?
 
If there is, you'll find it in the Excel part of the universe. Get it
all to work from there and then move your code to Access.

HTH
 
Set Excel macro security to low and get rid of the broken links.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
|I am trying to open an Excel Worksheet from Access. I have no problems with
| the actual code when doing this. However, I have macros in the Excel file.
I
| receive a prompt that asks me if I want to enable Macros. I also get a
| Continue or Edit Links option. Is there a way through VBA that I can
enable
| these functions from Access without having the buttons appear each time
Excel
| is opened?
|
|
 
Back
Top