Category Archives: Programming

How to create a list of files and Folders with VBA

In this article is explained how to create a list of files/folder in order to print out them. The “object” FileDialog is used for this scope. It allows to select a directory, files in the folder, open and save files. … Continue reading

Posted in Excel & VBA tips | Tagged , , , , , , , , , , , | Leave a comment

How to use the System Shell to open files

It is possible by means the Run method associated with the CreateObject function. – The Run method runs a macro or call a function. It can be used to execute a macro written in Visual Basic or the Microsoft Excel … Continue reading

Posted in Excel & VBA tips | Tagged , , , , , , , , , , , , | Leave a comment

Excel – How to deselect the autocorrection option of Two-Initial Capital letters

To avoid Excel automatic corrections (e.g. MPa, with “p” that switch to be lowercase giving Mpa) that can be annoying, it is enough to do as follows: Office button → Excel Option → Proofing → AutoCorrect Options → check off “Correct TWo INitial CApitals” … Continue reading

Posted in Excel & VBA tips | Tagged , , , , , , , , , , | Leave a comment