is it possible to specify wb & wsheet name in design of "Output To" macro

[mancubus]

hi all.

how can i specify the existing workbook and existing worksheet name into which my table will be exported. using built-in Output To macro.

[CreganTur]

I can't help you with configuring the macro (I'm a VBA elitist- I hate macros because they're not as flexible and robust as VBA and they're not coded very well), but I can porivde you with some VBA help.

Take a look at this link about the TransferSpreadsheet Method (http://msdn.microsoft.com/en-us/library/aa220766(v=office.11).aspx). This is the vba method I use to export data to Excel.

[mancubus]

thanks randy.

will check.

[mancubus]

oooops...

:banghead:
i am using acc2003 and trying to export to xl2007, which is impossible afaik.
:banghead:

[surveyasbe]

Is it possible to reference a named range in a workbook that is not active, one that has been closed but still available within a directory. This closed workbook has named ranges that are being added to from time to time so the named range is growing.

[stanl]

oooops...

:banghead:
i am using acc2003 and trying to export to xl2007, which is impossible afaik.
:banghead:

Not really (for exporting the data); just use the Ace.OLEDB.12 driver.