Excel Macro Question

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

Guest

I created a Macro in Excel using the macro record option. This macro does
about 15 things to the spreadsheet.

To explain my problem...

I created a program in Access that downloads data to a table and then
queries the table for certain information. I then created a macro that
sends the query to an Excel spreadsheet. Once I open up the file in Excel
it will prompt me whether or not I want to enable or disable the macros and
when I select either option Excel crashes.

I tried this on another computer and it said that the security level needed
to be changed or I need a digital signature. I tried changing the security
level but it didn't work. I'm looking into acquiring a digital signature
(any advice is welcome) but still do not understand why my Excel file will
not work.

Can anyone answer this?


P.S. I tried shortening the steps in my macro to about 5 different things,
several different ways and the file opens and does NOT ask me to enable or
disable the macro. Once open I run the macro and it works fine. Is there a
problem with doing to much in a macro that may cause Excel to act like this?


Thanks for your help.
 
Hi

an alternative idea is rather than transferring the table from access to
excel, create a workbook in excel that imports the access table (data / get
external data / new database query) hopefully you won't experience the same
problem with the excel macro

Cheers
JulieD
 
Back
Top