I have very limited knowledge of VBA, but haven't been able to find code examples of exactly what I want.
I have a workbook with a worksheet named "Data Sheet." Multiple users will open up a read only version of the workbook, enter some data on the "Data Sheet," and then hit a Macro Button that should:
Check to see if a Directory & Sub-Directory exists (I really don't need to know, just trying to avoid errors),
If not, create the applicable directories and save the workbook in the directory.
I will have the following Cells contain text to be used for the directory and file names:
T40 = File Name (e.g., Japan 01-20-2014 John Smith)
T41 = Directory (e.g., FY14) "Fiscal Year"
T42 = Sub-Directory Name (e.g., Japan)
So, if my hard drive just has the directory G:\Everyone\Travel Unit\Foreign Travel\
I want to run the macro and it would ultimately save the file as G:\Everyone\Travel Unit\Foreign Travel\T41\T42\T40.xlsm
or G:\Everyone\Travel Unit\Foreign Travel\FY14\Japan\Japan 01-20-2014 John Smith.xlsm
If found some pre-code that looks like I should stick in front of it to ensure that certain cells have been filled with data before saving. That is:
Any help would be greatly appreciated..
Bookmarks