Export to Excel - Specific Cells

J

J. Trucking

Hello,

I was wondering if anyone knew how to export certain fields in an
Access Form to certain cells in an excel spreadsheet. I currently
have a form in Access where the user inputs a date range. A query
then runs and the resulting data is exported to excel using
TransferSpreadsheet. Everything works great. However, is there a way
to export the StartDate and EndDate values from my form to specific
cells within the spreadhseet?

I don't have an extensive background in VBA, but with some help (a lot
of help), my current code:
- Opens an Excel Template
- Saves the doc as .xls
- Then does a TransferSpreadsheet

I am just wondering at which point I should transfer the values of
StartDate and EndDate. My guess would be after the code saves the
file as .xls.

Thanks in advance for any help,

John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook 2021 export question 0
How to export html text as word document with specific size and orientation 0
Word macro that can call cells out of Excel for a find and replace 0
Export to Excel 3
Using Office Forms and dynamically updating the excel backend 0
ISO best steps to export (import) all from Outlook 2003 to Outlook in MS 365 0
Integrating information from Word to Excel (not mail merge) 1
Export Report with Graph to Excel error 2495 1

Top