Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Templates Path Question
Hello Ron
is it possible to use the same type of application method to get to the my documents folder of any one? eg. Application.TemplatesPath would change to application.usernamepath? or something like that. Thanks "Ron de Bruin" wrote: Hi Liz I use a install workbook to install a sheet template Part of the code : ThisWorkbook.Sheets("RDBMail").Copy Set wb = ActiveWorkbook With wb wb.SaveAs Application.TemplatesPath & "RDBMail.xlt", _ FileFormat:=xlTemplate .Close False End With Maybe you can use it http://www.rondebruin.nl/mail/templates.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Jim Rech" wrote in message ... Yes, I was referring to the user's actual name. The better setup programs can determine things like this and incorporate them. If yours can't I don't know what you can do. -- Jim Rech Excel MVP "Liz" wrote in message ... | If you mean use the actual username, can't do that, 700+ users will be extracting this. If you mean actually type <username, doesn't work. My predecessor had it going into the user's own folder - can't figure out how he did it. | | "Jim Rech" wrote: | | I believe the correct path is: | | C:\Documents and Settings\<username\Application Data\Microsoft\Templates | | -- | Jim Rech | Excel MVP | "Liz" wrote in message | ... | |I am trying to create a self extracting exe to install excel templates into | a current users templates folder. I've tried these paths and it won't work: | | | | C:\Documents and Settings\Default User\Application | Data\Microsoft\Templates | | | | C:\Documents and Settings\All Users\Application Data\Microsoft\Templates | | | | Thanks | | | |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 5 and Excel 2000 question. | Excel Discussion (Misc queries) | |||
Question about Excel | Excel Discussion (Misc queries) | |||
Weird question on filling in typing in excel | Excel Discussion (Misc queries) | |||
auto file path update when excel sheet moved to another directory. | Excel Discussion (Misc queries) | |||
Downloading Templates for Excel error with a windows error. | Excel Discussion (Misc queries) |