[How To]Excel VBA count how many files in folders

[Review] Noblechair Icon Series for Ladies

I always heard people say about a good mattress and chair are important for your health and we should invest…

[How To] C# Excel interop – split data in Sheet1 into multiple sheets based on criteria

I have an excel with lists of data with different categories in same worksheet (as below) and would like to…

[How To] Excel VBA – Copy row to other worksheet (by criteria)

Sub CopyResult() Worksheets(“Result”).Cells.Clear Dim LastRow As Long, i As Long, ws2 As Worksheet With Worksheets(“Work1”) LastRow = .Range(“A” & .Rows.Count).End(xlUp).Row…

[How To] Crystal Report – Looping Parameter and export to individual PDF/Excel (C# ASP.net)

I am using Ms Access in this example, add crystalreportviewer control in your webpage. Create a Crystal report with parameter…

[How To] Crystal Report show blank in ASP.net (C#) in development.

Developer machine: After installation – from this Crystal Report for Visual Studio Look for file “aspnet_client/system_web/4_0_30319/crystalreportviewers13” after installation and copy…