loves_automation
New Member
- Joined
- Feb 21, 2002
- Messages
- 7
Right now, I am trying to create a macro which will pull the date out of a string of text found in a cell and save the workbook the value of the cell in A1 plus the date.
So, for instance, I have the following text in cells A1 and A2, respectively:
Total Education
Structure Build Time:02/15/2002 04:57:00 AM
What I would like to do is to save the file as "Total Education 02.15.02" (note the date format I'd like to save the file as is slightly different than that of the formatting in the original cell). I know how to save a file with the value of cell A1 from one of your other articles, so I guess my question is, how can I parse the date out of cell A2 into a variable so that I can use it when saving the workbook?
So, for instance, I have the following text in cells A1 and A2, respectively:
Total Education
Structure Build Time:02/15/2002 04:57:00 AM
What I would like to do is to save the file as "Total Education 02.15.02" (note the date format I'd like to save the file as is slightly different than that of the formatting in the original cell). I know how to save a file with the value of cell A1 from one of your other articles, so I guess my question is, how can I parse the date out of cell A2 into a variable so that I can use it when saving the workbook?