Results 1 to 32 of 32

Thread: Problem Killing excel Object...Used to be Access and Excel VBA intermingling

Threaded View

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Jun 2004
    Posts
    28

    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
  •  



Click Here to Expand Forum to Full Width