Good Tips '489 ! Writing add-ins seems to be the only way to automate Office 365. It is becoming the corporate office platform in a lot of places so indeed MS has done a Ripley on us corporate software developers. If you do have to work in VBA -there are many toolsets to help write and maintain good code - MZ tools is my preference but Rubberduck · GitHub[^] looks good too. Its an old but stable IDE -little Intellisense, no autocompletion - but that only helps the coding - not the thinking! Export all your code modules, forms, spreadsheet content, formulae, formats to text files. Then you can do version control in mercurial, and inspection in Npp Merging is an issue but you can see what changed and revert or branch.
Member 12364390
Posts
-
VBA in Excel -
Corrupting MP3s....TS transport stream video is the format used by my digital TV in the UK when it records DVB programmes in SD to USB thumb drive in real time, I also have a Grundig box that does the same thing. I am guessing that this is the video format inside the DVB digital video broadcast signal. No problem playing this back on TV,Mac or PC using VLC. Sometimes have to rename as .MPG to play. Single container files approx 2Gb per hour = 25kbps audio and 15Mbps video at 25fps in SD format.
-
What flowchart tool do you use?Visio if available - but use so little I cant justify purchase! Open Office - Draw does nearly the same as Visio for state diagrams - has glue points on shapes so can move around and links stretch to fit. Data flow diagrams - have used LucidChart.com for simple diagrams - free up to a certain size Edit the PDFs out of Lucid with free version PDFxchange , can annotate with extra detail block comments and shapes. This is my favourite tool for annotating printouts and pasted screenshots from windows snipping tool, etc for simple program documentation.