A few years ago I wrote templates for Microsoft Word and Excel containing vba
code. The macros are used to search through designated word files, suck out
particular bits of information, export that info to excel, and create
cross-reference tables in Excel with that info. We use these templates a lot
in my group.
A few weeks ago I got a new laptop with Windows XP (instead of 2000) and
Office 2003 (instead of 2000). I just tried using these macros for the first
time since the upgrade, and I'm running into a lot of problems:
1) The Word macro that exports data to Excel runs EXTREMELY slowly -- it
takes 5 minutes where it used to take 30 seconds. And that's if I save the
file locally; over the network, I give up before I see anything happening.
2) Workbooks made from the Excel template have code to create a menu with
buttons to run the macros. These menus never appear.
3) If I run the macros in Excel, I get an error at the following line,
probably because the menu isn't the
If CommandBars(sortReqToolBarName).Visible = True Then

Any advice is appreciated. I'm not even sure if this is the correct
forum, so advice on where to go for help is also appreciated. I will also
post in the Word programming forum.

Thanks very much,
Susan