Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default VBA to open in different browser

Hi, I have a HTML viewer called Navroad (freebie on the web).
I would like to load images, and HTML files, using this browser.
How can I alter the following code to open the files in the
aforementioned browser.

This is the code I currently use...

Private Sub CommandButton1_Click()
Dim Picture As String
Dim RETVAL
Picture = "C:\" & Sheets("Sheet2").Range("C4").Value & ".jpg"
RETVAL = Shell("EXPLORER " & Picture, 1)
End Sub

When viewed in NavRoad the title bar contains "NavRoad - C:\image1.jpg"
..
The program process is identified as "nroad32.exe".

Any help would be greatly appreciated.

Regards

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default VBA to open in different browser

did you try

Private Sub CommandButton1_Click()
Dim Picture As String
Dim RETVAL
Picture = "C:\" & Sheets("Sheet2").Range("C4").Value & ".jpg"
RETVAL = Shell("nroad32.exe " & Picture, 1)
End Sub

--
Regards,
Tom Ogilvy

"obsessive" wrote in message
oups.com...
Hi, I have a HTML viewer called Navroad (freebie on the web).
I would like to load images, and HTML files, using this browser.
How can I alter the following code to open the files in the
aforementioned browser.

This is the code I currently use...

Private Sub CommandButton1_Click()
Dim Picture As String
Dim RETVAL
Picture = "C:\" & Sheets("Sheet2").Range("C4").Value & ".jpg"
RETVAL = Shell("EXPLORER " & Picture, 1)
End Sub

When viewed in NavRoad the title bar contains "NavRoad - C:\image1.jpg"
.
The program process is identified as "nroad32.exe".

Any help would be greatly appreciated.

Regards



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default VBA to open in different browser

Thanks for the reply Tom!
I've been admiring your work on these excel groups for a while.
Anyway, after searching a little more and playing with it I got it!!
This is pretty cool... not only because it works, but because this
offline viewer is easily configured to remove tool bars ... anyway...
this worked ...

Private Sub CommandButton1_Click()
Shell "C:\Program Files\NavRoad HTML Viewer\nroad32.exe" & _
" C:\" & Sheets("Sheet2").Range("C4").Value & ".jpg"
End Sub

Thanks again.
Regards

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open Excel not in a browser JS82 Excel Discussion (Misc queries) 1 March 30th 07 02:42 PM
excel can not open on some IE browser Faiz Excel Discussion (Misc queries) 3 July 20th 06 01:29 PM
Open Browser Maximized Stephen Newman Excel Programming 4 April 17th 06 11:54 PM
Open Hyperlinks at the same browser p_uriel Excel Worksheet Functions 0 December 25th 05 10:57 AM
Open browser from excel nivek Excel Programming 2 January 21st 05 03:54 PM


All times are GMT +1. The time now is 12:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"