J
Jessica
Hi,
I know this has been posted using TransferSpreadsheet, or OutputTo and I
understand how those all work.
What I want to do is transfer my access information into a formatted excel
document (i.e. with freeze panes, shading, column widths). Does anyone know
if you can use a excel template with TransferSpreadsheet in code, or macro?
I tried to transferspreadsheet export to a formatted excel spreadsheet with
two tabs named and formatted, and reference those in the transferspreadsheet
specs, but it just added two new tabs.
Oh and I also need to make 1 spreasheet per office (i.e. each table has 10
office names in it). End results 10 spreadsheets, with two tabs of info.
I've been able to use the filter with output to, but not transferspreadsheet.
Thanks,
Jessica
I know this has been posted using TransferSpreadsheet, or OutputTo and I
understand how those all work.
What I want to do is transfer my access information into a formatted excel
document (i.e. with freeze panes, shading, column widths). Does anyone know
if you can use a excel template with TransferSpreadsheet in code, or macro?
I tried to transferspreadsheet export to a formatted excel spreadsheet with
two tabs named and formatted, and reference those in the transferspreadsheet
specs, but it just added two new tabs.
Oh and I also need to make 1 spreasheet per office (i.e. each table has 10
office names in it). End results 10 spreadsheets, with two tabs of info.
I've been able to use the filter with output to, but not transferspreadsheet.
Thanks,
Jessica