Every morning when I go to the office, the first thing I need to do is to create a pivot table for the month-to-date sales and present it to my boss. This includes the same steps, every day. But when I realized that I can use VBA to create a pivot table and insert it in a ...
"CVDate found, use CDate" finds the old Variant function CVDate. Watch for risky VB.NET syntax "Type inference used" finds where the potentially dangerous Option Infer On is in use. "Optional parameter in exposed procedure" verifies cross-language interoperability. "File with several classes or...
In order to remove the comments, the user needs to know the password to unlock the worksheet. Give it a try, think this can work around your problem of deleting silent comments. Password is "1234" can be changed arbitrarily in the VBA code. The VBA project with password w...
@ExecutionTime date format on email subject? #Error in SSRS Expression #Error using IIF and divide by zero #error when trying to sum a calculated field in ssrs text box <rd:DataSourceID>WHAT IS THIS NUMBER</rd:DataSourceID> =Globals.PageNumber & " of " & Globals.TotalPages =IIF( ...
@ExecutionTime date format on email subject? #Error in SSRS Expression #Error using IIF and divide by zero #error when trying to sum a calculated field in ssrs text box <rd:DataSourceID>WHAT IS THIS NUMBER</rd:DataSourceID> =Globals.PageNumber & " of " & Globals.TotalPages =IIF( St...
@ExecutionTime date format on email subject? #Error in SSRS Expression #Error using IIF and divide by zero #error when trying to sum a calculated field in ssrs text box <rd:DataSourceID>WHAT IS THIS NUMBER</rd:DataSourceID> =Globals.PageNumber & " of " & Globals.TotalPages =IIF( Sta...