+ Reply to Thread
Results 1 to 3 of 3

Function to Save file in A Created Folder

  1. #1
    Forum Contributor
    Join Date
    06-18-2010
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    546

    Function to Save file in A Created Folder

    Please Login or Register  to view this content.
    What I am trying to do is have an array of folders to save the file in (basically not write a save line for each individual file (it's in the upper 40's), but instead
    write an array that will cycle through each folder to save in one by one. The problem with the code is that it is literally saving DFolders(n) to the beginning of the
    workbooks file name instead of saving in C:\Test\ & DFolders(n)
    Last edited by jo15765; 01-19-2012 at 01:07 PM.

  2. #2
    Forum Contributor
    Join Date
    12-28-2011
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    280

    Re: Function to Save file in A Created Folder

    Hi

    You need to ensure it isn't included as part of the filename string:

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    06-18-2010
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    546

    Re: Function to Save file in A Created Folder

    Oh good gravy!! Something so simple...Thank yoU!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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