Export 2 forms to same spreadsheet

[mounty76]

Hi All,

I've searched everywhere and cannot find a solution for this.

I want to export 2 forms into the same excel document but on different tabs. OutputTo the form keeps the formatting in excel, using the transferspreadsheet command gives an unformatted end result in excel.

Is there anyway to use the docmd.outputto command that will add a second tab into an existing excel file rather than overwriting it? Or is it possible to use the transferspreadsheet command on a form? I don't think so...

Any help on this much appreciated!

Cheers

 

[theDBguy]

I haven't tried outputting a form to Excel, but if I want to format the data in Excel, I usually use VBA automation.

 

[mounty76]

Outputting a form to excel works perfectly as it keeps the formatting and filtered data from the form into the excel sheet.....however I don't know how to output two forms into the same workbook.....I don't think its possible hence posting it here as a challenge lol

 

[June7]

Nope. Could OutputTo separate Excel workbooks then combine them with Outlook automation.

Otherwise, use TransferSpreadsheet to export multiple filtered queries to same workbook. Review https://accessmvp.com/KDSnell/EXCEL_Export.htm

 

[mounty76]

SOLVED!

Just found a way to do it, however its automated in access after outputting forms to separate excel files.

This works great and it keeps the same formatting as in the form....

Use Module to merge Excel files

I am attempting to write an Access module to merge two Excel files together. I didn't find anything on this site, but something on another that I can not seem to get working. I don't get any errors, but I don't get any results, either. Any help would be appreciated... Here's what I found...

www.access-programmers.co.uk

 

[DHookom]

Nope. Could OutputTo separate Excel workbooks then combine them with Outlook automation.

Otherwise, use TransferSpreadsheet to export multiple filtered queries to same workbook. Review https://accessmvp.com/KDSnell/EXCEL_Export.htm

Wow! A link to Ken Snell’s great Excel code. He’s been gone for over 4 years yet still is contributing .

 

[theDBguy]

SOLVED!

Just found a way to do it, however its automated in access after outputting forms to separate excel files.

This works great and it keeps the same formatting as in the form....

Use Module to merge Excel files

I am attempting to write an Access module to merge two Excel files together. I didn't find anything on this site, but something on another that I can not seem to get working. I don't get any errors, but I don't get any results, either. Any help would be appreciated... Here's what I found...

www.access-programmers.co.uk

Glad to hear you found an Excel automation solution that works for you. Good luck with your project.

 

[mounty76]

Thanks DBGuy