Transferspreadsheet

J

John C

Hello,
I have a macro where I use TransferSpreadsheet to export a table into
excel. The file path where the file is
="A:\Funds_"&[Forms]![frmChooseExportData].[cmbDivisionExport]&"_" &
Format(Date(),"yyyymmdd") & Format(Time(),"hhnnnss".

If I want to export the table into excel to a CD on a "CD writer drive) like
E:\
or F:\

Is there a way to do this?

Thanks!

John C
 

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

Exporting Outlook 2007 contact list without losing groups 0
Working outlook via vba code with xlsx - error 0
VBA - exporting serial letters to single documents 0
Solved Disk Full error message when exporting PDF 0
Macro to copy table of contents to a new doc 0
TransferSpreadSheet Export to "here" 6
Setting column width in a table with a macro is not working 0
Using Office Forms and dynamically updating the excel backend 0

Top