Hello,
Due to changes we would like to make in our organization, we need to track how often each of our reports is used. We couldn't find any working solution, so we checked the documentation and discovered that the functionality we need can be performed using the GETTICKET() function, which, as I understood the documentation, creates a ticket every time a User opens a report?
So my question is how we can save this data to file i.e. txt or csv? I tried to write a simple VB code to save value from cell A1 - let's assume that function GETTICKET() is located there.
sub writeall()
My.Computer.FileSystem.WriteAllText("C: est.txt",Range("A1").Value(), True)
end sub
Our goal is to get data like this: username, opening date or date+time, report name (not mandatory, we can just name this file with report name) but for now the first milestone would be to "physically" get this file and check how it performs on production.
Unfortunately it throws an error when I run the script and I dont know why. Instead of Range(..) i tried plain text cause I thought I messed something up but it didnt change anything.
Compilation error.
Error description: Cannot use parentheses when calling a Sub
Thank you in advance for your help.