|
-
Jul 8th, 2004, 08:26 AM
#1
Thread Starter
Junior Member
Problem Killing excel Object...Used to be Access and Excel VBA intermingling
Hey everyone,
I got this button in access that exports data to a existing excel spreadsheet on my desktop. After it does this I need to run a macro to format the newly exported data. I was wondering if I could perhaps refine this process so that after I push the button in access it
1) Will autocreate a blank excel file
2) Export the data to this file [ I have this code already]
3) Open the newly created file
4) Run a Excel "Macro" to format the data [I have the code to format the data, just need to know if and how its possible to execute this code from access cause if we are creating a new excel sheet then there can be no predefinded macros, right?]
So in essence i need to figure out if i can play around with excel functions from within access VBA, If anyone can help me out with this id highly appreciate it.
Thanks
Doc
Last edited by doctor; Jul 9th, 2004 at 11:10 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|