rename the filename thru vb

[vivekgrs]

hi everybody,

iam using the following code for open the file.

sfil = d:\abc.txt

nSourceFile = FreeFile
Open sfil For Input As #nSourceFile

now i want 2 change the extension of the opened file to .bak. ie the original file wants 2 rename.



can any one help me regarding this isssue

regards

vivek

[willakawill]

hi everybody,

iam using the following code for open the file.

sfil = d:\abc.txt

nSourceFile = FreeFile
Open sfil For Input As #nSourceFile

now i want 2 change the extension of the opened file to .bak. ie the original file wants 2 rename.



can any one help me regarding this isssue

regards

vivek

If you take a look at the file object which is part of the filesystemobjec t collection you will see that you can change the filename

[bobthenob]

Name old name and path As new name and path
hope this helps

[Chish]

That doesn't work with files that need to be overwritten.
An error saying that the file already exists pops up.

[Killer42]

That doesn't work with files that need to be overwritten.
An error saying that the file already exists pops up.

Perhaps so, but that wasn't part of the original question.

Also, it's worth noting that while statements such as Name As are quick and simple to code, the FileSystem Object gives you much more power and control over the file system.

[balid]

Perhaps so, but that wasn't part of the original question.

Also, it's worth noting that while statements such as Name As are quick and simple to code, the FileSystem Object gives you much more power and control over the file system.

Plus you can override the warning message this way as well.