Results 1 to 12 of 12

open a file named with space

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-12-2010
    Location
    HK
    MS-Off Ver
    Excel 2010
    Posts
    189

    open a file named with space

    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
    MyFile = Dir("C:\Documents and Settings\"& "*Budget" & ".xls")
    Could anyone help me please? Thanks
    Last edited by lubbamkt; 05-05-2014 at 02:37 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] open variably named file, copy/paste data into consolidation file, open next file in list
    By sllawrence1968 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2012, 09:49 PM
  2. Macro to open same named file from different folder
    By mrvindu in forum Excel General
    Replies: 0
    Last Post: 02-25-2011, 03:37 PM
  3. Open Variably-named File
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-24-2010, 12:28 PM
  4. Open space delimited text file and transpose
    By bahgia in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-13-2010, 11:32 AM
  5. How do I open a file from a named cell?
    By Cumberland in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-23-2006, 04:15 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1