+ Reply to Thread
Results 1 to 3 of 3

Opening .xlsx and .xls files within 1 script

  1. #1
    Registered User
    Join Date
    10-21-2016
    Location
    Broken Arrow, Oklahoma
    MS-Off Ver
    2010
    Posts
    84

    Opening .xlsx and .xls files within 1 script

    I have 3 files that I'm trying to open to extract data from. 2 of them are .xlsx and 1 is .xls. How can I change the script below to open either file type?

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,161

    Re: Opening .xlsx and .xls files within 1 script

    Try
    Please Login or Register  to view this content.
    or
    Please Login or Register  to view this content.
    Artik

  3. #3
    Registered User
    Join Date
    10-21-2016
    Location
    Broken Arrow, Oklahoma
    MS-Off Ver
    2010
    Posts
    84

    Re: Opening .xlsx and .xls files within 1 script

    The * worked. Thanks!

+ 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. VBA to take data from cells in a number of XLSX files and paste them into a single XLSX
    By vancouver_ron in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 01-20-2020, 11:59 PM
  2. Replies: 1
    Last Post: 03-01-2018, 08:51 AM
  3. Tweaking A Powershell Script for Opening CSV Files as Text
    By scott123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-04-2016, 02:58 PM
  4. Replies: 0
    Last Post: 01-14-2016, 03:22 PM
  5. Opening only xlsx files
    By RoyLittle0 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-22-2014, 02:27 AM
  6. How to automatically get values from one .xlsx to another without opening files?
    By kummakki in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-22-2012, 12:44 PM
  7. How to add the columns data of several xlsx files of a folder in another xlsx file
    By ravikumar00008 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-25-2012, 04:29 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