Export with formatting path

[ariel20029]

I am trying to use the export with formatting function in Access 2007. I want to export to an excel document on my C Drive in a folder called Pending_Waterfall , spreadsheet name CQ to start at cell A1.

What would the full path be?


Thank you so much for your help.
Sharon

 

[ariel20029]

THis is what I tried.
\\C:PENDING_WATERFALL\Booking_REPORT.xlsx\CQ!A:B
forgot the name of the spreadsheet is booking report

 

[alansidman]

This link might be helpful

AccessBlog.net: Export to Excel range: Tips and tricks, news, links, downloads on Microsoft Access