I’m working on a project using Microsoft Excel 2010 and I want to add some features to facilitate saving and retrieving files process. My experience in excel is developing and would like to learn and sharing ideas in this matter through these queries:
1. How can I save the daily created workbooks (Assume 15 files a day) in order to contain the current date (and time if possible) linked with certain cell(s) I have at my workbook forming the file name? (XYZ 2-4-2014) and/or (ABC 2-4-2014 23:11) and so on … I believe using macros will be to key but I want somebody help me out please.
2. I’ve been through some other posts and I found VB code which saves the active file into specific path, but it is only useful for single workbook because multiple files are getting overwritten automatically. Is there a code which allows multiple/different files saving & creates daily folders?
I hope these two pints are clear enough with the Code ….. Many Thanks!
Bookmarks