Send a text to an exel sheet

  • Thread starter Thread starter Afsaneh
  • Start date Start date
A

Afsaneh

when importing data to an exel file using transfer spreadsheet, can I use
useOA argument to send a text as a title for the table? in this case how can
I initial the cell with this value?
and one more question :
since I wanna transfer a crosstab query (rows and cols are variable ) how
can I format the exel sheet?
tnx in advance
 
when importing data to an exel file using transfer spreadsheet, can I use
useOA argument to send a text as a title for the table?
Click to expand...
Yes.

in this case how can
I initial the cell with this value?
Click to expand...
do what?
and one more question :
since I wanna transfer a crosstab query (rows and cols are variable ) how
can I format the exel sheet?
tnx in advance
Click to expand...

most of the answers to questions like these are on Ken Snell's
website.
 
when importing data to an exel file using transfer spreadsheet, can I use
useOA argument to send a text as a title for the table? in this case how can
I initial the cell with this value?
and one more question :
since I wanna transfer a crosstab query (rows and cols are variable ) how
can I format the exel sheet?
Click to expand...

Either use automation after the fact (if you don't know how many
columns will be returned) or export to a template.
 
Back
Top