Results 1 to 12 of 12

Open file when file path contains dates

Threaded View

heathb Open file when file path... 07-09-2019, 09:42 AM
CK76 Re: Open file when file path... 07-09-2019, 09:49 AM
WideBoyDixon Re: Open file when file path... 07-09-2019, 09:51 AM
Greg M Re: Open file when file path... 07-09-2019, 10:16 AM
dangelor Re: Open file when file path... 07-09-2019, 10:38 AM
heathb Re: Open file when file path... 07-09-2019, 10:57 AM
heathb Re: Open file when file path... 07-10-2019, 10:23 AM
dangelor Re: Open file when file path... 07-09-2019, 12:09 PM
heathb Re: Open file when file path... 07-10-2019, 10:00 AM
Greg M Re: Open file when file path... 07-09-2019, 06:24 PM
heathb Re: Open file when file path... 07-10-2019, 10:36 AM
dangelor Re: Open file when file path... 07-10-2019, 06:09 PM
  1. #6
    Registered User
    Join Date
    05-10-2013
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    68

    Re: Open file when file path contains dates

    Thanks all, however none of the above finds the file, just opens the message box

    Debug tells me the Expression YEAR is not defined!

    Should it be in quotes?
    Last edited by heathb; 07-09-2019 at 11:04 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Using Workbook.Open to open an excel file with a variable path
    By walt737 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-27-2019, 01:01 PM
  2. Automatically open a file in a specific file path when another sheet is opened
    By joshnathan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-20-2014, 11:05 AM
  3. Replies: 5
    Last Post: 09-29-2012, 12:40 PM
  4. VBA Changing a fixed file path with open file dialog box
    By Dan27 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-01-2011, 08:54 AM
  5. open file path
    By Bigelk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-18-2011, 09:00 AM
  6. Open Word file form Excel using VBA and file path
    By psychoPETE in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-05-2010, 07:02 PM
  7. Saving file to same path as open file
    By Glio in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-19-2007, 04:57 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