add check if date folder exist - if not create - and modify Save As line to place new file

**3345james** · 12-18-2015, 05:57 PM

Any help here would be appreciated -

I'd like to modify the following code to include - first look to see if folder exists (The existing folder name should be today's date -mm-dd-yyyy)
IF it doesn't exist then create it - if does exist then continue

The line "C:\Users\Jim\Documents\!LGTC\Network\" & _ - - -needs the today's date folder added to the path (\Network\????\" &_

Please Login or Register  to view this content.

**JBeaucaire** · 12-19-2015, 03:28 AM

Something like this:

Please Login or Register  to view this content.

**3345james** · 12-19-2015, 08:01 AM

Thanks so much - this works perfect!
I appreciate your time, skill and keeping it simple
I'll mark this as solved

add check if date folder exist - if not create - and modify Save As line to place new file

LinkBack

Thread Tools

Rate This Thread

Display

add check if date folder exist - if not create - and modify Save As line to place new file

Re: add check if date folder exist - if not create - and modify Save As line to place new

Re: add check if date folder exist - if not create - and modify Save As line to place new

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA to save a workbook to a folder but create that folder if it doesn't already exist

[SOLVED] Check if folder and file exist

Code to create New Folder (if doesn't exist) and then Save Workbook to folder

Save a file to a folder, create folder if it doesn't exist

Create Folder with system date then save file to folder

Save file in a new folder, but create folder only if folder doesn't already exist?

[SOLVED] Command Line. How to tell to XL : If the xls file exist : Open it, if it does not exist : Create it.

Bookmarks

Bookmarks

Posting Permissions