Workbooks.Application.ActiveWorkbook vs ActiveWorkbook

[bvwalker1]

Is there any difference between those two statements? Also, if you don't use "Active" keyword on Excel functions in general, is it used by default?
Thanks!

[TMS]

Not as far as I can see

Please Login or Register  to view this content.

I've only ever used the last one but there may be occasions when you feel the need to fully qualify the workbook.

[TMS]

if you don't use "Active" keyword on Excel functions in general, is it used by default?

What does that mean? Please give examples.

[bvwalker1]

TMS - Thank you. You can disregard my second question.

[TMS]

You're welcome. Thanks for the rep.