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
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 ...
@TomaszSadlon I quickly knocked up an action to use this property as it hadn't been in use for me before.
Works for me as simple as said above.
Take out any referencing in the Initialize page re office dlls and declare as Objects. Then you simply nee...
