I have a treeView popualted with data in an excel spreadsheet. What I'm finding is everytime I press Save or the Auto Save feature kicks in all the Nodes on the TreeView are expanded. Is this a way to prevent this happening as there are many levels of Nodes and you can easily lose track of where you were if the Auto Save feature is activated while your selecting items in the treeView
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc.
In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…