log

Good day, I have been working to simplify a log that is used by a lot of people I work with. I originally built it years ago with helper columns and need to get rid of them. I have 2 items I need to solve but will post the second one in a different post. Item 1: I have a massive log, column B...

Hi all. A col has Dates in them this sheet is called "Log" Col A Col B Col C Wed, 19 Jun 19 5:30 6:40 Fri, 21 Jun 19 1:49 1:23 Fri, 21 Jun 19 1:11 Fri, 21 Jun 19 1:33 3:12 I have another sheet that has dates for JUNE sheet name...

I have spreadsheet with the following columns: 1. Vendor name 2.website link 3.user 4.password How to write a vba code to log in website and get user/password from cells. Any sample Please. Thank you

Hi, I have a document of someone else's that I check daily and it was made aware to me that the individual whose document it is, knew that I was doing this. And I wasn't sure how this was possible. As far as I know, there's no way to log when an Excel or Microsoft document has been opened...

Hello, I am very new at writing vba. I copied a code that takes information entered from one workbook by hitting the submit button it then takes my data, opens the master log, transfers the data onto the worksheet horizontally, saves and closes both workbooks. example below of code being used...

I want to save certain sheets as a PDF file with a specific path, have a default file name with the option to edit the file name which also opens the PDF file. Seems to work with desired path and option to change default file name, but the PDF file is never saved and the code continues to the...

Hello all! Have been a lurker for sometime and have found an incredible amount of useful threads here! However I can't seem to find anything that may help me with a notepad to excel macro ( I know theres a few but can't seem to get them to work :( ) So what I am trying to do is pull out Time...

Hi All, any help on this would be greatly appreciated. The data below refers to a Used car stocklist advertising changes. Each line represents a log of a price change on the internet. I need the following data retrieved from this list. 1 - Total number of internet changes for each car 2 - The...

Hi The below runs with a Workbook Open event to allow VBA to modify a protected sheet without unprotecting the sheet: Private Sub Workbook_Open() With ThisWorkbook Call UnprotectWorksheet(wks:=.Sheets("Training Log")) Call ProtectWorksheet(wks:=.Sheets("Training Log")) End With I...

Hi I am looking for a custom search macro that does the following: I enter a date into a custom search box then click search. Then whichever sheet I am in, the query then only searches Sheet 1 ("Training Log") and makes column H of the row containing that date the active cell. Hope you can...

Hi I have the following code: If ActiveSheet.Name <> "Training Log" Then Exit Sub I'm trying to amend this so that the code will also run if the active sheet is called "Analysis" (without the commas) I've tried If ActiveSheet.Name <> "Training Log" or "Analysis" Then Exit Sub but this errors...

I'm looking for a formula that lets me input a value, and the output would be a list of whatever sheets in the workbook that value appears on. I don't have the slightest idea in this case, or know if it's even possible. It can't be VBA because our work computers can't all handle it. Longer...

Hi Community, I have a VBA macro for a log record that copies information from a submission form and pastes it in a Log Record data file based on a IF condition. THe condition is partially working where if the condition is true then the data is copied to the log record, But when i try and...

Hello to all, We have a workseet that is filled by multiple users. Once 8 cells are filled out the user clicks on a submit button. An oder entry Log is opened and the data from the 8 cells from the worksheet are placed onto the next open line on the log. should not matter in this scenario...

I am attempting to log into a website in efforts to pull data. The Code I have pasted below, does not work for my application. If I am to change the website to gmail it will run without error. This code will open the log in page, and then errors out at: "Loop Unti oBrowser.readyState =...

Hi All In my head I thought this would be pretty straight forward, but it quickly became apparent that it's not! What i have is a very big accident log, each row represents a accident entry and has a vast amount of information where i would like to extract certain information into a separate...

Hi all. Our company have domain email and using this email log in to computer like: email: jhonny@abc.com, Jim@abc.com ... user only log in computer with ID: jhonny, Jim... Now I have excel file and want only user log in ID with "@abc.com" can open this file. How can I do this by VBA code...

Hi all, Im trying to figure out the best way to do this and hoping someone could point me in the right direction. Sheet1 - Employees data Sheet2 - Log Sheet2 - Log - Column A is for the employee number. When the user inputs the employee number it pulls through the employee details from the...

Hello I'd like to be able to clear all data validation (including validation comments) from a single selected cell - only in a sheet called Training Log and - only when I click on an assigned button, preceded by a "Are you sure?" Yes/Cancel msgbox. I tried the following code for the deletion...

All a google search turned up was code that I could put into a macro that will essentially save a log of when it runs, but seems to only be forward-looking. I.e. will keep a log of all times that macro runs going forward, but I'm trying to clean up my Modules and want to get rid of all the...