Copy an Excel Template to the Desktop

  • Thread starter Thread starter Jeefgeorge
  • Start date Start date
J

Jeefgeorge

If I have a template for an Excel (.xlt) File saved in the same folder as my
back end, is there a way to program access create a copy (.xls) on the
current users desktop?

Also, I have the file path to get to the current users desktop, but is there
a way to use the file path where the database is stored without hardcoding
(C:\....) it in?
 
Here's a layout of what I would like to do
'Copy ProjBook.xlt from database folder and paste as .xls
'Paste ProjBook.xls to CurrentUser.SpecialFolders("Desktop")
DoCmd.TransferSpreadsheet acExport, 8, "Proj Info Transpose",
Dsktp, ,
"ProjInfo"
DoCmd.TransferSpreadsheet acExport, 8, "Engineer's Estimate",
Dsktp, ,
"BidtabRaw"
DoCmd.SetWarngins False
Application.FollowHyperlink Dsktp
DoCmd.SetWarnings True
 
Back
Top