473,320 Members | 1,872 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How to connect address in excel to yahoo maps?

I was wondering is it possible to have a user input data via userform and have the address that the user inputted connect to say yahoo maps so that it can give them directions. can this be done?
Jul 28 '10 #1

✓ answered by Guido Geurs

See attachment.
Add the reference "Windows API" and use the code=

Expand|Select|Wrap|Line Numbers
  1. Private Sub CMDmap_Click()
  2. Dim r As Long
  3.    If Selection.Value <> "" Then
  4.       r = ShellExecute(0, "open", Selection.Value, 0, 0, 1)
  5.    Else
  6.       MsgBox "Select a Address"
  7.    End If
  8. End Sub
  9.  
Or add the API declaration in the form=

Expand|Select|Wrap|Line Numbers
  1. Private Declare Function ShellExecute _
  2.                             Lib "shell32.dll" _
  3.                             Alias "ShellExecuteA"( _
  4.                             ByVal hwnd As Long, _
  5.                             ByVal lpOperation As String, _
  6.                             ByVal lpFile As String, _
  7.                             ByVal lpParameters As String, _
  8.                             ByVal lpDirectory As String, _
  9.                             ByVal nShowCmd As Long) _
  10.                             As Long

3 1597
Guido Geurs
767 Expert 512MB
See attachment.
Add the reference "Windows API" and use the code=

Expand|Select|Wrap|Line Numbers
  1. Private Sub CMDmap_Click()
  2. Dim r As Long
  3.    If Selection.Value <> "" Then
  4.       r = ShellExecute(0, "open", Selection.Value, 0, 0, 1)
  5.    Else
  6.       MsgBox "Select a Address"
  7.    End If
  8. End Sub
  9.  
Or add the API declaration in the form=

Expand|Select|Wrap|Line Numbers
  1. Private Declare Function ShellExecute _
  2.                             Lib "shell32.dll" _
  3.                             Alias "ShellExecuteA"( _
  4.                             ByVal hwnd As Long, _
  5.                             ByVal lpOperation As String, _
  6.                             ByVal lpFile As String, _
  7.                             ByVal lpParameters As String, _
  8.                             ByVal lpDirectory As String, _
  9.                             ByVal nShowCmd As Long) _
  10.                             As Long
Attached Files
File Type: zip How to connect address in excel to yahoo maps_v1.zip (10.6 KB, 72 views)
Jul 28 '10 #2
@ggeu
not sure really where to add this too. My userform? my worksheet? my workbook? in my code for the enter button? or do I create two more buttons and create the code for this? please help ggeu
Jul 29 '10 #3
@ggeu
works great ggeu thanks again.
Jul 29 '10 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Roman | last post by:
I've been trying this one for 2-3 hours and can't figure it out. I'de appreciate any help or pointers in the right direction. Thanks. Query I need the query to return me all the lottery names...
9
by: sifar | last post by:
Hi, I am right now learning PHP & want to know if there is a way to send web form data to an Excel sheet located on a network. My windows xp PC doesnot have a copy of Excel. Also i am not...
7
by: MLH | last post by:
Say I've got an Access 97 database open with at customer table in it having street address, city, state and zip. How much trouble is it for me to feed my origination address and a customer...
0
by: yyt | last post by:
I am programmatically adding a web user control to a webform. This User Control displays the employee listing from a database into a datagrid. But the calling webform should render the data as a...
3
by: hkappleorange | last post by:
I connect to mdb file using the following codes. How should I modify it if I want to connect to Excel instead ? <%@ Import Namespace="System.Data.OleDb" %> <% Dim conAuthors As...
1
by: MattNZ | last post by:
I am working in access on a program which requires me to multiply all the values in a field by each other. This is easy to replicate in excel, but I can't figure out how to do this in access. Here...
2
by: Brian Parker | last post by:
I need to format text in cell in an Excel worksheet and I need to do this using C#. I've seen code that will set the format for the whole cell, but I just need to format one character in that...
2
by: clintonG | last post by:
While using this website which loads all three for comparison: http://www.rockstarapps.com/samples/map-compare/ I realized how terrible Virtual Earth imagery is. Microsoft is using Navteq while...
4
by: Jim Rutledge | last post by:
ok ok , anyone know anything on this tough question? How do you determine the length in seconds that a midi file is , or any audio file for that matter ?
6
doma23
by: doma23 | last post by:
Currently I'm working on development of an access application that deals with some fiancial data. I need a button on access form that will when clicked open powerpoint file and create and insert...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.