Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Userform??
I desperately need help! I have userform and everything is working fine. I
compile after I make changes in vb and all is well. However, when testing form with another individual. Other individual will get an "automation error" and will not open file? Can someone help me why this is happening? Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Userform??
Are there any additional details on the automation error?
I've had this before and it was because there was a reference to a library not installed on their computer (in VBE Tools/references & look for "MISSING") but various things can cause it. Sam "TotallyConfused" wrote: I desperately need help! I have userform and everything is working fine. I compile after I make changes in vb and all is well. However, when testing form with another individual. Other individual will get an "automation error" and will not open file? Can someone help me why this is happening? Thank you. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Userform??
Thank you for responding. I checked Tools/References and I do not have any
"MISSING". When this form on other individual crashes, in the foreground you get message box saying something like sending report to Microsoft etc. In the background there is a small message box saying something about Automation error. Will not allow to see code or debug. In this userform, there is code opening Outlook and sending copy of workbook. "Sam Wilson" wrote: Are there any additional details on the automation error? I've had this before and it was because there was a reference to a library not installed on their computer (in VBE Tools/references & look for "MISSING") but various things can cause it. Sam "TotallyConfused" wrote: I desperately need help! I have userform and everything is working fine. I compile after I make changes in vb and all is well. However, when testing form with another individual. Other individual will get an "automation error" and will not open file? Can someone help me why this is happening? Thank you. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Userform??
Ok, I think Outlook is the source here.
On your PC, go to tools/references and make a note of all those that are ticked. One of them should be called "Microsoft Outlook 11.0 Object Library" or something similar, but make a note of them all. On the user's PC, go to tools/references and tick everything that you had ticked on yours. If you can't find the outlook one then his/her installation of Outlook may need re-installing. Sam "TotallyConfused" wrote: Thank you for responding. I checked Tools/References and I do not have any "MISSING". When this form on other individual crashes, in the foreground you get message box saying something like sending report to Microsoft etc. In the background there is a small message box saying something about Automation error. Will not allow to see code or debug. In this userform, there is code opening Outlook and sending copy of workbook. "Sam Wilson" wrote: Are there any additional details on the automation error? I've had this before and it was because there was a reference to a library not installed on their computer (in VBE Tools/references & look for "MISSING") but various things can cause it. Sam "TotallyConfused" wrote: I desperately need help! I have userform and everything is working fine. I compile after I make changes in vb and all is well. However, when testing form with another individual. Other individual will get an "automation error" and will not open file? Can someone help me why this is happening? Thank you. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Userform??
Thank you for responding. This userform will be housed on share point site
and various individuals will be accessing. Do I have to do the same to all? My guess yes or is there some way that it can be coded into my code? Thank you. "Sam Wilson" wrote: Ok, I think Outlook is the source here. On your PC, go to tools/references and make a note of all those that are ticked. One of them should be called "Microsoft Outlook 11.0 Object Library" or something similar, but make a note of them all. On the user's PC, go to tools/references and tick everything that you had ticked on yours. If you can't find the outlook one then his/her installation of Outlook may need re-installing. Sam "TotallyConfused" wrote: Thank you for responding. I checked Tools/References and I do not have any "MISSING". When this form on other individual crashes, in the foreground you get message box saying something like sending report to Microsoft etc. In the background there is a small message box saying something about Automation error. Will not allow to see code or debug. In this userform, there is code opening Outlook and sending copy of workbook. "Sam Wilson" wrote: Are there any additional details on the automation error? I've had this before and it was because there was a reference to a library not installed on their computer (in VBE Tools/references & look for "MISSING") but various things can cause it. Sam "TotallyConfused" wrote: I desperately need help! I have userform and everything is working fine. I compile after I make changes in vb and all is well. However, when testing form with another individual. Other individual will get an "automation error" and will not open file? Can someone help me why this is happening? Thank you. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Userform??
I know nothing about Sharepoint. Try it on one user's PC first to see if it's
even a solution. Other than that you could try it on the sharepoint server. Sam "TotallyConfused" wrote: Thank you for responding. This userform will be housed on share point site and various individuals will be accessing. Do I have to do the same to all? My guess yes or is there some way that it can be coded into my code? Thank you. "Sam Wilson" wrote: Ok, I think Outlook is the source here. On your PC, go to tools/references and make a note of all those that are ticked. One of them should be called "Microsoft Outlook 11.0 Object Library" or something similar, but make a note of them all. On the user's PC, go to tools/references and tick everything that you had ticked on yours. If you can't find the outlook one then his/her installation of Outlook may need re-installing. Sam "TotallyConfused" wrote: Thank you for responding. I checked Tools/References and I do not have any "MISSING". When this form on other individual crashes, in the foreground you get message box saying something like sending report to Microsoft etc. In the background there is a small message box saying something about Automation error. Will not allow to see code or debug. In this userform, there is code opening Outlook and sending copy of workbook. "Sam Wilson" wrote: Are there any additional details on the automation error? I've had this before and it was because there was a reference to a library not installed on their computer (in VBE Tools/references & look for "MISSING") but various things can cause it. Sam "TotallyConfused" wrote: I desperately need help! I have userform and everything is working fine. I compile after I make changes in vb and all is well. However, when testing form with another individual. Other individual will get an "automation error" and will not open file? Can someone help me why this is happening? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill userform textbox from userform listbox clik event | Excel Programming | |||
Is there an easy Copy/Paste of a Userform ? (Entire Userform Including tx & cbx's) | Excel Programming | |||
Looping procedure calls userform; how to exit loop (via userform button)? | Excel Programming | |||
Activating userform and filling it with data form row where userform is activate | Excel Programming | |||
Linking userform to userform in Excel 2003 | Excel Programming |