this will create a new workbook - then refer to this name when you do your pastes
Workbooks.Add
ActiveWorkbook.SaveAs FileName:= _
"C:\put your file name with directory here.xls"
this will create a new workbook - then refer to this name when you do your pastes
Workbooks.Add
ActiveWorkbook.SaveAs FileName:= _
"C:\put your file name with directory here.xls"
not a professional, just trying to assist.....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks