Group,
Another novice question. When I open a file I use the following
code. The first use of my spreadsheet always begins in a folder other
than where the files are located. Once I navigate to the folder where
my files are located, Excel remembers the path. Then each subsequent
opening and Excel opens that folder. Is there a way to always open the
folder where my spreadsheet is located? Assume my files are located in
folder c:\MPI .




fn2 = Application.GetOpenFilename("Current MPI File,*.mpi", 1,
"Select NEW MPI File To Open", , False)


Tony


--
ajocius
------------------------------------------------------------------------
ajocius's Profile: http://www.excelforum.com/member.php...o&userid=17695
View this thread: http://www.excelforum.com/showthread...hreadid=470534

Use the ChDir before the Application.GetOpenFilename dialog to set the
path.........

e.g.....

ChDir "C:\Nigel"
fn2 = Application.GetOpenFilename("Current MPI File,*.mpi", 1, _
"Select NEW MPI File To Open", , False)

--
Cheers
Nigel



"ajocius" wrote in
message ...

Group,
Another novice question. When I open a file I use the following
code. The first use of my spreadsheet always begins in a folder other
than where the files are located. Once I navigate to the folder where
my files are located, Excel remembers the path. Then each subsequent
opening and Excel opens that folder. Is there a way to always open the
folder where my spreadsheet is located? Assume my files are located in
folder c:\MPI .




fn2 = Application.GetOpenFilename("Current MPI File,*.mpi", 1,
"Select NEW MPI File To Open", , False)


Tony


--
ajocius
------------------------------------------------------------------------
ajocius's Profile:
http://www.excelforum.com/member.php...o&userid=17695
View this thread: http://www.excelforum.com/showthread...hreadid=470534

Maybe you must use ChDrive also
See how I use it here
http://www.rondebruin.nl/copy3.htm

It will restore the original path when it is done also



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Nigel" wrote in message ...
Use the ChDir before the Application.GetOpenFilename dialog to set the
path.........

e.g.....

ChDir "C:\Nigel"
fn2 = Application.GetOpenFilename("Current MPI File,*.mpi", 1, _
"Select NEW MPI File To Open", , False)

--
Cheers
Nigel



"ajocius" wrote in
message ...

Group,
Another novice question. When I open a file I use the following
code. The first use of my spreadsheet always begins in a folder other
than where the files are located. Once I navigate to the folder where
my files are located, Excel remembers the path. Then each subsequent
opening and Excel opens that folder. Is there a way to always open the
folder where my spreadsheet is located? Assume my files are located in
folder c:\MPI .




fn2 = Application.GetOpenFilename("Current MPI File,*.mpi", 1,
"Select NEW MPI File To Open", , False)


Tony


--
ajocius
------------------------------------------------------------------------
ajocius's Profile:
http://www.excelforum.com/member.php...o&userid=17695
View this thread: http://www.excelforum.com/showthread...hreadid=470534

Gentlemen,
I guess my fingers were typing faster than my brain engaged. But
my application will sit on numerous engineers computers who are
connected to a network and who have different paths to their respective
Desktops. How am I able to open a folder from where my Excel file
resides. I know I didn't explain the original post as clearly. Please
ignore the c:\MPI.

Tony


--
ajocius
------------------------------------------------------------------------
ajocius's Profile: http://www.excelforum.com/member.php...o&userid=17695
View this thread: http://www.excelforum.com/showthread...hreadid=470534

See the code I use here
http://www.rondebruin.nl/copy3.htm#select

Example 6


--
Regards Ron de Bruin
http://www.rondebruin.nl


"ajocius" wrote in message
...

Gentlemen,
I guess my fingers were typing faster than my brain engaged. But
my application will sit on numerous engineers computers who are
connected to a network and who have different paths to their respective
Desktops. How am I able to open a folder from where my Excel file
resides. I know I didn't explain the original post as clearly. Please
ignore the c:\MPI.

Tony


--
ajocius
------------------------------------------------------------------------
ajocius's Profile: http://www.excelforum.com/member.php...o&userid=17695
View this thread: http://www.excelforum.com/showthread...hreadid=470534

Use ChDir and ChDrive together with thisworkbook.path (or
activeworkbook.path as appropriate).

Option Explicit

Sub testIt()
Dim SavedPathname As String

MsgBox Application.GetOpenFilename()
SavedPathname = CurDir

ChDir ThisWorkbook.Path
ChDrive ThisWorkbook.Path
MsgBox Application.GetOpenFilename()

ChDir SavedPathname
ChDrive SavedPathname
MsgBox Application.GetOpenFilename()
End Sub

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

Group,
Another novice question. When I open a file I use the following
code. The first use of my spreadsheet always begins in a folder other
than where the files are located. Once I navigate to the folder where
my files are located, Excel remembers the path. Then each subsequent
opening and Excel opens that folder. Is there a way to always open the
folder where my spreadsheet is located? Assume my files are located in
folder c:\MPI .




fn2 = Application.GetOpenFilename("Current MPI File,*.mpi", 1,
"Select NEW MPI File To Open", , False)


Tony


--
ajocius
------------------------------------------------------------------------
ajocius's Profile: http://www.excelforum.com/member.php...o&userid=17695
View this thread: http://www.excelforum.com/showthread...hreadid=470534