Results 1 to 3 of 3

Open other program and use extra functions there

Threaded View

JorisDDS Open other program and use... 10-22-2013, 09:47 AM
alansidman Re: Open other program and... 10-22-2013, 09:52 AM
JorisDDS Re: Open other program and... 10-22-2013, 09:55 AM
  1. #1
    Registered User
    Join Date
    10-22-2013
    Location
    Belgium
    MS-Off Ver
    Excel 2003
    Posts
    15

    Open other program and use extra functions there

    Hey everybody,

    I have a quite specific question. I already know how to open a different program and file using the SHELL command. This is what I have so far :
    Public Sub OpenPythagoras()
        Dim f As Variant
        Dim Path As String
        Dim File As String
        Dim x As Double
        Dim y As Double
        
    
        Path = "C:\Program Files\Pythagoras\pythagoras.exe"
        File = "L:\Grondbeleid\Algemeen\GIS Dendermonde/GIS-poging 1.pyt"
    
        f = Shell(Path + " " + File, vbNormalFocus)
        
        
        x = ActiveCell.Value
        y = ActiveCell.Offset(, 1).Value
    the x and y are coordinates. And my question to you guys is if there might be a way to open my file and let that program zoom to those coördinates.

    So my excel file contains a numer of coördinates together with extra info about those places. I want something that allows me to select the coördinates and my program with the map opens up and it zooms to those coörds. If it's impossible to do everything directly from excel maybe the key will be to add a vba macro in that software that makes me select the coords in the excel file and zooms to it ...
    Last edited by alansidman; 10-22-2013 at 09:52 AM. Reason: code tags added

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Help required with IF functions - adding an extra variable and outcome
    By JoeSmart in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-20-2013, 07:39 AM
  2. Replies: 8
    Last Post: 08-27-2012, 04:37 PM
  3. (IF formula) Adding extra functions
    By nacho12 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-23-2009, 04:17 AM
  4. I cant open files unless I open the Excel program first
    By ElaineAng in forum Excel General
    Replies: 3
    Last Post: 02-16-2006, 11:00 AM
  5. open up an excel program with an auto open macro
    By john.9.williams@bt.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-17-2005, 12:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1