Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-29-2017, 08:03 AM
jhwjr64 jhwjr64 is offline Trying to open a webpage, enter a Parcel Number and download a pdf to an Excel 2016 (MAC) spreadshe Mac OS X Trying to open a webpage, enter a Parcel Number and download a pdf to an Excel 2016 (MAC) spreadshe Office 2016
Novice
Trying to open a webpage, enter a Parcel Number and download a pdf to an Excel 2016 (MAC) spreadshe
 
Join Date: Mar 2017
Posts: 1
jhwjr64 is on a distinguished road
Default Trying to open a webpage, enter a Parcel Number and download a pdf to an Excel 2016 (MAC) spreadshe

I am trying to create a macro that automates the inport of a PDF file to an excel spread sheet. Below I have listed the steps that generates the final PDF file.

The pdf file is pathed as follows: Open Browser(safari) - Enter "http://www.hamiltoncountyauditor.org" - Select "Property Search" - Method of search (select "Parcel ID") - Enter Parcel ID (sample:100-0001-0301-00) - select "Property Report" - select "Generate Report". The last step generates a PDF file that I want to import into an Excel spreadsheet.



What would be the process of creating a Macro button that would automate this entire process?

I am using a Mac running macOS Sierra 10.12.4. Also using Excel 2016 for Mac.

Thank you in advance for your help.
Reply With Quote
Reply

Tags
data import, macro, vba

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Office 2016 - open Excel file in compatibility mode for Office 2013 or earlier wpryan Excel 0 02-21-2016 12:50 AM
Trying to open a webpage, enter a Parcel Number and download a pdf to an Excel 2016 (MAC) spreadshe enter a constant based on entered number So New2 This Word VBA 1 10-17-2014 05:29 AM
Trying to open a webpage, enter a Parcel Number and download a pdf to an Excel 2016 (MAC) spreadshe VBA code to read number of footnote and enter in text rekent Word VBA 2 05-13-2014 06:53 AM
Running Excel from a webpage jimbassett Excel 0 04-22-2014 02:11 PM
Trying to open a webpage, enter a Parcel Number and download a pdf to an Excel 2016 (MAC) spreadshe Enter Number on any sheet one time only. paulrm906 Excel 1 04-28-2006 07:35 AM

Other Forums: Access Forums

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


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft