Google Maps in Excel ➜ Demo Workbook
HTML-код
- Опубликовано: 19 окт 2024
- // Recommended Excel Courses //
1. Launch Excel Macros & VBA School: go.launchexcel...
2. Excel Campus Elevate Program: go.launchexcel...
3. My Online Training Hub Dashboards: go.launchexcel...
4. Coursera Excel Specialisation: go.launchexcel...
5. Coursera Everyday Excel: go.launchexcel...
6. Coursera Excel Data Visualisation: go.launchexcel...
// Recommended Excel Templates //
If you are looking for pre-built, easy to use spreadsheets, check out Simple Sheets.
go.launchexcel...
They have Excel templates covering cash flow planning, invoices, expense reports, personal budgets, and more!
// Show Notes //
Download sample workbook to follow along at: spreadsheet1.co...
In this 5 minute video we check out a cool little demo spreadsheet that takes a Point of Interest and creates a panorama of that location by pulling together four Google StreetView images. It also shows the location on two Static Maps (Road and Satellite).
The demo spreadsheet uses VBA (Visual Basic for Applications) to fetch images from the Google Maps database of images using URLs generated from the selected Point of Interest.
You can read more about the spreadsheet and VBA at www.launchexcel.com
www.launchexcel...
Video Highlights:
0:28 Launch application from Custom Ribbon Tab "Map Panorama"
1:20 Point of Interest: Buckingham Palace
2:12 Visual representation of what the application does
2:40 VBA Sub StreetViewPanarama(...)
3:52 VBA Sub GoogleStaticMap(...)
Image Credits in Video:
King's College Cambridge by Sarah under the Creative Commons License Attribution 2.0 Generic (CC BY 2.0) www.flickr.com/...
Buckingham Palace by Peter Robers under the Creative Commons Attribution 2.0 Generic (CC BY 2.0)
www.flickr.com/...
do you have an Intro to Excel VBA video?
Hi. I need a way for Google Maps to capture my location automatically (without my having to enter my address). Is this possible through VBA?