+ Reply to Thread
Results 1 to 2 of 2

Faster Import of XLSX File needed (plus "delete specific lines")

  1. 01-01-2017, 04:42 PM #1
    ydrive
    ydrive is offline
    Registered User
    Join Date
    06-14-2016
    Location
    Berlin
    MS-Off Ver
    2013
    Posts
    6

    Faster Import of XLSX File needed (plus "delete specific lines")

    Hi there,

    currently I am looking for a way to improve my current import method. This is what I have:

    Please Login or Register  to view this content.
    Is there a way to "Ctrl-A", "Ctrl-V" all the data and then simply have the necessary rows deleted? Would that even be faster?

    Edit: I have about 15.000 rows to copy, currently it takes about 3 minutes

    Thank you for your help
    Last edited by ydrive; 01-01-2017 at 04:45 PM. Reason: Additional Info
    Reply With QuoteRegister To Reply
  2. 01-01-2017, 05:49 PM #2
    kasan
    kasan is offline
    Valued Forum Contributor kasan's Avatar
    Join Date
    07-22-2009
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    680

    Re: Faster Import of XLSX File needed (plus "delete specific lines")

    Hi,
    Faster way to get data from xlsx file would be "SQL query". This way you don't need to open source file, just define your criteria for data and extract them.
    As example you can check out this topic: http://www.excelforum.com/showthread.php?t=1166014
    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. [SOLVED] VBA, convert tool from XLSM to XLSX; I need ignore "locked file"
    By martin81 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-29-2016, 03:54 AM
  2. Excel spreadsheet gets error "Excel cannot open the file .xlsx.." How can I "uncorrupt"
    By allisoncharles563 in forum Excel General
    Replies: 2
    Last Post: 01-18-2016, 02:31 AM
  3. [SOLVED] Faster code to delete character "#"
    By Villalobos in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2015, 04:26 AM
  4. [SOLVED] Script to save to folder in "v:\dept2", confirm file saved, then delete from "v:\dept1"
    By ks100 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2014, 11:42 AM
  5. [SOLVED] Stop Users Saving Macro Enabled File as ".xlsx"
    By OzTrekker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-17-2012, 11:33 PM
  6. Excel cannot open the file "XX.xlsx" because the file formate or file extensiom is not
    By s22086902 in forum Excel General
    Replies: 3
    Last Post: 11-10-2012, 05:38 PM
  7. VBA Help needed for saving workbook specific folder and file extension ".xlsm"
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-13-2012, 07:50 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