C
CST
Hi All,
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:= _
"http://www.mysite.com/WebReports/Report.asp?ID=" &
Range("G3").Value & "&BusDt=" & Range("A" & RowNdx).Value
End If
Next RowNdx
End With
Is there an alternate way that I can do this? I dynamically build
this spreadsheet, so the values are never the same. As you can see, I
need to use the cell values to determine what I put into the links. I
think I need to do something like Hyperlink.Follow NewWindow:=True,
but that doesn't seem to work.
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
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:= _
"http://www.mysite.com/WebReports/Report.asp?ID=" &
Range("G3").Value & "&BusDt=" & Range("A" & RowNdx).Value
End If
Next RowNdx
End With
Is there an alternate way that I can do this? I dynamically build
this spreadsheet, so the values are never the same. As you can see, I
need to use the cell values to determine what I put into the links. I
think I need to do something like Hyperlink.Follow NewWindow:=True,
but that doesn't seem to work.
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