+ Reply to Thread
Results 1 to 2 of 2

#vba makro open workbook from last filename#

  1. #1
    Valued Forum Contributor
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,241

    Question #vba makro open workbook from last filename#

    my path = thisworkbook.path
    i have many file in my folder
    every filename in first caracter by number 1.filename1,2.filename,3.filename
    i want with vba makro excel open one by one
    start from ubound (filename)
    star from 3.filename,2.filename and 1,1.filename
    how can i do with vba makro excel
    thankyou

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: #vba makro open workbook from last filename#


    Start to see in VBA inner help the use of Dir function …

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Workbook.open a filename with path and cell value in it
    By dutchmaste in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-16-2016, 09:02 PM
  2. Value from another open workbook in filename
    By biznez in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-23-2015, 03:40 PM
  3. Using Workbook.Open Filename to Open a Cell Reference Filename
    By PerplexedMel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-10-2014, 12:20 PM
  4. Workbook.Open Filename procedure
    By dschmitt in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-16-2010, 10:30 PM
  5. Activating an Open Workbook without using the whole filename as a reference
    By jlejehan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-02-2006, 02:58 AM
  6. Open filename using workbook property
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-24-2006, 09:25 PM
  7. Makro to Run on Open Workbook
    By Rob Fenn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2005, 09:05 AM

Tags for this Thread

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