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


"Jeefgeorge" wrote:

> 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?