Excel VBA rename file

[BryanRobson]

Hi. the below piece of code is in a spreadsheet i have which basically prompts for an xlsx file and then does a multitude of things with it. sometimes the file is .OLD extension. is there a way I can select the .OLD file and then the code renames it to .XLSX?

Thanks

Please Login or Register  to view this content.

[ByteMarks]

Try:

Please Login or Register  to view this content.

[6StringJazzer]

What is the data type for fd? FileChosen?

[BryanRobson]

Try:

Thanks very much for your reply. Much appreciated

[BryanRobson]

Hi ByteMarks.

Thanks for the code. it works well. How do I change the file back to .old when finished without being prompted to select the file again.

i.e so select .OLD file
file is renamed to .xlsx
further code is processed
originally file selected is renamed back to .old without prompting to select the file (which is now of course .xlsx)

Thanks very much

[mjr veverka]

There is no need to change the extension '.old' to '.xlsx' and vice versa.
Regardless of the extension, a file created in Excel has "excel's format".
The file extension is just information for the system about which program to associate the file with.
Such an Excel file (with the '.old' extension) will be opened in Excel via the "File\Open" option anyway.

For example:

1. Standard module:

Please Login or Register  to view this content.

2. UserForm module:

Please Login or Register  to view this content.

[BryanRobson]

There is no need to change the extension '.old' to '.xlsx' and vice versa.
Regardless of the extension, a file created in Excel has "excel's format".
The file extension is just information for the system about which program to associate the file with.
Such an Excel file (with the '.old' extension) will be opened in Excel via the "File\Open" option anyway.

For example:

1. Standard module:

Please Login or Register  to view this content.

2. UserForm module:

Please Login or Register  to view this content.

Hi. You are right. I never knew you could import a file with extension .old and it still recognises it as excel format. Thanks very much