Consulting

Results 1 to 3 of 3

Thread: file rename in vba

  1. 10-22-2007, 01:08 PM #1
    ltworf13
    ltworf13 is offline
    VBAX Regular
    Joined
    Jun 2007
    Posts
    10
    Location

    file rename in vba

    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
    Reply With Quote Reply With Quote
  2. 10-22-2007, 01:17 PM #2
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Do you want to rename an activeworkbook, if so then use Workbooks.SaveAs.

    If you want to rename a file on the HDD, look at Name in help.
    Last edited by Bob Phillips; 10-22-2007 at 01:56 PM.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber
    Reply With Quote Reply With Quote
  3. 10-22-2007, 01:43 PM #3
    ltworf13
    ltworf13 is offline
    VBAX Regular
    Joined
    Jun 2007
    Posts
    10
    Location
    file in HDD thx , I looked up Name and that's what I needed
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules