|
|
#1
03-23-2012, 05:49 PM
|
|||
|
|||
* Exporting Access Data to Excel
Hello Everyone,
Thank you for your help! I'm using the following code in Access to export data to Excel. It works fine but each time I export, it creates a new Tab in the Excel spreadsheet. Is there anyway to specify the name of the tab I want to export to and use the same tab every time? Code:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, _ "tblAdvancedPricing", outputFileName, True, "AdvancedPricing" I would really appreciate your assistance! 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Exporting Timline Milstone Data | OTPM | Project | 0 | 04-06-2011 02:34 AM |
 Exporting PST data
|
metfuel | Outlook | 2 | 01-19-2011 04:46 PM |
| Question about Outlook 2010 and exporting data | sharke | Outlook | 0 | 10-17-2010 03:30 PM |
| Excel 07-Access 03 Data Link Issue | ddw23 | Excel | 0 | 08-20-2010 09:05 AM |
|
Exporting data
|
dsmithers | Outlook | 2 | 06-24-2009 09:58 AM |
Windows 7 
Office 2007
Threaded Mode