Generating an Excel document with a Macro
Hi,
I'm generating an excel program using VB from an Access Document. What I'd like to have also is a macro in the generated excel document which is incerted into this document via the access code. For example, supose my access document generates an excel document with a single contol button on it. When you click on this button, the current time is then copied to a cell via the macro. How do I do this? Thanks for your help, Barry. |
Generating an Excel document with a Macro
Barry,
http://www.cpearson.com/excel/vbe.htm NickHK wrote in message oups.com... Hi, I'm generating an excel program using VB from an Access Document. What I'd like to have also is a macro in the generated excel document which is incerted into this document via the access code. For example, supose my access document generates an excel document with a single contol button on it. When you click on this button, the current time is then copied to a cell via the macro. How do I do this? Thanks for your help, Barry. |
All times are GMT +1. The time now is 01:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com