Click here to Skip to main content
15,900,108 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: ubstitute of keys press event Pin
Dave Kreskowiak30-Jan-10 6:43
mveDave Kreskowiak30-Jan-10 6:43 
QuestionAdd Printer Driver Pin
Anubhava Dimri30-Jan-10 1:26
Anubhava Dimri30-Jan-10 1:26 
AnswerRe: Add Printer Driver Pin
Luc Pattyn30-Jan-10 1:56
sitebuilderLuc Pattyn30-Jan-10 1:56 
AnswerRe: Add Printer Driver Pin
Dave Kreskowiak30-Jan-10 6:37
mveDave Kreskowiak30-Jan-10 6:37 
QuestionHow to open new tab in Internet Explorer 7 using VBA (Excel) Pin
mprathore29-Jan-10 22:24
mprathore29-Jan-10 22:24 
QuestionRe: How to open new tab in Internet Explorer 7 using VBA (Excel) Pin
DaveAuld30-Jan-10 1:03
professionalDaveAuld30-Jan-10 1:03 
AnswerRe: How to open new tab in Internet Explorer 7 using VBA (Excel) Pin
mprathore31-Jan-10 5:56
mprathore31-Jan-10 5:56 
GeneralRe: How to open new tab in Internet Explorer 7 using VBA (Excel) Pin
DaveAuld31-Jan-10 8:03
professionalDaveAuld31-Jan-10 8:03 
Right, i have managed to do it, but it is browser setting dependent;

I put a bunch off URLs on an excel spreadsheet, and a button pointing to the following code;

Public Sub goNav()
Dim ie as Object

Set IE = CreateObject("InternetExplorer.Application")
ie.visible = true

Dim x as integer
Dim links as Hyperlinks
Set links = ActiveSheet.Hyperlinks

For x = 1 to links.count
ie.navigate links.item(x).address,nothing, "_blank"
next

End Sub


For it to open in new tabs this setting must be set in IE settings;
Internet Options
General Tab
Tabs Settings : Settings
Always open pop-ups in a new tab = Selected


Sorry, Best I can Do!

Dave

Don't forget to vote on messages!
Find Me On: Web|Facebook|Twitter|LinkedIn
Waving? dave.m.auld[at]googlewave.com

QuestionCalling javascript function from VBscript Pin
Ash_VCPP29-Jan-10 21:34
Ash_VCPP29-Jan-10 21:34 
AnswerRe: Calling javascript function from VBscript Pin
Richard MacCutchan29-Jan-10 22:32
mveRichard MacCutchan29-Jan-10 22:32 
AnswerRe: Calling javascript function from VBscript Pin
Eddy Vluggen30-Jan-10 0:48
professionalEddy Vluggen30-Jan-10 0:48 
QuestionTcpListener problem Pin
AliAmjad29-Jan-10 20:50
AliAmjad29-Jan-10 20:50 
AnswerRe: TcpListener problem [modified] Pin
DaveAuld29-Jan-10 21:23
professionalDaveAuld29-Jan-10 21:23 
GeneralRe: TcpListener problem Pin
AliAmjad29-Jan-10 21:45
AliAmjad29-Jan-10 21:45 
AnswerRe: TcpListener problem Pin
DaveAuld29-Jan-10 22:04
professionalDaveAuld29-Jan-10 22:04 
AnswerRe: TcpListener problem Pin
Luc Pattyn30-Jan-10 2:02
sitebuilderLuc Pattyn30-Jan-10 2:02 
AnswerRe: TcpListener problem Pin
Dave Kreskowiak30-Jan-10 6:30
mveDave Kreskowiak30-Jan-10 6:30 
GeneralRe: TcpListener problem Pin
AliAmjad31-Jan-10 1:49
AliAmjad31-Jan-10 1:49 
QuestionBindingSource Pin
wikus7029-Jan-10 1:00
wikus7029-Jan-10 1:00 
AnswerRe: BindingSource Pin
Wayne Gaylard29-Jan-10 2:13
professionalWayne Gaylard29-Jan-10 2:13 
GeneralRe: BindingSource Pin
wikus7031-Jan-10 19:25
wikus7031-Jan-10 19:25 
GeneralRe: BindingSource Pin
Wayne Gaylard1-Feb-10 0:54
professionalWayne Gaylard1-Feb-10 0:54 
GeneralRe: BindingSource Pin
wikus701-Feb-10 2:47
wikus701-Feb-10 2:47 
GeneralRe: BindingSource Pin
Wayne Gaylard1-Feb-10 21:16
professionalWayne Gaylard1-Feb-10 21:16 
QuestionHow to access an unknown file format? Pin
Sonhospa28-Jan-10 23:24
Sonhospa28-Jan-10 23:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.