+ Reply to Thread
Results 1 to 1 of 1

Save file in sequential order within directory

  1. #1
    Registered User
    Join Date
    09-20-2012
    Location
    Windsor, Ont
    MS-Off Ver
    Excel 2010
    Posts
    1

    Save file in sequential order within directory

    Hello, I am new to vba coding and also to the forum. I am having trouble coding an excel file to automatically change the file name based off of what is already saved in the directory. For example: first file would save as 1.xlsm and the second 2.xlsm……etc. I have the following code and cannot figure out why it will not work:

    Please Login or Register  to view this content.
    Anyone have any ideas? Thanks, Tom


    Moderator Edit:

    Welcome to the forum, Tom Brennan.

    Please notice that code tags have been added to your post. The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
    Thanks.
    Last edited by Cutter; 09-20-2012 at 11:27 AM. Reason: Added code tags

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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