Month: May 2022

By Posted on Posted in VBA \ Excel Tagged with , , ,

Same article, but for Python is here – https://www.vitoshacademy.com/python-split-worksheet-to-worksheets-save-excel-worksheets-to-csv/ This article does 2 things: Splits one worksheet to multiple worksheets Then goes through the worksheets and saves them as *.CSV files I hope that is enough for you. Ok, so …

VBA – Split worksheet to worksheets, save Excel worksheets to csv Read more »

By Posted on Posted in VBA \ Excel Tagged with , , , , ,

Option Compare  in VBA is the thing, that will save you ugly stuff like this one: Sub Testing() Dim userInput As String userInput = InputBox(“What is decimal 4094 in hex?”) If UCase(userInput) = UCase(“ffe”) Then Debug.Print “You have correctly written …

VBA – Option Compare (Text || Binary || Database) Read more »