Solved: rd_filename = Active.Workbook.Name

[velohead]

Hi All,

It's been a while since this beginner used VB, so go gently please.

The statement....
rd_filename = Active.Workbook.Name
....is not recognised by VB, it comes up with "run time error 424".

I assume (from looking at help) that the reason is that I need a fuller line of code, like Application.Active.Workbook.Name

Anyone know what this is, please.


Just for info, I want to....
do something in active file
capture filename from active file
goto a specific file and do something
then goto 1st file (hence need filename) and do something else


Thanks All.

[velohead]

Solved. D'oh!

[Bob Phillips]

I presume you used

rd_filename = ActiveWorkbook.Name

Please confirm fr the archive.

[velohead]

Yes, that is correct.
I had inserted an unneccessary . character.