Open Excel from Access

R

RobSol

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?
 
L

Larry Daugherty

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
 
D

Dave Patrick

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?
|
|
 
Top