Macro save with referenced filename and time
The following macro works but I would like to make it more complex but I get error when I try to reference a cell for a file name.
How can I get my macro to change from naming "Example file name" to reference a changeable file name typed in cell in my worksheet such as cell B,3 on sheet(1) in a multiple sheet wookbook?
Also the hh-mm-AMPM always stamps at 12:00AM and not the correct time.
Please Login or Register to view this content.
Last edited by rockhunter; 11-11-2011 at 04:57 PM.
Hello rockhunter,
The time stamp indicates the cell value is zero. The cell referenced in your macro is D10. What are the current contents of this cell?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
D10 has a path to the network drive where I want the file to be saved.
Example X:\reports\test worksheets\
the macro does save over to the network folder that I want it to with the path in D10.
However when I try to modify the file name to save as what ever value is referenced to a different cell in the spreadsheet such as D3 it errors on me and just saves as a date stamp and no file name.
I would like to replace
with somthing like this with a file name in a cell:Please Login or Register to view this content.
However this gives me syntax errorPlease Login or Register to view this content.
Re: Macro save with referenced filename and time
Figured it out...this seems to work. I'll put my revised code in this thread. This macro saves the file to a network path from cell D10 with a file name in cell D3 and places a day time and hour value on the file in this format EX: X:\Documents\reports\test11_11_2011 15_29.xltm.
Please Login or Register to view this content.
Last edited by rockhunter; 11-11-2011 at 05:38 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks