Automation Error- The Server threw an exception

Kavy

Well-known Member
Joined
Jun 25, 2007
Messages
607
Hello,

I have some code which reads a pdf and traslates it for me into an access table. During my debugging process I kept getting this "Automation Error", which I assume was to memory leaks.

Now, I closed my leaks off after each sub runs. When I googled this error with pdfs, people having this problem generally have 5 or 6 pdfs open, I only have one.

This error generally occurs when the code is reading the second line of a new page in my pdf document.

It seems to be semi-random where the code stops when I hit debug, but it always stops on a pdf jso call.

All this syntax have been used in a similar manner to read another pdf, with mutiple pages, just for this specific type of pdf, i had to re-arrange some things - so this code is bulker and takes longer to run.

Does anyone have any ideas? thank you.
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
So it turns out my memory leaks are not actually closed off, i have set all object = nothing, but my pdf is still running in the background. I am currently trying to find a way to close this darn pdf, maybe this is the problem
 
Upvote 0

Forum statistics

Threads
1,214,614
Messages
6,120,525
Members
448,969
Latest member
mirek8991

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top