username

I have created a VBA code to auto fill username and password on the website. When I click the button, the Username and password get filled up automatically but it says please enter the mandatory field. Please help! Sub GST_Login() Dim IE As Object Dim objelement As Object Dim c As Integer Set...

I want to open a file on a network ... so for example: \\networkname\c$\ This networklocation is username and password protected. Then run a vb script Delete the file or replace it with a emtpy csv file. How can I open the file with a VB Script (with vb code for the username and password)?

Intent: Display the Message Only once AND only for John Doe When counter and username are used separately, works fine, but not for both ========================================================== Option Explicit Sub Macro5() Dim MsgCounterJul05 As Long 'a zero will be placed in e5 (aka...

Hi Friends, Well i appreciate your contribution and what you are giving to people, but im stuck in something about Excel. My problem run like this: After I have finished my work, i save it to my computer. And here is where my struggle begins! I want this doc excel file be accessed only from...

Hi, I have a Workbook that i would like to restrict access apart from certain users. I don't want it to ask for the username and password i would like to it auto detect the username of the person and if they are on the list allow access and if not it wont allow them in the document can anyone...

So essentially i have two workbooks. One looks something like this: <colgroup><col><col><col><col></colgroup><tbody> Username First name Last name Ticket number User1 Jim Bob User2 Bob Jimmy </tbody> And the other is very similar bar a few extra columns. I need to be able to pull the...

I have a workbook that I only want certain users to be able to open. I have a list of network usernames that should have access on a worksheet called "LISTS". The list of usernames is in column "M" (range M2:M159) that has a dataname of "usernames". How do I set up some VBA code to look at...

Hello All, i want to create a VBA code that can help in identifying if the username of the user is anything from (Susan, Alex, Amy, Christina) then only allow them access to print the file. if there is anything you can help me with then it would be great!

I have a macro that returns the user's name in this format:"Doe, John". What I want is to be formatted like:"John Doe". Here is the macro I am working with. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Dim ws As Worksheet Set ws = ActiveSheet With...

I have a macro that get me Date / time & the username's full name in this format "Doe, John". What I want is to just get the first name "John". Here is the macro I am using: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Dim ws As Worksheet Set ws = ActiveSheet...

Hi Guys A little stuck, I am trying to create a form that will ask for an authorisation code. When the code is correct it will send an email to distros but if it is incorrect it will close the form. The authorisation codes are variable based on the userid and is contained on Sheet5 column B...

Hi I'm having some trouble implementing row level security in a simple Power BI model. I'm using an SS Tabular cube for my data (Visual Studio 2010), and implementing the security in it via a Role. My model has a data table, which includes a User Name column, and a UserName table (with just a...

Have a login details on Sheet1 as follow Sheet1 <tbody> A B C D E F User Name password Anna 12565 Login James 65234 Jimmy Susan 65845 12356 Michael 33654 Jimmy 12356 Koda 88751 </tbody> I have the follow code at...

I have been working on a new quoting tool for my organization and I guess I did such a great job( in large part to this forum! Thank you to everyone!:):):):)) that the Engineers are worried that the sales people will create quotes without engineering overview and create some serious issues...

Hello Experts, Below is the link where i posting same thread. http://www.excelforum.com/excel-programming-vba-macros/1221852-filelist-from-website.html I have website where i always download the files. Right now i am doing it manually, Steps 1. enter website name 2. type Username & password...

Hi all, I'm very new to Excel VBA, and this is my first post - please be gentle :D What I'm trying to do is probably quite simple to you lot, but I can't seem to find the right combination of VBA and formula to get what I need done! I've been searching for hours. ex. I enter data in A1, and I...

I have a Workbook with about 90 sheets that will be used by different users at different times, I have created a Home Sheet and a Combobox that will allow user to jump to the sheet they select, I want to create a login form with Username and password for some sheets that only user with password...

I have, on a weekly basis, a workbook having 60+ worksheets with each sheet named page1, page2, etc. I am renaming each sheet with the following code based on the contents of cell C5 in each sheet. The contents of cell C5 is a user name which should not be duplicated or changed on the worksheet...

I have a workbook that multiple people have their own copy of that has their Windows Username at the end of the file name (e.x. Test jdoe). Right now any time somebody new needs to use the workbook I have to manually update a few lines of code with their username. Here is an example. Dim a As...

Hi, I am after abit of help which is above and beyond my excel skills. I have two spreadsheets lets say called "SheetA" and "SheetB" Sheet A needs to match the "username" in column B to the username in column B on the other sheet (Sheet B). If the usernames match then I need it to copy the...