log file

I have an Excel Macro Template file on our Network for our Sales Team to use. I want to record the user name and time/date in a seperate user log file hidden from the user, so I can keep track and frequency of the file being used. This would be VBA Code as an on open-event or after open in my...

Log Files within an Workbook to track changesHi, I created a quotation template for a small business, I would like to create a log work sheet so that I can track or keep a count of all the quotes that was done. Eg. Lets say the Quote # is in Cell A1 and the Customer is stored in Cell B2 and the...

Hi all...I've been dipping in and out of this really useful forum to improve my Excel skills immensely...so thanks for the help. I am however struggling to solve what is probably a fairly straight forward bit of coding...something until last week I had no experience with. I have a regularly...

Hey everyone, first post here. I have a file that multiple users access on a shared network drive (sharepoint). I have this macro setup to update a .log file with the username and date/time when users open the file. Here's the logmessage code: Sub LogInfo(LogMessage As String) 'set path...

Is there any way of seeing a log of the processes (including macros and user actions) that happen or are actively running in an excel workbook? One of my macros is messing stuff up but I'm not sure which one or why...

:pray: I could really use some help here. I have a project that started off simple enough, and has now become a nightmare. I need to create a log file from an excel work book. I only need one cell (ending balance) to write to the log file each time the shift supervisor saves the workbook...