Replies

Thanks Hans. Perfect and elegant as usual.

I did find that the following formula works for the e-mail example:
=HYPERLINK(“mailto:”&O8,O8)

However, you end up stuck with two columns of data; the e-mail addresses and the hyperlinks. I couldn’t figure out a way to eliminate the formulas and just have the hyperlinked text.

Thanks again.

I thought my browser was webbrowser0, but it is webbrowser1.
Must have been the various tries.

Now it works!

Hans – Thanks so much for you help!

I thought my browser was webbrowser0, but it is webbrowser1.
Must have been the various tries.

Now it works!

Hans – Thanks so much for you help!

Access was crashing when I tried to add the browser object (also crashes when trying to import from Excel). I may need to reinstall.

So I used another machine and was able to add the “Microsoft Browser” object.
However, I get an error message when I open the form:
—————————
Microsoft Visual Basic
—————————
Compile error:
Method or data member not found

It highlights WebBrowser0
My line of code in the On Current event is as follows:

Me.WebBrowser0.Object.navigate [Picture Link]

Hopefully, I’m just doing something simple wrong.

Access was crashing when I tried to add the browser object (also crashes when trying to import from Excel). I may need to reinstall.

So I used another machine and was able to add the “Microsoft Browser” object.
However, I get an error message when I open the form:
—————————
Microsoft Visual Basic
—————————
Compile error:
Method or data member not found

It highlights WebBrowser0
My line of code in the On Current event is as follows:

Me.WebBrowser0.Object.navigate [Picture Link]

Hopefully, I’m just doing something simple wrong.

Thanks Hans.
Yes I came across that thread while looking for my answer, but I haven’t gotten it to work yet.
I am still working on it. I thought there might be an alternative solution.

Any ideas for the automated saving of the contents of a hyper link a la “save target as”?

(Edited by HansV to make URL clickable – see Help 19)

This thread may offer you hope:

post 314385

(Edited by HansV to make URL clickable – see Help 19)

This thread may offer you hope:

post 314385

Timbo,
Thanks for the help.
Joe

Tim,

Can you list your macro?
I tried to write one quick and it didn’t work.
You could save me some time.

Thanks,
Joe

Thanks to Legare and Andrew for your help.
Egg ‘n’ Bacon – I do not see conditional formatting under the tools menu. Is this an Excel 97 feature? Do I need to install an add-in? Are you referring to the conditional sum add-in?