use current file and folder name

[mohavv]

Is it possible to use the value of the file and folder name in a
macro?

For example, when you rename/copy a file you want the following code
to change:

Windows("2007 Accounts.xls").Activate

If you copy the file containing the macro it will want to activate the
old file and it should activate the new file.

Cheers,

Harold

 

[Dave Peterson]

If your code is in a general module, you can use ThisWorkbook, like:

Thisworkbook.windows(1).activate

Or

Thisworkbook.worksheets("somesheetnamehere").range("a1").clearcontents

If your code is behind the ThisWorkbook module, you can use the Me keyword.

me.windows(1).activate
me.worksheets("somesheetnamehere").range("a1").clearcontents
(me refers to the object that owns the code.)

===
(Actually, you can use ThisWorkbook in any module to refer to the workbook that
owns the code.)