Vba log file

[MetLife]

Hi,

Is there a log file available in VBA? I could put the log in the worksheet but wanted to know if there were other options.

Thanks

 

[Trevor_S]

I'm not sure if this is what you're trying to achieve - but you can get VBA to write to a file as the code progresses. Here is a very basic example which creates a file called LogFile.txt and logs the user's input. In theory you could write anything known by the macro to it:

<code>
'Open (create) the file you want to write to, near start of macro
Open "C:/LogFile.txt" For Append As #1 

'Ask user to enter some text so we can log what they input
ReplyToLog = InputBox("Enter some text")

'Create Log entry with timestamp
MyLogEntry = Format(Now, "dd/mm/yyyy hh:mm:ss") & " - User input: " & ReplyToLog
Print #1 , MyLogEntry

'Repeat the above for as many logs as you need

'Close the log file near the end of the macro
Close #1

This example adds entries to the end of the existing log file. If you want to create a new log file (overwriting the previous) each time, change Append to Output.

You must close the file in the macro. I usually also create a separate macro just containing the

Close #1

line, which I can use during testing if the main macro crashes whilst the file is still open.</code>

 

[Logit]

.
What are you wanting to log ?

Will the user be inputting the data or is the log capturing what the user is doing without his/her knowledge ?

Please be more descriptive.

 

[MetLife]

.
What are you wanting to log ?

Will the user be inputting the data or is the log capturing what the user is doing without his/her knowledge ?

Please be more descriptive.

Its a log file for a software program.

The log describes things that happen, like errors or reading files. Its the same type of logs you see in other systems.

 

[MetLife]

Thanks I think this is exactly what I was looking for.

 

[Logit]

.
This may be more indepth than you were seeking but ....

https://forums.windowssecrets.com/s...-to-create-log-file-when-runtime-error-occurs