captkirkrules wrote:
I am trying do do a Macro to transferspreadhseet to a XLS file - I can
do this with the "Transferspreadsheet" macro - but I want to tell it
what sheet to put it on within the workbook.
From the Help file:
"If the file name is the same as the name of an existing spreadsheet,
Access replaces the existing spreadsheet, unless you're exporting to an
Excel version 5.0 or later workbook. In that case, Access copies the
exported data to the next available new worksheet in the workbook."
I'm not sure about this, but I believe you give the worksheet name w/
the file name. Like this:
FileName: C:\tmp\MyWorkBook.xls!TheWorkSheetName
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
From the Help file:
"If the file name is the same as the name of an existing spreadsheet,
Access replaces the existing spreadsheet, unless you're exporting to an
Excel version 5.0 or later workbook. In that case, Access copies the
exported data to the next available new worksheet in the workbook."
I'm not sure about this, but I believe you give the worksheet name w/
the file name. Like this:
FileName: C:\tmp\MyWorkBook.xls!TheWorkSheetName
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQuVEKYechKqOuFEgEQJHtgCgwhWDmfDFY/kJ/Dz+jPaLIJ/IVRMAnjf+
y7ZoHOgC+CkllRtBK2WA773d
=NVEt
-----END PGP SIGNATURE-----