View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sir_glen sir_glen is offline
external usenet poster
 
Posts: 1
Default A macro that can save a file?


Is it possible to make a macro the will save the current spreadsheet?

I want to make a macro the will save the spreadsheet with the filenam
A2_A3.xls

So if A2 was "Bloggs" and A3 was "Joe" the file would save a
Bloggs_Joe.xls

I've allready made the macro clear certain cells but I've only don
this by using the record macro function and editing out certain part
cause I don't really understand visual basic

Thanks in advance.

Gle

--
sir_gle
-----------------------------------------------------------------------
sir_glen's Profile: http://www.excelforum.com/member.php...fo&userid=1476
View this thread: http://www.excelforum.com/showthread.php?threadid=27333