Search results
14 kwi 2010 · Analyze the HTML code on the login page and use the Form Action URL and the username and password "name"s or "id"s in the "IE.Navigate" line, instead of trying to fill in the blanks in the IE window with SendKey.
- VBA Macro Optimization
Hi Everyone , I'm new to macros etc , I have did the code...
- SamTYler
SamTYler - VBA to open website and logon with username &...
- VBA Macro Optimization
28 wrz 2023 · Head to the Data tab in Excel. 2. Click Get Data and choose From Web. 3. In the From Web dialog box, type in the website's URL and click OK. 4. A browser window will pop up within Excel, showing the webpage. 5. If the webpage requires login credentials, fill in your UPN (User Principal Name) and Password in the designated fields. 6.
11 sty 2010 · Is there a way to use a hyperlink to a website in VBA which will pass the username and password required by the website? The URL I am using is going to a secure site, which requires a username and password, to download a csv file.
14 wrz 2023 · if you want to create an external link that opens your Excel workbook directly on a specific sheet (tab), you can try this: 1. Save Your Excel Workbook: - ensure that your Excel workbook is saved in a location which is accessible to your team (for example SharePoint or Onedrive) 2. Share the Workbook:
16 cze 2021 · It works when the username and password are correct. When username or password are not correct (not a match to list on sheet "users") I want label8 to print "insert username and Password" and not give access to userform1.
Step 1: Setting a Password to Open an Excel File. Open the Excel file you want to protect. Go to File > Info. Select 'Protect Workbook' > Encrypt with Password. Enter a Password in the dialog box. Click OK. Re-enter the password to confirm it. Click OK. Save the workbook to apply the password protection.
You can add a password to an Excel file to prevent unauthorized users from opening or modifying it.