tag:blogger.com,1999:blog-628403773198516684.post6892503148534001370..comments2022-04-12T09:13:07.989-07:00Comments on VBA Macros Code examples: Import a PDF in ExcelUnknownnoreply@blogger.comBlogger15125tag:blogger.com,1999:blog-628403773198516684.post-15982317548298246072022-04-12T09:13:07.989-07:002022-04-12T09:13:07.989-07:00Error Code 53 file not found.
Error Code 53 file not found. <br />d1g1t4Lnrghttps://www.blogger.com/profile/13951225148775391559noreply@blogger.comtag:blogger.com,1999:blog-628403773198516684.post-33616285469671683162019-10-06T15:13:59.933-07:002019-10-06T15:13:59.933-07:00I also have a problem with#varRetVal = Shell (strD...I also have a problem with#varRetVal = Shell (strDoIt, 1)please help me, if there is another vba code that can fix it, and the pdf file doesn't appear in the search when I run the codehuda novalhttps://www.blogger.com/profile/16347551428192459287noreply@blogger.comtag:blogger.com,1999:blog-628403773198516684.post-59112201861963410392018-06-28T03:23:52.534-07:002018-06-28T03:23:52.534-07:00I need to copy some specified lines from pdf to ex...I need to copy some specified lines from pdf to excel ,how can it be done can u please give me an ideaAnonymoushttps://www.blogger.com/profile/16133961995444730935noreply@blogger.comtag:blogger.com,1999:blog-628403773198516684.post-14388481830248212342018-05-03T01:06:17.852-07:002018-05-03T01:06:17.852-07:00i have a doubt..in which path the converted excel ...i have a doubt..in which path the converted excel file is getting saved?Anonymoushttps://www.blogger.com/profile/06171915926741866859noreply@blogger.comtag:blogger.com,1999:blog-628403773198516684.post-33285962562683628202017-07-22T04:30:02.379-07:002017-07-22T04:30:02.379-07:00The error is due to the delay in executing the exe...The error is due to the delay in executing the exe file. Try holding the code for few seconds. It might help.<br /><br /><br />'HERE YOU SET UP THE SHELL COMMAND<br />strDoIt = "C:\Program Files (x86)\Adobe\Reader 11.0\Reader\AcroRd32.exe " & strFullyPathedFileName<br /><br />'The Shell command<br />varRetVal = Shell(strDoIt, 1)<br />Application.Wait Now + TimeValue("00:00:20")<br /><br /><br />'Clear CutCopyMode<br />Application.CutCopyMode = False<br />Application.Wait Now + TimeValue("00:00:03")<br />AppActivate varRetValMurali Mohanhttps://www.blogger.com/profile/07166405620292885503noreply@blogger.comtag:blogger.com,1999:blog-628403773198516684.post-65626738682662460882015-09-05T03:08:53.703-07:002015-09-05T03:08:53.703-07:00I got error
Can you send a fileI got error<br />Can you send a fileAnonymoushttps://www.blogger.com/profile/04296845925942696727noreply@blogger.comtag:blogger.com,1999:blog-628403773198516684.post-4158324276591571522013-06-25T13:18:12.426-07:002013-06-25T13:18:12.426-07:00I got error 1004, application or object defined er...I got error 1004, application or object defined errorAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-628403773198516684.post-77740122836330028032013-05-21T06:54:05.732-07:002013-05-21T06:54:05.732-07:00I thank you a lot, it works perfectly
A French de...I thank you a lot, it works perfectly<br /><br />A French developerbayzfinancehttps://www.blogger.com/profile/14423640215468716369noreply@blogger.comtag:blogger.com,1999:blog-628403773198516684.post-36672932251740043142013-05-21T06:53:15.107-07:002013-05-21T06:53:15.107-07:00This comment has been removed by the author.bayzfinancehttps://www.blogger.com/profile/14423640215468716369noreply@blogger.comtag:blogger.com,1999:blog-628403773198516684.post-39505354661196387232013-03-25T02:49:42.056-07:002013-03-25T02:49:42.056-07:00Hi,
I have the same problem as Marcos,
AppActiva...Hi,<br /><br />I have the same problem as Marcos,<br /><br />AppActivate varRetVal<br />Send an error #5<br /><br />Could you help me out?<br /><br />Thank you in advanced.bcanalshttps://www.blogger.com/profile/08705638147271720201noreply@blogger.comtag:blogger.com,1999:blog-628403773198516684.post-22542183337262252272013-02-15T22:32:17.285-08:002013-02-15T22:32:17.285-08:00I think if you add the acrobat library in your ref...I think if you add the acrobat library in your references, you can declare a variable for the pdf file type and get some some help. I think you can then use some search to locate the text you want. I suppose you could search for the next space and select the string of characters, copy, and paste into excel. Have you resolved this yet?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-628403773198516684.post-34575012027361094912012-12-06T17:14:59.600-08:002012-12-06T17:14:59.600-08:00Thanks so much for this code. This is very helpful...Thanks so much for this code. This is very helpful! Sarahhttps://www.blogger.com/profile/03768557124328797910noreply@blogger.comtag:blogger.com,1999:blog-628403773198516684.post-8737950248483567522012-01-12T07:23:22.009-08:002012-01-12T07:23:22.009-08:00my company have a legal notice template..they merg...my company have a legal notice template..they merged it and fwd us 27000 notices in pdf files..<br /><br />there is a sentence <br />Contract no. xxxxxxx in every notices...i want that contract no. into excel...automatically A macro batch somethingEXCEL SYEDhttps://www.blogger.com/profile/07068524114190327932noreply@blogger.comtag:blogger.com,1999:blog-628403773198516684.post-17832458470310422212011-11-04T08:44:03.728-07:002011-11-04T08:44:03.728-07:00As I am not an expert, your work is very useful fo...As I am not an expert, your work is very useful for me.<br />I have a problem with this instruction: <br />AppActivate varRetVal<br />Send an error #5<br />Can you help me? <br />Thanks<br /><br />Marcos (Santiago, Chile)Marcoshttps://www.blogger.com/profile/06844702987441395665noreply@blogger.comtag:blogger.com,1999:blog-628403773198516684.post-42099596726548494842011-05-04T08:19:32.937-07:002011-05-04T08:19:32.937-07:00Hey, I didn´t know how to do this. It is a good th...Hey, I didn´t know how to do this. It is a good thing to know because several times I nedeed the PDF to be imported to the Excel sheet and I didn´t know how to do it. Especially now, that I´m in Argentina, I rented one of those <a href="http://www.4rentargentina.com" title=" buenos aires apartments" rel="nofollow"> buenos aires apartments</a> and the rental company gave me a PDF about Argentina and its attractions and i wanted to have it in excel to see in items what I want to do.<br />Thank you!<br />KimKimberlyhttps://www.blogger.com/profile/08963795292115505034noreply@blogger.com