Forum Discussion

kobus1305's avatar
kobus1305
Brass Contributor
Nov 02, 2020

Opening a other type of document

I am trying to open a pdf, Acrobat Reader document, from within excel spreadsheet using hyperlink. I do have the Acrobat Reader Suite on the computer. Is it at all possible and can someone help??????...
excel
NikolinoDE's avatar
NikolinoDE
Gold Contributor
Nov 02, 2020
Should actually work.
Testing is above studying 🙂

Nikolino
I know I don't know anything (Socrates)
kobus1305's avatar
kobus1305
Brass Contributor
Nov 05, 2020

NikolinoDE 

Hi, Thank You i will try it!!! Just one question what does the $ in vba refers to??? My vba does not like it at all, gives a syntax error color red.

All this is red

              If Right $ (LCase $ (grgRbereich.Value), 4) = ".pdf" Then
                    ChDrive $ Left (grgRbereich.Value, 3)
                    ChDir $ Left (grgRange.Value, InStrRev (grgRange.Value, "\", -1))
                    ShellExecute 0, "open", Dir $ (grgArea.Value), "", CurDir $ & "\", 1

All this is red 

              Set large area = ActiveCell

Thank You

Regards

Kobus

Resources