Copy an Excel Template to the Desktop

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

Jeefgeorge

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I have exported to Excel but the file is copied twice? 7
using xltm as template 2
Error 0xC00D3E8E: The property is read only. One way to fix. 1
Template on Server 2008 5
Oddity when opening templates from code 2
How to open .xlt in VBA? 4
XLT vs XLS 8
Excel template and default save name 1

Top