I am generating a 17-column status page that contains (what I will call here) Case Numbers. Under any of the 17 columns (Case
Status) will be some quantity of Case Numbers. Think of it as an upside-down bar chart of cases going through a workflow.
Example screen shot below.
The basic URLs, which work fine as is, are being
generated using something parallel to the following code (simplified example below uses city and zip code):
cityString = "Huntington Beach"
zipString = "92647"
urlString = "[URL]http://maps.google.com/maps?q[/URL]=" & zipString
Anchor:=Cells(someRow, someCol), _
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
OBJECTIVE: To simplify the acutal usage of this status page, I would like the URLs to open in a new window (or frame),
which is usually done in HTML by using TARGET = "_blank" in the code. This allows the users to open several cases (which can
load slowly) in new windows, and not leave the status page file.
I was not able to find a way to add this 'switch'
to the Address field for the hyperlink, since, in html code, the TARGET = "_blank" switch comes outside of the URL string.
Is there a way to set this switch for one or all URLs created in an Excel sheet, so that, when saved as html (Save As
/ Web Page) the links will open in a new window? Many thanks for any suggestions!