open a file named with space

[lubbamkt]

Hi all,

How could I open a file named with space in a specified path ?
Path : "C:\Documents and Settings\"
Filename : "Finance Budget 2014"

There are several xls files in the folder
Marketing Budget 2014
Finance Budget 2014
miscellaneous 2014

What I would like to open is those files with "Budget".
This is what I coded so far, but this is not working

Please Login or Register  to view this content.

Could anyone help me please? Thanks

[protonLeah]

To insert the actual code, click the # icon, then paste your code lines between the [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags that appear. Please copy and paste from the VB editor itself.

[lubbamkt]

Could anyone help please?

[patel45]

It's not clear for me, do you want open all the files with budget ? only one ?

[lubbamkt]

It's not clear for me, do you want open all the files with budget ? only one ?

I would like to open ALL files with the word "Budget". Thanks

[Marc L]

Hi,

try Dir("C:\Documents and Settings\*Budget*.xls") …

[lubbamkt]

Hi,

try Dir("C:\Documents and Settings\*Budget*.xls") …

Hi Marc L,

It does not work. I guess I miss something on the first word in the file name (i.e. Marketing and Finance)

[lubbamkt]

Please help

[patel45]

Please Login or Register  to view this content.

[apo]

Same but different..

Please Login or Register  to view this content.

[lubbamkt]

Please Login or Register  to view this content.

thank you so much

[lubbamkt]

Same but different..

Please Login or Register  to view this content.

thank you so much