Hi All,
Is there any other way to retrieve the Audit Logs?
The ones which are retrievd via the System-->Audit-->Audit Logs menus.
We wish to programmatically retrieve these logs....
Thanks
It's down to the write collection action. It naively transforms the content of the datatable (Collection) Show the entire code of the action you are using to write to excel
Can you show the code that is being called?
Second, you probably have some code that is running without referenced worksheets and that causes the issue.
If your code stages contain something like this "Workbooks(...).Worksheets(sheetname).Range(.......
Excel formatting is a FACADE. Unless setting the text format FIRST (before data is even entered into that cell by whoever) in Excel, and then capturing any trailing zeroes, Excel will always transfer the value to BP as a numerical. No trailing zeroes...
The GetLabel call results in a LabelInfo (COM)Object
In VBA this is an Object that will auto-resolve to a string(in fact the LabelId property of the LabelInfo Object)
Here you either try to explicitly call .ToString() on the end - if that does give ...
