Using RunApp macro to open a mapinfo table

[martyrocks]

Hi all, i'm not very well versed with Access at all (more of a script kiddie when it comes to macros and commands) and so far, i'm able to use the runapp command to open the actual mapinfo program, but additionally, I'd like the command to open up a table and/ or workspace as well.

I've fiddled around with the VB editor and this works:

stAppName = "C:\Program Files\MapInfo\Professional\MAPINFOW.EXE"

So far so good.

Now the workspace I want to open is actually in a completely different directory - "V:\Arterial Routes\ARMaps\North.wor"

How do I go about linking or combining these two so that they open with only one click of the command button?

Cheers in advance,
Marty

[Tanis]

You can use the Shell command to open another application.

Dim stAppName As String

stAppName = "PathToApplication " & "PathnameOfFile"

Call Shell(stAppName, 1)

This is VBA, I would try to avoid macros if at all possible.

[PEB]

This you can put it into on click event of your wanted bouton..

Shell is available also as function
Dim i
i=shell(Pathname,1)

:)

[martyrocks]

Ah, my mistake, it is VB i'm using (see? Pure script kiddie!) but I got it sorted. Cheers for the help guys.