Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
File name Save
Dear Expert,
A1 has a text "Performance2009_" A2 has a formula =Today() A3 is day(A2) = 11 (in this case) A3 is month(A2) = 4 (in this case) A3 is year(A2) = 2009 (in this case) How can I use concatenate function to make up to "Performance2009_11042009" please ? Second question is .... Say B1 can successfully make up to "Performace2009_11042009" .... How can I use marco (VB) to save the file name same as cell B1 (ie Performace2009_11042009) ? Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SAVE and SAVE AS options disappeared from the drop down FILE menu | Excel Discussion (Misc queries) | |||
when i save xls file, debug script is running and canno't save fil | Excel Discussion (Misc queries) | |||
Excell2003 (SP-1) File > Save and File > Save As.. grayed out | Excel Discussion (Misc queries) | |||
Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) | |||
Save Excel file - prompts to save - no Volitile functions used | Excel Worksheet Functions |