Surface Pro (2017) vs Surface Pro 4
I regularly get a list of information sent to me in Excel format which I cut and past into a master list.
The sender has now seen fit to send this info as a pdf file.
Is there any way of being able to cut and past or whatever from the pdf list to excel whether it be directly or into word and then excel etc.
It would be great if I could.
That was quick. I only posted a few minutes ago.
I thought someone might suggest that. So! buying an expensive piece of software is the only way is it?
Pain in the but but if that is the only way, I guess I will have to go down that road.
Thanks for you help.
Explain the situation to the sender and ask them to send in excel format again.
Can't you just copy and paste the data?
And who said anything about an expensive piece of software...looks like those links were to some free help on how to do it with acrobat (i.e. the thing you view pdfs in)!
"who said anything about an expensive piece of software"
Unfortunately they did
"What Software Do I Need to Convert a PDF Document into Another Format?
In order to export a PDF file into another application you will need Adobe Acrobat 5.0 installed on your workstation. This is not the same software as the Adobe Acrobat Reader. Adobe Acrobat 5.0 is a much larger software package that provides many functions unavailable in the Reader (e.g. converting virtually any document into PDF). Unlike the Reader, Adobe Acrobat 5.0 cannot be downloaded for free. "
Thanks for your input Belatucadrus and your to SANTOS7
It never ceases to amaze how some input to threads in this help forum seems to be of the frivolous nature(silverous and seedie)no names mentioned. Could certainly do without that sort of silly input.
Copy to Word click here as a Table.
Use this macro to import into an empty sheet in Excel.
Dim wdDoc As Object
Dim wdFileName As Variant
Dim TableNo As Integer 'table number in Word
Dim iRow As Long 'row index in Excel
Dim iCol As Integer 'column index in Excel
wdFileName = Application.GetOpenFilename("Word files (*.doc),*.doc", , _
"Browse for file containing table to be imported")
If wdFileName = False Then Exit Sub '(user cancelled import file browser)
Set wdDoc = GetObject(wdFileName) 'open Word file
TableNo = wdDoc.tables.Count
If TableNo = 0 Then
MsgBox "This document contains no tables", _
vbExclamation, "Import Word Table"
ElseIf TableNo > 1 Then
TableNo = InputBox("This Word document contains " & TableNo & " tables." & vbCrLf & _
"Enter table number of table to import", "Import Word Table", "1")
'copy cell contents from Word table cells to Excel cells
For iRow = 1 To .Rows.Count
For iCol = 1 To .Columns.Count
Cells(iRow, iCol) = WorksheetFunction.Clean(.cell(iRow, iCol).Range.Text)
Set wdDoc = Nothing
Incidentally, I think seedie's suggestion was the most sensible.
Osben, I've never seen such ingratitude before around here.
There was nothing frivolous about my comments, they were genuine. If you or belductrus had bothered to read or try you you would know that you can actually copy and paste the content of a PDF using the standard reader into another application. That is all I was suggesting and that is how I read the original link. Sorry if I missed something but I think you won't get much help if you start making snide digs at those who were trying to help you.
e.g. "Mentioning no names", then going on to do so
And to be honest, in seedie's defence, althouhg quite an abrupt post it is an idea. Sometimes people try to get around a problem when it is chaper and simpler to solve it another way, presumably the original send could actually send it in excel.
This thread is now locked and can not be replied to.