Colo's Excel Junk Room

I got a mail asks how to delete empty modules. Operation CodeModule is not so difficult.

How to implement Properties, Methods and Events on a Class

IntroductionThe term Class Module may give you an impression that it must be difficult. There might still be many Excel users who have never used the Class Module as yet because general VBA program...

When you would like to COUNT filtered rows count, it seems the following code works.

Sometimes I'd like to print a PDF file of the Adobe Acrobat from Excel. At first, since I had no idea how to control Acrobat Reader from Excel, so I had used Internet Explorer as a relay object ins...

Basically, to share the files like in a LAN environment, you need a LAN network.However, when the distances between bases is away, it costs a huge for the installation of LAN net work. So generally...