VBA to Read or Extract PDF Tables without Reader or Acrobat API - VBA PDF Automation-11 

You are so welcome!

Glad you liked it!

You're welcome.

Glad to help

Thanks, will do!

Glad it was helpful!

Glad you like them!

You're very welcome!

Thanks for listening

You are so welcome

Glad you enjoyed it!

You're welcome

It's my pleasure

you're most welcome!

You're very welcome!

Glad to hear it help but I am not :)

You are most welcome

Glad it helped!

Most welcome. Thanks for watching

@@VBAA2Z Bro can you please tell, How can I print an Excel file using vba & selecting no. of copies using vba only ?

try something like this. Sheet1.PrintOut Copies:=10

thanks

thanks for the useful tip Kyle.

Sure, we've many topics to be covered in Office for .NET :)

Thank you! Cheers!

Obrigada. Vou tentar atualizar as legendas

Please check this video. I have used practical example with simple example to use array and dictionary. btw - array and dictionary are very simple to use in VBA. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-GVykRlxfzPI.html

@@VBAA2Z thank you so much......you have made a video to comparing sheet could you please elaborate that because I am new in vba array dictionary and collection

Sure will upload it to blog soon.

Please check vbaa2z.blogspot.com/

here is example of how to upload. to download you just need to reverse the source and destination path. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-LLxM7cekToU.html

@@VBAA2Z That right. Thank you. I am going to try it and after i will come back to you.

Correct, it does not work for all types of PDF. Some pdf created using Acrobat are not readable using Word App lib leaving us with Acrobat API which is cost involved but most reliable.

Hi Antonio, what is the exact error? it is possible your file path is not correct.

Sure it can it done. I'll try and cover this topic in future videos

I haven't tried. Try posting it to stackoverflow.com/

Yes, it should.

Happy to help. please check support.microsoft.com/en-us/office/enable-or-disable-macros-in-microsoft-365-files-12b036fd-d140-4e74-b45e-16fed1a7e5c6

Sure will upload it to blog soon.

Please check vbaa2z.blogspot.com/

@@VBAA2Z Thank you soo much..!! You are awesome !!

I'll try and demo in coming videos for now here is API ref. www.adobe.com/content/dam/acom/en/devnet/acrobat/pdfs/access_v9.pdf

Yes it should. Though I have not tried in all the versions.

@@VBAA2Z I did some research. OCR is available from version 2013. Thanks a lot Lung.

@@kamalam29 great, thanks Kamal

Hi Avinash - please check out this thread techcommunity.microsoft.com/t5/excel/microsoft-excel-is-waiting-for-another-application-to-complete/m-p/1388914

thanks Jim! much appreciated for feedback

try below and also check this video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uccdOWubLpg.html Set obj = ActiveDocument.InlineShapes(1) obj.OLEFormat.Activate obj.OLEFormat.Object.SaveAs "filename"

Hi Tobie, this could be due to multiple scenarios like memory not cleared properly, the library locked by other app. Try below settings and see if it helps. techcommunity.microsoft.com/t5/excel/no-links-vba-addons-but-microsoft-excel-waiting-for-another/m-p/331063 While the error message is always the same, there are actually a couple of pretty common scenarios that trigger this particular error in Microsoft Excel: DDE protocol is deactivated in Excel - This problem can occur because the DDE protocol (Dynamic Data Exchange) is deactivated in the Excel settings. Corrupt Office Installation - Some users have reported that the problem was resolved after reinstalling or repairing the entire Office installation. Adobe Acrobat PDFMaker add-in conflicts with Excel - There have been some reports from users who were able to fix the problem by disabling or uninstalling the PDFMaker plug-in. IE (Internet Explorer) process is interfering with the DDE - this usually occurs when the user tries to save a file in Microsoft Excel. In this case, the solution is to manually end the process. Examble for DDE protocol, a quick guide. Open Microsoft Excel and click on File. It doesn't matter whether you're opening a new workbook or a new document. Open Microsoft Excel and go to File On the File menu in the left pane, click Options. Go to File> Options From the Excel Options menu in the left menu, click the Advanced tab. Then move to the right pane and scroll down until you get to the General section. Make sure that the Ignore other applications using Dynamic Data Exchange (DDE) check box is cleared. Examble for Adobe Acrobat : In the COM Add-Ins box, either clear the check box for the Acrobat PDFMaker Office COM Add-in, or select it and click Remove to delete it completely. Examble for IE explorer: Press Ctrl + Shift + Esc to open Task Manager. Switch to the Processes tab in Task Manager and check whether an Internet Explorer process is currently active. If one is open, just right click on it and choose End Task to close it. End the Internet Explorer (IE) process Return to Excel and see if the "Microsoft is waiting for another application to complete an OLE action" error still occurs when you try to save the file. Wenn das alles nicht geholfen hat , dann hilft nur (maybe) die Unterdrückung von Excel Application Messaging mit VBA or turn off compatibility mode .

@@VBAA2Z I will explore more as some did not work but it may be that the pdf is in some sort of Acrobat Format or to big. I would also like to know how to change the code to get the heading or description just above a table if that is possible.

sure, happy to assist. feel free to send me your code to the email in video description.

Nevermind, found your other video where you explain it.

ok great! hope it helps

También debería funcionar en versiones anteriores de Office.

@@VBAA2Z la vez pasada estaba haciendo el logo en un video tuyo, pegué el código y no funcionó...

sale como que: el codigo debe actualizarse para usarse en sistemas de 64 bits

@@giancajaracadillo Por favor revise este enlace. Tenga en cuenta que algunos controles de formulario, como ListView, no funcionan para Excel de 64 bits. vbaa2z.blogspot.com/2020/04/compile-error-code-in-this-project-must.html

It is possible the header is snapshot and not text

@@VBAA2Z can you show me please how to write the code?

if snapshot we can't read data

In that case I guess you can extract all data to excel first and organize your table back. All the best! 3. Read all PDF Content using VBA ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uc6palG76Y8.html 4. Extract table from PDF using VBA ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uc6palG76Y8.html

@@VBAA2Z Thank you.. but i want to do the same without using Acrobat , am asking about making any changes in this code (code in this video) will help me????

vbaa2z.blogspot.com/

This program can work without PDF Reader / Acrobat.

Thank you, do you have a copy of the program so that I can try it out

Also is there a way we can run a vba in excel and have a text or sentence inserted in pdf?

@@vg6119 yes, from any office application like excel, word etc. you'll need PDF Acrobat for that but if this is the pdf you're creating you can easily convert excel / word doc to pdf check this video. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-v-uxpc86wrw.html

vbaa2z.blogspot.com/

Have you tried this? ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uc6palG76Y8.html

@@VBAA2Z I cannot see the reference used in video at my office laptop Excel.

This version uses Acrobat API, I'd recommend checking it from beginning.

@@VBAA2Z you are saying in the below video Acrobat API is used ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uc6palG76Y8.html

Yes, mostly.

snapshot doc cannot be read

May I know which line is causing this error?

You may have already figured it out. This happened to me when I typed wline.range.text in the for each loop Instead of wline = pg.range.text By mistake