login

Hello, I want to have a macro that notes time of login and shut down in computer in excel sheet automatically without opening it. I have a common share drive for my team where I will place this macro enabled excel file. The excel file should record time for all the persons have access to that...

Hi, I have the array formula which gives the 1st entry with respect to date and emp name 1st Entry = {=1/MAX((D4=Raw!$M$2:$M$21063)*(Raw!$B$2:$B$21063<>0)*(1/Raw!$B$2:$B$21063))} Array last entry = {=MAX((Raw!$M$2:$M$21063=D4)*(Raw!$B$2:$B$21063))} Array <tbody> Jojo Kurien...

Please go through this query, its quit long, but challenging I wanted a macro to login to a intranet site using my user name and password. I used early binding techniques and created new instance of IE. The code enters my user name and password in appropriate fields. However the login button did...

Hai, Just want to understand, when we publish power bi (using bi desktop) report, my question: 1. Any can see the report or only the person login the same account 2. How secure the report from hack from other parties Thank you

Hello, I have a very large workbook with approximately 560 worksheets. When the workbook opens, I have a login userform that pops up where the user will enter their username and password. That login info is used to determine which sheets in the workbook can be accessed. All the sheets in the...

Hi all! I'm fairly decent at Excel, but absolutely no idea when it comes to VBA. I'm trying to get Excel to go to a website, fill in login details, then navigate to another website, select a table, and copy and paste it into Excel. I've looked all over the net and found this little bit of code...

Good morning all, I found a lovely little piece of code that converts a worksheet to a PDF and emails to outlook and works perfectly for me, however the code is unique to my login identifier within the company I work for: Sub SendSheetAsPDF() Dim olApp As Object Path =...

​Morning guys, I have looked through this and other forums but no code seems to be working for my website and keeps giving errors i am unsure of. Simply put i am trying to complete a web query to pull data from a table, this information is behind a login page for both username and password. I...

Logon to website using VBA Hey all, Trying to log in to a website with VBA & download a file. Having troubles getting the code to login. I’ve pulled up what the element is in IE but the code doesn’t seem to recognise it and no username or password gets put in at all. Code is below, in...

I'll try to explain this the best I can. I'm looking to build a Macro that I can use to hyperlink a specific set of numbers to open a website that will access the information based on those numbers. the problem is that the website opens a collection of boxes and I only need the numbers to go...

I found the code below on this forum however I have a slight problem. The code works great and logs me into the website. However when I navigate to the page I want to copy into excel it gives me the error that I'm not logged in. I am guessing that it is not saving the cookies or the navigate...

Hello, For the last several months I have been developing an application for my company to record injures at our various facilities. Since this workbook will eventually be shared on network drive, I have included in this workbook is the login page. I have created this since multiple users will...

Hello, Eventhough I've used a lot of the answers posted on these forums, I've never posted before. I want to thank you for the times this site provided me with an answer. #TL;DR [intro - begin] I am trying to be innovative at my work however our IT department is not really supportive...

I've literally run out of things to try. I have cubes deployed to an SSAS Tabular instance. They have Dynamic Roles set up to limit data to only data they should have access to. This Role has Everyone assigned to it. It seems to be functioning fine for everyone at the company so far except 1...

I am having problems with this code which extracts solar data from a public website that requires a registration and login. The situation is as follows: 1. The code navigates to the website successfully, enters the usercode and password, and logs in. Logging in results in a total change...

Hello, I use macro excel to take some files from the a secured network and fill a specific directory. When I use IExplorer I have access and the network drive is mounted, I can manage the files, make a copy, create folders .... With the macro I have access on some folders but some of they I...

Hello all, I have read a number of posts related to this topic, tried a number of different methods and still can't get it to work. The page opens properly and blocks the popups but I get a '438' error - "Object doesn't support this property or method" when it gets to the .GetElements . . . I...

I want to login to the IBM ISM web page using VBA- this is done while at work. The code below works with some pages but throws an error with this webpage. I get an error on the MyBrowser.Visible = True statement. Is it because it's a Javascript webpage? And if so, is there a way around it...

Example: I have the list of the url in a column. https://tools.xxx.com/xxx/publh/doc/DocRet?NO=60-8&Rev=&RCN=&Org_Id=1&OrgID=1 https://tools.xxx.com/xxx/publh/doc/DocRet?NO=60-1&Rev=&RCN=&Org_Id=1&OrgID=1 https://tools.xxx.com/xxx/publh/doc/DocRet?NO=60-2&Rev=&RCN=&Org_Id=1&OrgID=1 1. I have...

I am creating a spreadsheet containing sensitive financial reports that I want to selectively present only to those users who are authorised to view specific reports. I created a "Welcome" page which has a drop down list of internal users to select from. Once the name has been selected (cell...