How to avoid excel warning message

S

Sivanand

Hi,
When calling excel file from Ms-Access it display security warning. How to
programmatically supress this warning?
 
O

Opal

Hi,
When calling excel file from Ms-Access it display security warning. How to
programmatically supress this warning?
Click to expand...

If you are using a command button with a hyperlink to access your
excel file,
instead why not try the FollowHyperlink method by using the command
button's on click event:

Private Sub cmdHyperlink_Click()
Application.FollowHyperlink "Hyperlink Address", , True
End Sub

This will get rid of the warning message.
 
S

Sivanand

Thanks Opal.

I tried the way like this,

Private Sub Test_Click()
Application.FollowHyperlink "C:\Program Files\redpepr\Macro1.xls", , True
End Sub

But it gives security warning.
Regards
Sivanand
FITSI, Chennai
 
O

Opal

Thanks Opal.

I tried the way like this,

Private Sub Test_Click()
Application.FollowHyperlink "C:\Program Files\redpepr\Macro1.xls", , True
End Sub

But it gives security warning.
Regards
Sivanand
FITSI, Chennai








- Show quoted text -
Click to expand...

I'm sorry it didn't help. When I use it I do not get any warning
messages. Perhaps you need
to adjust your security levels?
 
B

biganthony via AccessMonster.com

If it is the hyperlink security warning message, this page shows how to
disable it:

http://support.microsoft.com/kb/829072


Anthony

Thanks Opal.

I tried the way like this,

Private Sub Test_Click()
Application.FollowHyperlink "C:\Program Files\redpepr\Macro1.xls", , True
End Sub

But it gives security warning.
Regards
Sivanand
FITSI, Chennai
On Oct 25, 2:35 am, Sivanand <[email protected]>
wrote:
Click to expand...
[quoted text clipped - 12 lines]
This will get rid of the warning message.
Click to expand...
Click to expand...
 
Top