View Single Post
  #20   Report Post  
Posted to microsoft.public.excel.programming
sowetoddid[_33_] sowetoddid[_33_] is offline
external usenet poster
 
Posts: 1
Default Macro command to open a file

I just found my old post on the question about saving the file a
"OpenedWB - F", with OpenedWB being the actual name of the other fil
in the macro.


Does this work...

ActiveWorkbook.SaveAs FileName:="OpenedWB - F"


How would I specify a directory?


Gracias

--
Message posted from http://www.ExcelForum.com