Mystery I can't solve!

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



I have a Userform that was made up for me by a friend which I use to post
comments in. The form interacts with Excel, and when Excel is open, it calls
up a "Userform" in Word. I'm Using Office XP: Home Edition (Word and Excel
2002) btw.

I was attempting to transfer my spread*** with Userform to a friends
computer (she has Vista and Office 2007). When I looked at the VBA coding on
the particular word file, I noticed that the "Forms" file was not there
(under Project), and the Userform we created was nowhere to be found.

I understand the difference between "Project" (which is specific to a
document) and "Normal" (which places the code or in this case Userform
globally throught), and realize that I have to move the Userform we created
from "Project" to "Normal", however the Userform didn't exist when the Word
file was moved from my XP/Office 2003 computer to the Vista/Office 2007 based
computer. I was able to create a "blank" "forms" folder (which the Userform
currently exists in on my computer), but my "created" Userform template does
not seem to want to transfer with the Word file.

I also had attached code (for some of the Userforms functionality) in a
Module that I created, and this too would not transfer between the computer.s

Funny, I moved the same documents to a computer with XP and Office 2003, and
everything (including the Userform template, and module coding) was there,
and all worked well. I had no difficulties. Something about Vista and Office
2007 seem to be working against me.

Any suggestions?

Dan
.


Quantcast