Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA reference error
I have an application which works fine in my home environment. When I
run it at work though I get the following error message; Run-time error '1004': 'Programmatic access to Visual Basic Project not trusted' after the follwing routine; With Application.VBE.ActiveVBProject.References On Error Resume Next .AddFromFile Filename:="msoutl9.olb" If Err Then .AddFromFile Filename:="msoutl.olb" On Error GoTo 0 End With It stops on the first row. Protection of the project is not activated (password written but not in 'use'. When I remove the password the error message changes to the following; '<Method 'VBE' of object '_application' failed' Again it stops on the first row. At home I use Excel 2000 9.0 in a W2000-environment and at work Excel 10.0. What I want to handle is to open the reference in Excel to Outlook in case it is not already open. Another 'error' I encounter at work is that when I open the file I get the following message; 'Excel encountered an error and had to remove some formatting to avoid corrupting the workbook. Please re-check your formatting carefully.' Is there any way to find out where to find the incorrect formatting? Is there perhaps a connection between the two errors above and formatting error? If necessary I can forward the entire file. I might need to 'clean it up' a litle since it is partly in Swedish. Any help is much appreciated. Best regards, Thor *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA reference error
Hi Thor
See this information from John Walkenbach http://www.j-walk.com/ss/excel/tips/tip96.htm About the Outlook reference: You can use Binding for that http://www.dicks-clicks.com/excel/olBinding.htm -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "Thor" wrote in message ... I have an application which works fine in my home environment. When I run it at work though I get the following error message; Run-time error '1004': 'Programmatic access to Visual Basic Project not trusted' after the follwing routine; With Application.VBE.ActiveVBProject.References On Error Resume Next .AddFromFile Filename:="msoutl9.olb" If Err Then .AddFromFile Filename:="msoutl.olb" On Error GoTo 0 End With It stops on the first row. Protection of the project is not activated (password written but not in 'use'. When I remove the password the error message changes to the following; '<Method 'VBE' of object '_application' failed' Again it stops on the first row. At home I use Excel 2000 9.0 in a W2000-environment and at work Excel 10.0. What I want to handle is to open the reference in Excel to Outlook in case it is not already open. Another 'error' I encounter at work is that when I open the file I get the following message; 'Excel encountered an error and had to remove some formatting to avoid corrupting the workbook. Please re-check your formatting carefully.' Is there any way to find out where to find the incorrect formatting? Is there perhaps a connection between the two errors above and formatting error? If necessary I can forward the entire file. I might need to 'clean it up' a litle since it is partly in Swedish. Any help is much appreciated. Best regards, Thor *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
#N/A Error Reference | Excel Worksheet Functions | |||
External xls reference error | Excel Worksheet Functions | |||
Circular Reference Error | Excel Worksheet Functions | |||
reference #value error | Excel Worksheet Functions | |||
Maddening reference error | New Users to Excel |