J
JR_06062005
I want to automate a process to export either a tables or queries to an Excel
workbook, give the user the opportunity to name the workbook (I've got that
worked out), name the exported spreadsheets and format the output.
I can accomplish part of my objective with the TransferSpread method. It
allows me to export multiple tables/queries to a single Excel workbook and to
name each spreadsheet. But it does not allow me to format the exported
spreadsheets.
On the other hand the OutToSpreadsheet method allows me to export a
formatted spreadsheet to Excel, but it only allows one exported spreadsheet
per workbook. When I try to export another, rather than add a spreadsheet,
it overwrites the workbook. Also, it does not allow me to designate a name
for a spreadsheet.
I've written a Macro in Excel that formats the spreadsheet and this works
fine with the TransferSpread method when I am the one exporting the
spreadsheet. However, for other users, they have to manually format the
spreadsheets.
I apologize for the long post, but the longer post was required to
adequately explain the problem.
If someone can give me some advice/assistance with this issue, I would
really appreciate it.
workbook, give the user the opportunity to name the workbook (I've got that
worked out), name the exported spreadsheets and format the output.
I can accomplish part of my objective with the TransferSpread method. It
allows me to export multiple tables/queries to a single Excel workbook and to
name each spreadsheet. But it does not allow me to format the exported
spreadsheets.
On the other hand the OutToSpreadsheet method allows me to export a
formatted spreadsheet to Excel, but it only allows one exported spreadsheet
per workbook. When I try to export another, rather than add a spreadsheet,
it overwrites the workbook. Also, it does not allow me to designate a name
for a spreadsheet.
I've written a Macro in Excel that formats the spreadsheet and this works
fine with the TransferSpread method when I am the one exporting the
spreadsheet. However, for other users, they have to manually format the
spreadsheets.
I apologize for the long post, but the longer post was required to
adequately explain the problem.
If someone can give me some advice/assistance with this issue, I would
really appreciate it.