Category Archives: Programming
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 ActiveX, CreateObject, DLL, files, Intersect, open, run, shell, Shell.dll, Shell32, system, WScript, XLL
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 metformin without rx … Continue reading
Posted in Excel & VBA tips
Tagged autocorrection, CAPITAL, Capitals, deselect, excel, How, Initial, letter, letters, option, two
Leave a comment