macro running excel

[GinnyP]

Hi,
I am using a macro and am trying to open a spreadsheet using run app. It keeps telling me I have the wrong path. do I need to specify application before path name?

C:\Documents and Settings\VPETRO NI\test.xls

Thanks for your support

[PEB]

Hi Virginia,

When you use Run app macro you need to do it!

If you change to follow hyperlink macro the way is enough to open your file!

Best regards!

Vladimir

:)

[GinnyP]

Hi Virginia,

When you use Run app macro you need to do it!

If you change to follow hyperlink macro the way is enough to open your file!

Best regards!

Vladimir

:)

what do i need to add in to the about path name?

Thanks
Virginia

[PEB]

hm hm So....

U need a little help...

Create a module...
in this module paste:

Function run_file(path)
Application.FollowHyperlink path, , True
End Function

In your macro choose:
RunCode
And above write
run_file("I:\pe rpericon.doc")

Change "I:\perpericon. doc" with your file to open :)

Best regards

Vladimir