Using Excel Macros in Access

[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!

 

[Alex Dybenko]

Hi,
If you set a reference to Excel in Access mdb - then you can write VBA code
to manipulate Excel objects in Access. Search KB Support.microsoft.com for
Excel.Application and you will find lot of samples

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Guest]

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.

 

[Guest]

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!

 

[Guest]

Ok thanks everyone, works like a charm.

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!