'Hi

'Could any one tell me if there is an API Command, or Is there a Default Variable that holds the PATH of the Macro thats being read .

'When I move my macro from one machine to the next i have to manually change the path.

'Im thinking it would be really nice if the Macro used its own file path as a default location for accessing any attached files.

Dim MyFilePath As String

Dim MyFile As Object

MyFilePath="F:\SWApiStudy\SomeData.txt"

Set MyFile = GetObject(MyFilePath)

'For Example Instead of the Above Code

'Is there a command, or does the API Macro know which folder its being read from

'It would be ideal if I could simply write :

Dim MyFile As Object

Set MyFile = GetObject(SomeData.txt)

'Im sure there is some way to reference the Macro.SWP Location from the SWP or SW itself.

'Can anyone help please ?

'Thanks Matt