filename saving

[DannyTmoov2]

Simple relative saving problem: I have a macro that opens a new workbook and saves it with a filename, how do I save it to the same location as the original file (i.e. without c:\folder1\folder2\filename.xls)
Currently using
ActiveWorkbook.SaveAs FileName:="c:\folder\filename.xls"

but would like to just save as "filename.xls" in same folder as the workbook that launched the macro. currently just saves it in c:\filename.xls

Cheers

 

[lambuhere1]

Use

old_path = activeworkbook.path
' to get the path which has the macro run.

And use this to save your workbook.

ActiveWorkbook.SaveAs FileName:=old_path + "\filename.xls"


Hope this helps.

Ram P

 

[DannyTmoov2]

Nice one Bro!