how to make macro file/workbook independant?

**Chris95120** · 08-12-2008, 02:10 AM

Hi All, I'm sure this is a simple one for your veterans....I'm just getting started with Excel macros. Below is a macro definition. I created this macro (Sort1) while inside a file named "FileA".

I'm trying to make it so that this macro can be used inside any Excel file that I happen to be in. I have created/stored the excel macro in my Personal folder that is viewable to all other Excel files. The problem I'm having is that the macro below gets created with a hard-coded file name ("FileA"). How do I modify this macro so that it works on the "current file" (any Excel file that I happen to be in).

Your help is greatly appreciated!
Thanks,
Chris

Please Login or Register  to view this content.

**shg** · 08-12-2008, 02:16 AM

Please read the Forum Rules about thread titles, and then edit yours to be descriptive of your problem, and then edit your post to wrap your code with Code Tags.

**Chris95120** · 08-12-2008, 02:24 AM

...thanks for your patience!

-Chris

**shg** · 08-12-2008, 02:38 AM

Thanks.

Try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

**Chris95120** · 08-12-2008, 03:19 AM

That did the trick!

Good karma headed your way....

-Chris

how to make macro file/workbook independant?

LinkBack

Thread Tools

Rate This Thread

Display

how to make macro file/workbook independant?

Will do....sorry, learning the ropes here

Thanks!!!

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions