+ Reply to Thread
Results 1 to 3 of 3

Error from converting PDF to Excel files

  1. #1
    Registered User
    Join Date
    10-31-2022
    Location
    Kuala Lumpur
    MS-Off Ver
    2021
    Posts
    11

    Error from converting PDF to Excel files

    Hi all, I am currently trying to create a macro that helps me convert about 150 PDF files in a folder to Excel files in another folder. Below is my code:

    Please Login or Register  to view this content.
    After running this macro, the error either is "Error 400"or "Runtime Error '1004': Application-defined or Object-defined error".

    Anyone has any idea to debug this? I have tried looking for few days but still can't figure it out.

    Thanks in advance.

  2. #2
    Forum Expert ByteMarks's Avatar
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    3,090

    Re: Error from converting PDF to Excel files

    Try pausing for a couple of seconds either side of the paste


    Please Login or Register  to view this content.

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2505 Win 11
    Posts
    24,755

    Re: Error from converting PDF to Excel files

    crossposted: https://www.mrexcel.com/board/thread...files.1221528/

    Rule 03: Cross-posting Without Telling Us

    Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

    Post a link to any other forums where you have asked the same question.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Read this to understand why we ask you to do this.

    I have added the crosspost reference for you today. Please comply with this and all our rules in the future

    However, if you continue to crosspost, you can expect to have your thread BLOCKED until you update it yourself.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. converting excel files into csv txt files
    By robfeels in forum Excel General
    Replies: 0
    Last Post: 08-08-2013, 08:01 AM
  2. Replies: 1
    Last Post: 02-29-2012, 01:15 PM
  3. [SOLVED] Converting Adobe files into Excel files
    By sweetsue516 in forum Excel General
    Replies: 2
    Last Post: 03-13-2006, 03:10 PM
  4. Converting excel files
    By newbie82 in forum Excel General
    Replies: 1
    Last Post: 12-03-2005, 08:16 PM
  5. Converting files for Excel
    By Herb Lady in forum Excel General
    Replies: 3
    Last Post: 11-10-2005, 07:49 PM
  6. Converting files to excel
    By creativeamy via OfficeKB.com in forum Excel General
    Replies: 1
    Last Post: 09-29-2005, 11:05 AM
  7. Converting CSV files into Excel files
    By baski in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-13-2005, 08:05 PM
  8. Converting DBF Files to Excel
    By Marc Berris in forum Excel General
    Replies: 4
    Last Post: 03-13-2005, 02:07 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