Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening a document without adding the path
Hey everyone. I've got this code: Workbooks.Open ("C:\Documents and settings\tmf\Desktop\NY\TEST\template.xls") ActiveWorkbook.SaveCopyAs "C:\Documents and Settings\tmf\Desktop\NY\TEST\template1.xls" I run this code from another file in the some folder "TEST". I would like to be able to run "template.xls" WITHOUT adding the path of the folder "TEST". Of course the file with the code should be in the same folder. I HTML one just say :\template.xls - how about VBA? Please help me! :) Best regards and thank you. /Tommy -- Tmf ------------------------------------------------------------------------ Tmf's Profile: http://www.excelforum.com/member.php...o&userid=24985 View this thread: http://www.excelforum.com/showthread...hreadid=385265 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening a document without adding the path
TMF,
Exactly what you're asking is a little unclear however I think the answer will lie with either the .Path property or the .FullName property of the workbook object. Regards, Vic Eldridge "Tmf" wrote: Hey everyone. I've got this code: Workbooks.Open ("C:\Documents and settings\tmf\Desktop\NY\TEST\template.xls") ActiveWorkbook.SaveCopyAs "C:\Documents and Settings\tmf\Desktop\NY\TEST\template1.xls" I run this code from another file in the some folder "TEST". I would like to be able to run "template.xls" WITHOUT adding the path of the folder "TEST". Of course the file with the code should be in the same folder. I HTML one just say :\template.xls - how about VBA? Please help me! :) Best regards and thank you. /Tommy -- Tmf ------------------------------------------------------------------------ Tmf's Profile: http://www.excelforum.com/member.php...o&userid=24985 View this thread: http://www.excelforum.com/showthread...hreadid=385265 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
document path stamp | Excel Discussion (Misc queries) | |||
Need to add the path to my document | New Users to Excel | |||
Path to Lookup from another document | Excel Discussion (Misc queries) | |||
Opening a document without adding the path | Excel Programming | |||
Determining path to document template | Excel Programming |