+ Reply to Thread
Results 1 to 3 of 3

Opening .xlsx and .xls files within 1 script

  1. 06-23-2022, 04:08 PM #1
    ahuang3433
    ahuang3433 is offline
    Registered User
    Join Date
    10-21-2016
    Location
    Broken Arrow, Oklahoma
    MS-Off Ver
    2010
    Posts
    71

    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.
    Reply With QuoteRegister To Reply
  2. 06-23-2022, 04:20 PM #2
    Artik
    Artik is offline
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    1,334

    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
    Reply With QuoteRegister To Reply
  3. 06-23-2022, 04:32 PM #3
    ahuang3433
    ahuang3433 is offline
    Registered User
    Join Date
    10-21-2016
    Location
    Broken Arrow, Oklahoma
    MS-Off Ver
    2010
    Posts
    71

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

    The * worked. Thanks!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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. Automatically opening files, running a script and saving it, Thank you
    By AHUS in forum Excel General
    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. Combining two .xlsx worksheets in separate xlsx files into a single worksheet in a new wor
    By Drivium in forum Excel Programming / VBA / Macros
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1