personal2.xls appears and now all my triggers point to it

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Finny - 15 Feb 2007 14:58 GMT

For some reason I have a personal.xls and personal2.xls in my xlstart
folder.
It is an exact duplicate - from what I can tell (it is not exactly
same kb's but I have edited personal2.xls before noticing this issue).
I don't remember creating personal2.xls and further I don't how I
could have created it - tohave all my current buttons and shortcuts
now point to it.

I can go through, one by one, and reassign the triggers to my orig
personal.xls, but if this was done couldn't it be undone?

Is that a name excel would generate in some kind of situation?
Is this a familiar situation to anyone?
Is there a way to trick my triggers into pointing back to my main
personal.xls?

Thanks

Reply to this Message

Finny - 15 Feb 2007 17:15 GMT

> For some reason I have a personal.xls and personal2.xls in my xlstart
> folder.
[quoted text clipped - 13 lines]
>
> Thanks

Reply to this Message

Finny - 15 Feb 2007 19:32 GMT

anyone?

Reply to this Message

Dave Peterson - 15 Feb 2007 20:36 GMT

After you've verified that the workbooks are identical (or as identical as you
care about), why not just delete one of them and if you have to, you can rename
personal2.xls to personal.xls.

> For some reason I have a personal.xls and personal2.xls in my xlstart
> folder.
[quoted text clipped - 13 lines]
>
> Thanks

Signature

Dave Peterson

Reply to this Message

Finny - 16 Feb 2007 19:21 GMT

the main trouble is all my buttons/menus are now pointing to the
personal2.xls.
I could erase personal.xls and live with this other one, I would just
like to understand why this happened or how it can be fixed.

I know if you do a Save As for a workbook that has formulas pointing
to it, all the formulas (in currently open workbooks) will change to
point to the newly named workbook (which should be an option at time
of Save As).

I feel something very similar has happened, but I can't figure out how
to do a Save As with these hidden workbooks to the do the renaming
switcharoo.

Reply to this Message

Finny - 16 Feb 2007 19:39 GMT

I fixed it!
With Excel closed, I renamed Personal2.xls to Personal2.xls.bak.
I thought Excel would now only pick up personal.xls and have a lot of
orphaned shortcuts to personal2.xls.
When I got back into the vba editor, it was still there - with the bak
extension! What Excel is using to identify this as a workbook i do not
know.
So from there it was easy. Close excel, move my good Personal.xls to
another folder, rename Personal2.xls.bak to Personal.xls and open
Excel again. All my shortcuts are back to my original personal.xls
again! phew!
Then close excel, copy my good personal.xls over the bad and bada
bing.
back to normal.
just in time for the weekend!
Thanks for the input Dave,
Finny

Reply to this Message