Transfer Text to specific Excel Tab

D

Dean Knox

Hi,

I am using the transfer text ac export procedure to save a table to Excel.

My problem is: I want to transfer 3 tables on different tabs within 1 Excel
document. Is this possible?

If so what is the code?

Thanks in advance.

Dean
 
D

David Lloyd

Is there a reason why you are using the TransferText method rather than the
TransferSpreadsheet method? I believe, although I have not tested it, that
if you give the same workbook name to each invocation of the
TransferSpreadsheet method that it will create a separate tab for each
Table, with the table name being the name of the tab.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Hi,

I am using the transfer text ac export procedure to save a table to Excel.

My problem is: I want to transfer 3 tables on different tabs within 1 Excel
document. Is this possible?

If so what is the code?

Thanks in advance.

Dean
 
K

Ken Snell [MVP]

David Lloyd said:
I believe, although I have not tested it, that
if you give the same workbook name to each invocation of the
TransferSpreadsheet method that it will create a separate tab for each
Table, with the table name being the name of the tab.
Click to expand...

Yes, this is correct.
 
Top