ok, so i have created an autoshape on a spreadsheet, I have created a macro
for it and need it to link to a file in another directory. the reason i am
not just creating a "right click-->create hyperlink" is because it is getting
screwed up when i run the main program. I want to know how to write it in VB
so it automatically creates the hyperlink thru the macro.

Sub Rectangle5_Click( )
make hyperlink to c:\myfile.doc
End Sub

thanks

You want to create a hyperlink or do you want to perform the action a
hyperlink would perform?

--
Regards,
Tom Ogilvy


"Jim" wrote:

> ok, so i have created an autoshape on a spreadsheet, I have created a macro
> for it and need it to link to a file in another directory. the reason i am
> not just creating a "right click-->create hyperlink" is because it is getting
> screwed up when i run the main program. I want to know how to write it in VB
> so it automatically creates the hyperlink thru the macro.
>
> Sub Rectangle5_Click( )
> make hyperlink to c:\myfile.doc
> End Sub
>
> thanks

I want the file to open when I click on the shape and I want to do it thru a
macro. so I guess to answer your question, perform the action that a
hyperlink would.

"Tom Ogilvy" wrote:

> You want to create a hyperlink or do you want to perform the action a
> hyperlink would perform?
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Jim" wrote:
>
> > ok, so i have created an autoshape on a spreadsheet, I have created a macro
> > for it and need it to link to a file in another directory. the reason i am
> > not just creating a "right click-->create hyperlink" is because it is getting
> > screwed up when i run the main program. I want to know how to write it in VB
> > so it automatically creates the hyperlink thru the macro.
> >
> > Sub Rectangle5_Click( )
> > make hyperlink to c:\myfile.doc
> > End Sub
> >
> > thanks

Executing this statement should open up your file using the associated
program for its extension (in the case of your original posting, Word should
open up and your myfile.doc document should be loaded automatically)...

Shell Environ("COMSPEC") & " /c ""c:\myfile.doc""", vbHide

Make sure you preserve the spacing and quote marks as shown when
substituting your actual file name in for the sample myfile.doc one.

Rick


"Jim" <(E-Mail Removed)> wrote in message
news7BDFAE6-B465-46CF-9B27-(E-Mail Removed)...
>I want the file to open when I click on the shape and I want to do it thru
>a
> macro. so I guess to answer your question, perform the action that a
> hyperlink would.
>
> "Tom Ogilvy" wrote:
>
>> You want to create a hyperlink or do you want to perform the action a
>> hyperlink would perform?
>>
>> --
>> Regards,
>> Tom Ogilvy
>>
>>
>> "Jim" wrote:
>>
>> > ok, so i have created an autoshape on a spreadsheet, I have created a
>> > macro
>> > for it and need it to link to a file in another directory. the reason i
>> > am
>> > not just creating a "right click-->create hyperlink" is because it is
>> > getting
>> > screwed up when i run the main program. I want to know how to write it
>> > in VB
>> > so it automatically creates the hyperlink thru the macro.
>> >
>> > Sub Rectangle5_Click( )
>> > make hyperlink to c:\myfile.doc
>> > End Sub
>> >
>> > thanks