Skip to main content

Posts

Showing posts with the label urls Computer Knowledge

VBA code to open 100 website from excel sheet in Google chrome

Imagine you have a list of website addresses (URLs) in an Excel sheet, and you want to open all of them one by one in Google Chrome. You can do this automatically using a special tool called VBA (Visual Basic for Applications) inside Excel. It's like giving Excel a set of instructions to follow. The provided code is like a set of instructions written in VBA language. It tells Excel to: 1. Get the path where Google Chrome is installed on your computer. 2. Open a new instance of Google Chrome. 3. Go through the list of websites (i.e 100 URLs) listed in the Excel sheet. 4. For each URL, tell Google Chrome to open it. 5. Once all websites are opened, show a message saying it's done. So, when you run this code in Excel, it will automatically open each website from your list in Google Chrome without you having to do it manually. Below is a sample VBA code that opens multiple websites in a column i.e 100 websites listed in an Excel sheet in Google Chrome: Sub OpenWebsitesInChrome()