use current file and folder name

  • Thread starter Thread starter mohavv
  • Start date Start date
M

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
 
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.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

use current cell address as beginning of macro 2
use current year in macro 1
How can I use the active cell address as a value 2
check if file is already open 1
date format problem using Macro 1
linked files to be changed 1
problem saving xlsx file 1
save multiple files with different names in other drive using macr 6

Back
Top