Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Vba Change File Name

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    Re: Vba Change File Name

    Can you show the code that creates the file?

    Comment


    • #3
      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

      Comment


      • #4
        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.

        Comment

        Trending

        Collapse

        There are no results that meet this criteria.

        Working...
        X