Rename and move file to an existing folder

P

PISCES

Registered User.

Local time

Today, 14:29

Joined

Mar 11, 2004

Messages

12

• Jun 2, 2004

• #1

Hi Group,
I have the following code:

newname= "H:\nob\" & left$(strFile,len(strFile)-4) & ".txt"

but what is returned for newname is the literal string.
I want the file to go to the H:\Nob folder which exists.

left$(strFile,len(strFile)-4) resolves to this 6310104.

So what I want is 6310104.txt in the H:\nob\ folder.

Kind Regards

 

ghudson

Registered User.

Local time

Today, 17:29

Joined

Jun 8, 2002

Messages

6,194

• Jun 2, 2004

• #2

Check out the Name Statement in the Access help files for more info and examples.

Code:

OldName = "C:\MYDIR\OLDFILE": NewName = "C:\YOURDIR\NEWFILE"
Name OldName As NewName	' Move and rename file.

 

Kodo

"The Shoe"

Local time

Today, 17:29

Joined

Jan 20, 2004

Messages

707

• Jun 2, 2004

• #3

That's handy! Thanks

 

M

mr_e_landis

Registered User.

Local time

Today, 14:29

Joined

Feb 16, 2005

Messages

28

• Dec 18, 2006

• #4

SCORE!!!
THIS IS AWESOME!!!

Code:

OldName = "C:\MYDIR\OLDFILE": NewName = "C:\YOURDIR\NEWFILE"
Name OldName As NewName	' Move and rename file.

Works great and takes care of both of the issues I faced with renaming and moving the file!!! SWEET!
Thanks!

 

Last edited: Dec 18, 2006