This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 82%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
I’m sure you will be able to tell fairly quickly, I do not have knowledge of scripting or macros. Here is what I am looking to do, and You can tell me if it’s possible.
There is a website that we search on a daily basis for towed cars. This process is time consuming, as it involves a lot of copying and pasting - takes about a hour to search 400+ License plate numbers. The base URL is constant, with the exception of the license plate number. Ie the base url is www.123.com, and when searching the license plate “amb625” the url becomes www.123.com/amb625.
Is there any way to make this more efficient through a macro or script in excel or access? A .csv file is where we keep track of these license plate numbers.
Any help would be great!
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
An implementation of Visual Basic that is built into Microsoft products.
Hi,
Your problem is related to the Office for developer, I added the office-vba-dev tag. The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.
Your request is possible. You can either embark on learning VBA, or you can hire an Office professional to program that utility for you. If you choose the learn VBA yourself, online searches are a great way to find VBA information.