+ Reply to Thread
Results 1 to 1 of 1

Error when importing table from PDF to Excel

  1. #1
    Registered User
    Join Date
    08-18-2017
    Location
    Canada
    MS-Off Ver
    MS Office 2010
    Posts
    1

    Error when importing table from PDF to Excel

    Hi Guys!

    I have this almost figured out and it works great, except I run into the following errors anytime I open the workbook and have to go through this process of uncommenting and commenting a section of code.

    Below is the code:

    Please Login or Register  to view this content.
    So when I first run the macro to import the data into the "ImportPDF" worksheet the data looks like ths:Error 20.JPG

    So to solve all the data being exported into a single coloumn: This section of code was written:

    Please Login or Register  to view this content.
    So I would uncomment this line of code and then re run the macro. I have to run the macro twice. The second time I run the macro I get this error: error11.JPG

    Once I get that error, if I comment that code again, and run the macro. The data transfer is perfect and works like a charm. But if I close the workbook, I have to redo the entire process. Does anyone know why that is? or how I can fix this issue?
    Last edited by Faiz2430; 08-18-2017 at 01:46 PM.

+ 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. Error checking Importing table from Access
    By Smally in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-05-2015, 07:50 AM
  2. Importing a table from Adobe to Excel
    By duby13 in forum Excel General
    Replies: 1
    Last Post: 01-08-2013, 04:00 AM
  3. Importing excel spreadsheet into access table, getting excel row header error
    By ncsthbell in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-19-2010, 02:36 PM
  4. Importing a PDF table into Excel
    By zapp7 in forum Excel General
    Replies: 5
    Last Post: 05-25-2010, 02:21 PM
  5. Importing a table that is on several pages into excel
    By edwine in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-14-2009, 10:49 AM
  6. Importing Data From Another Excel Sheet Error
    By snake10 in forum Excel General
    Replies: 1
    Last Post: 02-29-2008, 07:36 PM
  7. Importing Excel into Access - Error 1706
    By tmb in forum Excel General
    Replies: 0
    Last Post: 03-21-2005, 04:06 PM

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