file folder macro's
 

Can anyone help? Ive got files within a file folder. Im trying to
create a macro that will let me open the file folder and then I can
select a file within the folder to open by myself. At the moment I can
create a macro to open a particular file within the file folder. Can
anyone help?


--
tweacle
------------------------------------------------------------------------
tweacle's Profile: http://www.excelforum.com/member.php...o&userid=25829
View this thread: http://www.excelforum.com/showthread...hreadid=392197

file folder macro's
 

chdrive "C"
Chdir "C:\Myfolder"
fname = Application.GetOpenFileName()
msgbox "File to open is " & fName
--
Regards,
Tom Ogilvy

"tweacle" wrote in
message ...

Can anyone help? Ive got files within a file folder. Im trying to
create a macro that will let me open the file folder and then I can
select a file within the folder to open by myself. At the moment I can
create a macro to open a particular file within the file folder. Can
anyone help?


--
tweacle
------------------------------------------------------------------------
tweacle's Profile:
http://www.excelforum.com/member.php...o&userid=25829
View this thread: http://www.excelforum.com/showthread...hreadid=392197