Possible to change filename using VBA?

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

For example, like this:

If filename = standard.xls then do nothing
else if filename != standard.xls then
set filename = standard.xls
end

Any help will be greatly appreciated.

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.

Windows("Standard.xls").Activate

Is it possible to do this..

'start of macro
define NameVariable as current workbook name
'rest of macro code
Windows(NameVariable).Activate

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

Originally Posted by JosephP

use a workbook variable

dim wb as workbook
set wb = activeworkbook
' code here
wb.activate

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!