LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 145
Default My unsolved mystery!

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 spreadsheet 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

PS: I posted this same question in the Word Programming Section, however, it
does not look as if there are many responses to a lot of the questions, and
I've always found this discussion group to be quicker to
answer.................
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to fix mystery sheet JLGWhiz[_2_] Excel Programming 2 March 29th 09 12:50 AM
Mystery Value in my Spreadsheet! nacholibre Excel Discussion (Misc queries) 2 November 17th 06 06:10 PM
MYSTERY!! WhytheQ Excel Discussion (Misc queries) 2 June 20th 06 11:00 AM
modify without unprotecting the sheet, Unsolved question filo666 Excel Programming 1 November 23rd 05 05:06 PM
HELP!! Unsolved Mystery ahegstrom Excel Discussion (Misc queries) 2 June 8th 05 07:26 PM


All times are GMT +1. The time now is 12:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"