Possible to change filename using VBA?

[UsmanBPD]

Hello, is it possible to set a filename using VBA with no user prompt during a Macro?

For example, like this:

Please Login or Register  to view this content.

Any help will be greatly appreciated.

[JosephP]

for an open workbook you would have to save the workbook as the new name. for a closed file you can use the Name command.

[martindwilson]

you can rename an open workbook ,i don't know how but asap utilities includes a "rename current file" option which changes the name of the workbook you are currently using so it must be possible!
ah i see you have to have saved the file first then it can be renamed while open.i supose it needs to know the dir path

[JosephP]

it probably does a saveas and deletes the old file.

[UsmanBPD]

That's a bit more than I'm willing to do, is this possible instead?

In my macro, I have this, which means the file needs to be called Standard.xls or it'll throw an error.

Please Login or Register  to view this content.

Is it possible to do this..

Please Login or Register  to view this content.

Does this make sense? Sorry for silly syntax, I'm still learning.

[JosephP]

use a workbook variable

Please Login or Register  to view this content.

if the workbook is the one containing the code, you can just refer to ThisWorkbook instead.

[UsmanBPD]

use a workbook variable

Please Login or Register  to view this content.

if the workbook is the one containing the code, you can just refer to ThisWorkbook instead.

Thank you very much JosephP, and thank you everybody that responded. Consider this solved!