Using a macro that includes 2 worksheets
Your missing macros were probably stored in your Personal.xls file which your
upgrade neglected to bring over.
As far as your currently recorded macro not working, it could be some hard-coded
reference to the workbook it was recorded into.
Post the code so's we can make adjustments if needed.
Gord Dibben MS Excel MVP
On Thu, 23 Aug 2007 15:14:03 -0700, Richard Champlin
wrote:
Last night, my computer was upgraded to Windows XP. I found that macros I
had recorded were no longer visible. The one I used most often was rather
simple, so I just re-recorded it...it involves copying some data from a CSV
file into an Excel spreadsheet. Before the upgrade, it worked perfectly.
Now, it seems to stop functioning when I toggle between the affected files.
Any ideas?
--
Richard Champlin
Administrative Program Assistant II
Children''''s Hospital
|