Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Cell C2 contains a date in this format: 7/23/2006 How can I convert that date and place it in this file path automatically, I put the result I need in bold? ='C:\Documents and Settings\PC\My Documents\Green Books\[GB_*072306*-Q6150.xls]DailyWS'!$D$5 Thank you, Em -- Emma317 ------------------------------------------------------------------------ Emma317's Profile: http://www.excelforum.com/member.php...o&userid=36598 View this thread: http://www.excelforum.com/showthread...hreadid=563417 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create filename based on cell contents | Excel Worksheet Functions | |||
Macro to Save As with filename based on cell contents. | Excel Programming | |||
How can I insert the contents of a cell as a filename? | Excel Programming | |||
Create filename based on cell contents | Excel Programming | |||
cell contents as filename | Excel Programming |