Enable Hyperlink without opening the Excel

[supputuri]

HI Sathiya,

Please create an excel object and then use the Hyperlinks method to create the hyper link.

snippet:

Code:

Set  objEx = CreateObject("Excel.Application")

---

HI Sathiya,

Please create an excel object and then use the Hyperlinks method to create the hyper link.

snippet:

Code:

Set objEx = CreateObject("Excel.Application")
'Example: ScreenShotName = screenshotFolderPath & screenshotName(UserDefined)  & ".png"
ScreenShotName = screenshotFolderPath & Environment.Value("ActionName") &SetDateFormat(now(), "mm-dd-yyyy HH-nn-ss")  & ".png" ' here we are giving the dynamic name for screenshot with time stamp.
Set objLink = objEx.ActiveWorkbook.ActiveSheet.HyperLinks.Add (objEx.Selection,screenshotName)

Let me know if you need any further info.