OK, so I have an extremely fickle and technologically helpless boss who is too lazy and doesn't ever remember how to maximize a workbook within a maximized Excel and then put filters on it. We have a report the is scheduled via our online system to generate every day, but the result is a brand new file each time, thus I can't put a macro in the file itself. What I want to know is if it is possible to put a macro in my Personal Macro Workbook that will run if a newly opened file is "Concrete name of the file.xls". Fortunately, as indicated, the file name is static and doesn't change with the date, so I won't have to deal with an ever changing file name. I understand that there's a fairly easy way to program a macro to run upon opening a file, as long as the macro is within that file, although I've never done such a thing. What I'd like to do is essentially the same thing, but have the macro stored in the personal file.
Bookmarks