Using macros wih different spreadsheets

[phillyd023]

I have created a template with a macro with keystrokes. I want to use this so at any time I can run a report, then copy/paste that information into my template and run a macro.

What I do is paste information from the spreadsheet into my template and what the macro does is filter by column O then by column P to show a result of zero in the P column.

While recording keystrokes, I highlight the first row at the top (leaving the headers) (which in my case the first visible filtered row is 40) and press CTRL+SHIFT+FN+END to highlight everything on the spreadsheet that is visible. Then I right-click and DELETE to get rid of the filtered info.

I then unfilter P then O to bring up the rest of the information on the spreadsheet.


When I run the same template and macro but with different spreadsheet information (headers in both sheets are the same) I seem to get different results. I am wondering if the macro I created is remembering specific things from the original spreadsheet I used to create the macro. For example, above I mentioned I clicked on the first row which was row 40 ….. each time I use the macro for different sheets is the macro going to remember that I clicked on line 40 or that I clicked on the second row from the top?

[alansidman]

Look at this link

https://www.rondebruin.nl/win/personal.htm

[dflak]

The above reference will make the macro available for every workbook you open after updating Personal.XLSB.

Here are a couple of other options in case you want to limit where you can use this macro:

The first option is to save the template as an actual Excel Template (XLTM file). Then when you select File -> New, this will be one of the options. This is a good option for a "completed" project. I have one to manage my time sheets.

Another option is to save the module as a BAS file and import it into workbooks where you need it. I have modules to mail stuff, set filters, clear tables, run queries, get the ASCII equivalent of strings, and so on. When I create a program, I pull in these modules as I need them. This wiki http://www.utteraccess.com/wiki/Add_...ction_To_Excel explains how to export and import BAS files. This is a good option for embedding bits and pieces of code.