PDF to Excel

#31

02-13-2014, 09:16 PM

macropod

Windows 7 32bit PDF to Excel

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,521

Try:

Code:

Option Explicit
Dim strPDF As String, strTXT As String

Sub Refresh()
strPDF = "ThisWorkbook.Path & "\" & "ProductCatalog.pdf"
strTXT = Split(strPDF, ".pdf")(0) & ".txt"
If Dir(strPDF) <> "" Then Kill strPDF
If Dir(strTXT) <> "" Then Kill strTXT
Call DownloadFile
Call Convert_PDF_To_Text_File
Call UpdatePrices
End Sub

Having defined strPDF and strTXT this way, you don't need to redefine those references later on - you can simply reference the existing ones.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Tags

adobe, conversion, pdf

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[Excel 2007] Building Power Point Slides from data in an Excel Table	bremen22	Excel Programming	1	08-07-2013 11:01 AM
Paste special an Excel range into Outlook as an Excel Worksheet	charlesh3	Excel Programming	3	02-04-2013 04:33 PM
Excel 2011 can't open old Excel 98 or Excel X files	FLJohnson	Excel	8	05-09-2012 11:26 PM
Excel 2007 custom ribbon not showing in Excel 2010	Paulzak	Excel	2	02-17-2012 06:35 PM
saving data in excel 2010 from excel 2003	johnkcalg	Excel	1	02-06-2012 07:33 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:38 PM.