logging

Hi all, I'm new to the forum and VBA, so thanks in advance for the help! This is what I'm trying to do 1) import data from a text file into a data pane that will feed into a dashboard, 2) search for keywords in the data to find cell references, and 3) copy this data into a new row of an...

Hi guys, If you guys could help me it would be great. so basically I have a spreadsheet of Daily SLA that needs # of Cases and Cases Processed added. I couldnt figure out and I have searched google and youtube. Column A just has the name of the Task (i.e. Logging voicemail SLA#1) because...

Need the following code to produce a txt. log on an error, but return the loop interger it was using when the error occured, then retunr to the loop. Sub email() Dim OutApp As Object, OutMail As Object Dim strbody As String Dim cell As Range Set cell = Range("J1") For i = 1 To cell.Value...

I have a piece of code (Which I got from this site) that tracks changes to cells within the worksheet. It works great except I'd like it to look a changes just within one column only, not the whole sheet. Anyone know of a way? Option Explicit Const intUsernameColumn = 1 Const intCellRefColumn...

Can you guys please help me with coming up with an Excel Form that captures logins and logouts with the following features: 1. To login and catch timestamp, the form will ask for a username and password (other stuff will also do, like just simply typing in employee ID, scanning QR code, etc.) 2...

Hi there, I currently have two excel workbooks. The first includes data on a worksheet. The second workbook I want it to update and log the data from the first workbook: So for example, I have a command button in the 2nd workbook and when pressed it searches for newly updated data from today...

Hi All, I am fresher to VBA.I need to track and store the data of the users who refresh my Excel Work books. These excel work books are typically connected to OLAP Cubes. I need to get the values - Username, Computer name , Date when refreshed/Accessed to be loaded into my SQL Server database...

Hey everyone, I am trying to build a log that will help my team do their jobs more efficiently. I've built a UserForm that correctly logs the information entered into it. I think I've come to my knowledge limit. What i need now, is when the user clicks "add" to submit the data, for excel to...

I have a spreadsheet that I am using for budgeting and I want to be able to track my savings by logging data from one cell. If cell A1 represented my savings I want that copied to B1 then the next day when A1 changes the new value would be copied to B2 and so on. Any way that I have tried so...