View Single Post
  #5 (permalink)  
Old November 26th, 2003, 10:18 AM
Piblon Piblon is offline
Authorized User
Join Date: Nov 2003
Location: Horby, , Sweden.
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts

Well, im doing a kind of production reporting programme.
Each month ýou start the template, answer a couple of questions and then the template will save into a normal workbook with a filename depending on the answers from the questions.
This is a bit of the code so you know what I mean
docName = Application.GetSaveAsFilename(fileName, "Excel Workbook (*.xls), *.xls", , "Save Stop Report")
ActiveWorkbook.SaveAs docName, xlWorkbookNormal

quote:Originally posted by chrislepingwell
 Why do you want to know the path to the XLT file in the first place? What are you trying to do?
Reply With Quote