UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Open Pdf File In Excel Via Macro ?, Office 2013    
 
   
bakersburg9
post Jul 19 2019, 10:15 AM
Post#1



Posts: 5,519
Joined: 2-November 04
From: Downey, CA


I have to open a bazillion .pdfs in Excel - is this possible using a VBA macro ?

Thanks in advance,

Steve
Go to the top of the page
 
GroverParkGeorge
post Jul 19 2019, 11:40 AM
Post#2


UA Admin
Posts: 35,519
Joined: 20-June 02
From: Newcastle, WA


Simultaneously or sequentially? You may not have enough RAM to open that many pdfs all at once....

Seriously, are you planning to put the pdfs in Excel? Or just open them in the Acrobat Reader from Excel?

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
bakersburg9
post Jul 19 2019, 11:42 AM
Post#3



Posts: 5,519
Joined: 2-November 04
From: Downey, CA


George,
Doing them one at a time is fine, and opening them in the Acrobat Reader from Excel is fine, too - as you can tell, this is new territory for me - thanks so much for chiming in!

Update: Just tried opening a .pdf in Excel, and it was all gobbly-gook, with the funny characters - ugh if no one knows a way, maybe i could go for the free trial of .pdf conversion to Excel tool, or maybe there's an IT guru at the company I'm working for that can help me out....
This post has been edited by bakersburg9: Jul 19 2019, 11:49 AM
Go to the top of the page
 
GroverParkGeorge
post Jul 19 2019, 12:22 PM
Post#4


UA Admin
Posts: 35,519
Joined: 20-June 02
From: Newcastle, WA


Okay, so I think that's the way it would go, but I wanted to be sure.

Excel doesn't have the ability to open non-Excel files natively.

You can use Shell to open the PDF reader (Acrobat) with the name of the pdf file passed to it.


--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
bakersburg9
post Jul 19 2019, 12:42 PM
Post#5



Posts: 5,519
Joined: 2-November 04
From: Downey, CA


QUOTE
You can use Shell to open the PDF reader (Acrobat) with the name of the pdf file passed to it.
sorry, above my pay grade - you mean like what they used to call a DOS command ? or script ? I would have no idea how to accomplish that - aren't there applications I could buy (or get a free trial) to convert .pdf to Excel ?
Go to the top of the page
 
bakersburg9
post Jul 19 2019, 12:56 PM
Post#6



Posts: 5,519
Joined: 2-November 04
From: Downey, CA


George,
QUOTE
use Shell to open the PDF reader (Acrobat) with the name of the pdf file passed to it.


What is being accomplished by doing that ?

well, update : SOME good news - I found a YT video that's like a MINUTE, that shows how to save a .pdf as an excel file - I would love to automate the process, but I'm thrilled to death that I can at least save these 160 .pdfs as excel files

the key is you open it / save As "Other" / Spreadsheet / Microsoft Excel ... then rename it, and bada-bing, bada-boom, you are done - I wish I had the add in I had used at the last company I worked at to combine all the excel files.... cryhard.gif

But at least I figured it out, the conversion part - thank god for YouTube !!!

Steve

(and thanks again for chiming in) cool.gif
Go to the top of the page
 
GroverParkGeorge
post Jul 19 2019, 01:07 PM
Post#7


UA Admin
Posts: 35,519
Joined: 20-June 02
From: Newcastle, WA


Q: "What is being accomplished by doing that ?"



A: '...and opening them in the Acrobat Reader from Excel is fine, too ..."

In Excel, can't you record a macro using the manual conversion steps and then edit that macro?

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
GroverParkGeorge
post Jul 19 2019, 01:12 PM
Post#8


UA Admin
Posts: 35,519
Joined: 20-June 02
From: Newcastle, WA


Or are you talking about opening the pdf using Acrobat Reader and then saving that as an Excel file?

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
bakersburg9
post Jul 19 2019, 01:19 PM
Post#9



Posts: 5,519
Joined: 2-November 04
From: Downey, CA


QUOTE
In Excel, can't you record a macro using the manual conversion steps and then edit that macro?
No, I get the gobbly-gook right from jump

the procedure that works, yes, like you said, is opening the pdf in Adobe acrobat XI Pro, then save as Other / Spreadsheet / Microsoft Excel workbook
This post has been edited by bakersburg9: Jul 19 2019, 01:19 PM
Attached File(s)
Attached File  SavePDFasExcelGIF.gif ( 118.77K )Number of downloads: 3
 
Go to the top of the page
 
GroverParkGeorge
post Jul 19 2019, 02:27 PM
Post#10


UA Admin
Posts: 35,519
Joined: 20-June 02
From: Newcastle, WA


So you need to automate ACROBAT from within Excel, it would seem.

Not something I have experience doing. sorry.

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
bakersburg9
post Jul 19 2019, 03:08 PM
Post#11



Posts: 5,519
Joined: 2-November 04
From: Downey, CA


thanks - I found THIS do you think I'm barking up the right tree with this ?
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    22nd August 2019 - 09:35 AM