The VBA MS Office Developers Journal The VBA MS Office Developers Journal The Client request: “Do you know much about inserting page numbers into Word docs? I have had a few requests for it; if it is easy enough I might do it. I tried the Page number but it messes up my formatting. Since […]
Excel Web Scraping Custom Function Builder
The clients request was simple I want to pull the following financial statistics from the Wall Street Journal and Market Watch:1) Name form Ticker Symbol2) Total Revenues3) Non Operating Interest Income4) Total liabilities He was nice enough to provided the URLS as follows: The Wall street Journalhttps://www.wsj.com/market-data/quotes/AAPL/financials/annual/balance-sheet Market Watchhttps://www.marketwatch.com/investing/stock/AAPL/financials/balance-sheet/quarter” I did the job and built […]