View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Saveas with name of another file

Hi
e.g.
sub foo()
chdrive "C:\"
chdir "C:\temp"
ActiveWorkbook.SaveAs FileName:="OpenedWB - F"
end sub

--
Regards
Frank Kabel
Frankfurt, Germany


A little uniformed on this,....can you be more specific on how to do
this.

I am a Senior Forum member only because I ask sooo many questions!!

I
just became interested in the VB code and found a lot of

applications.
The problem is I only have enough programming skill to be dangerous.


Thanks.


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