Using Excel Macros in Access

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

Guest

Hello. I'm currently using Access VBA to run Excel Macros. This is working
fine, but I think it would work better if I found a way to write ALL of the
code in Access instead of calling the macro from Excel. Does anyone know if
this is possible to write code in Access that formats an Excel spreadsheet?

Thanks!
 
Hi, thanks for the response.

I have already written Access code that runs the Excel macro. Do you have
any suggestions on what I should do with the Excel code if I want to move it
over to Access? I'm not sure what's the best way to attack this.
 
After you've done what Alex suggests below, you should just be able to copy
your macro text over into the Access code window. Just open your file stream
to excel and have fun!
 
Ok thanks everyone, works like a charm.

Lorenda said:
After you've done what Alex suggests below, you should just be able to copy
your macro text over into the Access code window. Just open your file stream
to excel and have fun!
Click to expand...
 
Back
Top