+ Reply to Thread
Results 1 to 6 of 6

Create Folder & Check if Folder Exists if Not Create Folder & then Save File

  1. #1
    Forum Contributor
    Join Date
    05-23-2017
    Location
    Bang, India
    MS-Off Ver
    MS Office 2007
    Posts
    221

    Create Folder & Check if Folder Exists if Not Create Folder & then Save File

    Hello everyone......I have the following code helped by someone in the forum to save a file in the said format of date and time as below. I want this code modified to do the following:
    1. To create a folder named with current day's date in the format "DDDD, DDMMMYYYY" in the directory "F:\Pending File Status"
    2. To save the file in the path shown below.
    Please note that as this is a process which is repeated through the day.
    I need code to also check if folder created in 1. above is created, if created then save the next process as in the same date folder and file path. The date refers to system time FYI.

    Will someone help shed some light on this....as I am having problem sorting this out......

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    05-23-2017
    Location
    Bang, India
    MS-Off Ver
    MS Office 2007
    Posts
    221

    Re: Create Folder & Check if Folder Exists if Not Create Folder & then Save File

    Just forgot to mention....this......is there a way to modify this code to save the file with the dates found in Column Q (which is a range of 3 or 6 different dates).

  3. #3
    Forum Contributor
    Join Date
    05-23-2017
    Location
    Bang, India
    MS-Off Ver
    MS Office 2007
    Posts
    221

    Re: Create Folder & Check if Folder Exists if Not Create Folder & then Save File

    with formats as below.... 7/24/2017

  4. #4
    Forum Contributor
    Join Date
    05-23-2017
    Location
    Bang, India
    MS-Off Ver
    MS Office 2007
    Posts
    221

    Re: Create Folder & Check if Folder Exists if Not Create Folder & then Save File

    Hello everyone......I have the following code helped by someone in the forum to save a file in the said format of date and time as below. I want this code modified to do the following:
    1. To create a folder named with current day's date in the format "DDDD, DDMMMYYYY" in the directory "F:\Pending File Status"
    2. To save the file in the path shown below.
    Please note that as this is a process which is repeated through the day.
    I need code to also check if folder created in 1. above is created, if created then save the next process as in the same date folder and file path. The date refers to system time FYI.
    Will someone help shed some light on this....as I am having problem sorting this out......
    Just forgot to mention....this......is there a way to modify this code to save the file with the dates found in Column Q (which is a range of 3 or 6 different dates).
    with formats as below.... 7/24/2017.....
    So far, no one has a solution is it????

  5. #5
    Forum Contributor
    Join Date
    05-23-2017
    Location
    Bang, India
    MS-Off Ver
    MS Office 2007
    Posts
    221

    Re: Create Folder & Check if Folder Exists if Not Create Folder & then Save File

    Hello everyone......I have the following code helped by someone in the forum to save a file in the said format of date and time as below. I want this code modified to do the following:
    1. To create a folder named with current day's date in the format "DDDD, DDMMMYYYY" in the directory "F:\Pending File Status"
    2. To save the file in the path shown below.
    Please note that as this is a process which is repeated through the day.
    I need code to also check if folder created in 1. above is created, if created then save the next process as in the same date folder and file path. The date refers to system time FYI.
    Will someone help shed some light on this....as I am having problem sorting this out......
    Just forgot to mention....this......is there a way to modify this code to save the file with the dates found in Column Q (which is a range of 3 or 6 different dates).
    with formats as below.... 7/24/2017.....
    So far, no one has a solution is it????

    Please Login or Register  to view this content.

  6. #6
    Forum Contributor
    Join Date
    05-23-2017
    Location
    Bang, India
    MS-Off Ver
    MS Office 2007
    Posts
    221

    Re: Create Folder & Check if Folder Exists if Not Create Folder & then Save File

    unsolved still ?????

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Creating a VBA Script to save in a current month's folder (create folder as needed)
    By spittingfire in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-15-2015, 03:08 PM
  2. VBA to check if folder directory exists, and if not create it
    By Rerock in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-06-2015, 12:32 PM
  3. [SOLVED] Check if folder exists, Create if Not
    By szpt9m in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-05-2014, 04:03 AM
  4. Save a file to a folder, create folder if it doesn't exist
    By mcinnes01 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-01-2010, 09:12 AM
  5. Create Folder with system date then save file to folder
    By cartotech81 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-06-2009, 02:12 PM
  6. Check if folder exists, if not create it
    By mattmac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2009, 10:17 AM
  7. Replies: 6
    Last Post: 08-11-2006, 03:41 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1