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!