View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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