Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Vba Change File Name

  1. #1
    Join Date
    19th October 2007
    Posts
    9

    Vba Change File Name

    I have a file that gets created. Onces it's created I need the file name to changed in vba.
    Any suggestions would be appreciated.
    Thx

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    11th August 2006
    Location
    Outside St. Louis, MO
    Posts
    621

    Re: Vba Change File Name

    Can you show the code that creates the file?

  3. #3
    Join Date
    19th October 2007
    Posts
    9

    Re: Vba Change File Name

    I found a way. I'm using the Name code ine vba:

    FileName = "c:\temp\Ottawa_Rep.csv"
    NewFileName = "c:\temp\Ottawa_RepExportCVIDP" & skill & ".csv"
    Name FileName As NewFileName

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    11th August 2006
    Location
    Outside St. Louis, MO
    Posts
    621

    Re: Vba Change File Name

    Please ensure code tags are placed around any code.

    I don't understand the code but if it works, great! Thanks for posting your solution.

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Change File Extension
    By Excelpower in forum Excel and/or Word Help
    Replies: 6
    Last Post: May 22nd, 2013, 16:05
  2. Change Txt File Extension To Csv
    By hgus393 in forum EXCEL HELP
    Replies: 5
    Last Post: October 18th, 2007, 15:49
  3. inputbox to change file name
    By amer in forum EXCEL HELP
    Replies: 1
    Last Post: October 19th, 2005, 20:40
  4. Using VB to change the location of a file
    By stevehorton09 in forum EXCEL HELP
    Replies: 2
    Last Post: July 27th, 2004, 06:41
  5. i need to change the file name in a formula
    By Banni in forum EXCEL HELP
    Replies: 3
    Last Post: June 23rd, 2004, 00:55

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
  •  
porno