-
I saw this done before but don't remember how and where...
to start.
We used an access database to compile all of our general ledger accounts and balances. then, by pressing a button, an already existing spreadsheet which was our financial report would be automatically populated with the numbers in the database. The cells in the spreadsheet were spread out all over the spreadsheet so each field in the database would have to be referenced to a specific spreadsheet cell number somehow.
Do you know what the function is that I need to use? Is it TransferSpreadsheet? Where do I start? Thanks!
-
You would use TransferSpreadsheet to export an Access object, such as a query result set or a table, to Excel.
For what you are describing, it sounds more like you would want to open a recordset in code, substantiate an Excel.Application object, and then through that object populate ranges in a worksheet with values from the recordset.
Can you be a little more specific about what you need to do?
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