View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vic49 Vic49 is offline
external usenet poster
 
Posts: 1
Default Save Spreadsheet As 2 or 3 cell values

I would like to automatically name the the file with some static text and
thevalues from 2 or 3 cells. For example:

I am creating a expense account and I would like the the name to be:
XYZ_Expenses_"Date"_"Amount"

Whe
XYZ_Expenses is Static test,
Date is located in cell J3,
Amount is located in cell J30

I am not very familiar with using or building macros, so any information on
how to build and run the macro and would be greatly appreciated. Thanks in
advance.

Win XP and Excel 2007