export to excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to use the "Transferspreadsheet" macro for Forms? I'm trying
to transfer a form over to excel, and I have it set up right now as "Output
to". It works fine, but i would like to have a template excel file that's
already pre-edited with conditional formating that the data goes into....

any ideas?
 
AFAIK it's not possible to get TranferSpreadsheet to export to a
formatted sheet. Instead, automate Excel from Access VBA code, to create
a new workbook from your template and insert the data using the
Range.CopyFromRecordset method.
 
Thanks!! i saw that page before, but it didn't make sense to me at first, but
after reading it reeeeeeally carefully, i got it. Thanks again!
 
hello dear sir,
is possible to export many querys to single spredsheet like this
(1) create an excel object
(2) cells(1,1).value = query1
(3) cells(1,2).value = query2
(4) cells(1,3).value = query3
(5) cells(1,5).value = cells(1,1) + cells(1,3)
how to do this
or create an excel object and import the query also will work out but how
any one please advise ?
 
dearsir,
thanks for your kind help regarding my question " export many querys to an
epredsheet"
(1) i stil not met my entire needs viz
there should not be any external references like Templates which will cause
errors on distribution of the application to others or by accidental deletion
of excel templatte file.
(2) im exactly trying to create an excel object and export the querys may be
one or more to the perticular cells and do extra calculations on it cells and
have an report
finally relese the object from the memory
(3) another problom im facing is my querys are based on date criteria and
department criteria how to display them on the spred sheet top,header ?
i beg for your extra advise please.
 
Back
Top