Jeff

Try

Sub Macro2()
ActiveWorkbook.SaveAs Filename:=ActiveWorkbook.Path & "\" &
"Book2.xls"
End Sub

or something along that line.

Ken
















On Oct 12, 2:54*pm, jeff wrote:
During a macro, I will move data to a new workbook. Then I will to do
a Save-as to name the new book. *What I need to know is the coding to
do this Save-as in the current folder without regard to the drive
letter.

I don't know the drive letter a user will have these files in, nor
will I necessarily know the folders they will be in. But, I want the
new workbook to be in the same folder as the original.

Example, from the original file (which contains the macro), a new
workbook is created. Data from the original is copied then pasted in
the new workbook. This stuff I know how to do....
At this point I need help. I need to instruct the macro to do a Save-
as using the file name of Test.Xls. * *No path, no drive letter.
I've looked at old posts, and cannot find this.
Thanks
j.o.