0

Hi group,

I'm starting a test to see if I can automate some tasks. In this first test, I'm using System.Diagnostics to open a specific version (I actually have two versions on my computer - both are needed). After that's open, I want to open a specific file within that instance of the application. However I've not figured out how to do this. I've only completed this much so far:

        Dim myFile As New System.Diagnostics.Process

    With myFile
        .StartInfo.WorkingDirectory = "C:\Program Files (x86)\Tableau\Tableau 8.3\bin"
        .StartInfo.FileName = "tableau.exe"
    End With
    myFile.Start()

Now I need to open the following filepath/filename:

O:\Revenue Management\RM -- Specialty Select Brands\Analytics\Tableau Extracts\Pace\SSB_FR_FUTURE_PACE_LOC.twbx

How do I go about doing this?

I did try entering the filepath as ".StartInfo.WorkingDirectory" and the filename as ".StartInfo.FileName". This "worked" except that it opened it file in the most recent version of the Tableau program (which in this instance I cannot do).

I look forward to your thoughts and ideas.

Thanks again!

Don

2
Contributors
2
Replies
20
Views
1 Year
Discussion Span
Last Post by doncwilson_1
1

StartInfo class has Arguments property where you can pass parameters. In your case it is the name of the file you want to open.

Add following line after line 5
.StartInfo.Arguments = "O:\Revenue Management\RM -- Specialty Select Brands\Analytics\Tableau Extracts\Pace\SSB_FR_FUTURE_PACE_LOC.twbx"

Now "O:\Revenue Management\RM -- Specialty Select Brands\Analytics\Tableau Extracts\Pace\SSB_FR_FUTURE_PACE_LOC.twbx" is passed as an argument to "tableau.exe" application.

HTH

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.