View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default Multiple persional.xls files making macros NOT work!

Depending on your upgrade path, you could have multiple XLStart folders. I'd
look through them once more.

Maybe even an old DOS command would help:

dir c:\personal.xls /s /a

And if that didn't help:
http://www.contextures.com/xlfaqApp.html#AlreadyOpen
(From Debra Dalgleish's site)

"aiyer <" wrote:

Hello all!

A quick qn.
I have Excel 2003 in my PC and I built menu bars in a certain workbook
with toolbars attached to the menu bars. The toolbars are in turn
assigned to specific macros. (some of these macros were recorded in
personal.xls).

I copied the workbook (along with the personal.xls, which stores some
macros as mentioned above and the *.xlb file from my PC) to another PC.

But now when I try to execute the macros in the new PC, I am getting a
message 'multiple personal.xls files are open'.
Deleted the redundant personal.xls files in the new PC and there is
only one personal.xls file (copied from my PC) in the new PC and it is
still giving me the error.

Here is where I copied the personal.xls and the Excel11.xlb file to in
the new PC

C:\Documents and Settings\aiyer\Application Data\Microsoft\Excel

Am I missing anything here? Would appreciate your help guys.
Thanks a bunch.

Regds,

Arun.

Vtec corp.

---
Message posted from http://www.ExcelForum.com/


--

Dave Peterson