Open file from unspecified location using macro

[amitmodi_mrt]

Hi, i am looking for a vba that can open a file without giving location/path. I am using below code, but if i move Test.xls to any other folder it is not opening the file and giving me run-time error 1004

Please Login or Register  to view this content.

Any Help please

[dominicb]

Good morning amitmodi_mrt

Use the standard file selection dialog so the user can choose the file and where it needs to be opened from, thus :

Please Login or Register  to view this content.

HTH

DominicB

[PFDave]

Hi,

First you need to be using code tags [c0de] at the start then [/c0de] at the end (replace the zeros with o's but I've done this for it to display.

Secondly I'm sure someone can advise on this, although I can't

[NickyC]

Hi
this macro should search all subdirectories in the specified drive or root directory for a file with the name given at FindFile
it will be rather slow if you have lots of files.
you will need to have Microsoft Scripting Runtime checked under tools > references for it to work

Please Login or Register  to view this content.

[PFDave]

NickyC - I get a compile error on this line

Please Login or Register  to view this content.

[amitmodi_mrt]

I m getting Run time error 70: Permission Denied on line

Please Login or Register  to view this content.

[NickyC]

PF Dave, do you have Microsoft Scripting Runtime checked under tools > references? If you don't please select this. If it still doesn't work, try removing scripting. from scripting.folder in the declaration.

amitmodt_mrt The permission denied probably means you are trying to access protected or hidden folders. Try moving up the folder chain eg setting the root directory to c:\MyDocuments rather than C:\