C
CT
I am having problems with opening a new html window when
the xls file is viewed via a browser. The link seems to
want to open within the same browser window. I want the
link to open a new browser window when clicked. The
following snipet of code works as expected when the
xls file is opened via Excel on the local machine, but
doesn't when viewed via the web. This is the code I have
in Workbook_Open():
Range("E" & iDetRowNdx & ":E" & iLastRowNdx).Select
With ActiveSheet.UsedRange
For RowNdx = iDetRowNdx To .Rows.Count Step 1
If InStrRev(Range("C" & RowNdx).Value, "Total") Or
Range("C" &
RowNdx).Value = "" Then
'Do Nothing
Else
ActiveSheet.Hyperlinks.Add .Range("E" & RowNdx),
Address:= _
" &
Range("G3").Value & "&BusDt=" & Range("A" & RowNdx).Value
End If
Next RowNdx
End With
I have also tried setting the address to be the current
cell value and the TextToDisplay be the actual link. I
was hoping to use the Worksheet_FollowHyperlink to
capture the target value and follow the link, but with no
avail. Any help would be appreciated.
My second question pertains to opening an SSL link, I get
the following error: Unable to open
https://www.mysite.com. A security problem has occured.
Is there a way to get around this? Using just http, the
link opens fine.
TIA
the xls file is viewed via a browser. The link seems to
want to open within the same browser window. I want the
link to open a new browser window when clicked. The
following snipet of code works as expected when the
xls file is opened via Excel on the local machine, but
doesn't when viewed via the web. This is the code I have
in Workbook_Open():
Range("E" & iDetRowNdx & ":E" & iLastRowNdx).Select
With ActiveSheet.UsedRange
For RowNdx = iDetRowNdx To .Rows.Count Step 1
If InStrRev(Range("C" & RowNdx).Value, "Total") Or
Range("C" &
RowNdx).Value = "" Then
'Do Nothing
Else
ActiveSheet.Hyperlinks.Add .Range("E" & RowNdx),
Address:= _
" &
Range("G3").Value & "&BusDt=" & Range("A" & RowNdx).Value
End If
Next RowNdx
End With
I have also tried setting the address to be the current
cell value and the TextToDisplay be the actual link. I
was hoping to use the Worksheet_FollowHyperlink to
capture the target value and follow the link, but with no
avail. Any help would be appreciated.
My second question pertains to opening an SSL link, I get
the following error: Unable to open
https://www.mysite.com. A security problem has occured.
Is there a way to get around this? Using just http, the
link opens fine.
TIA