How can we store information:
for a VBA solution, whether that be an Access database, Excel workbook, Word Document …?
What about storing the information in the registry!
That’s the subject I would like to broach in this article.
Whether it is to save, retrieve files, define the initial file dialog folder, … we often want to work with existing system folders. In this article, I thought I’d showcase a few possible ways to retrieve the path of system folders, or as some people refer to them as special folders.
Specifically, I will cover:
I was recently doing some work for a client in which I build an Excel WorkBook that processed a series of large CSV files to clean them up, format the content, … because of their size the process could take several minutes and they contacted me thinking it wasn’t working and that they thought the process had hung.
So I set out to provide them with a visual display of the process’ progress, a progress bar!
Every once in a while, programs do not shutdown properly and thus cause headaches. So it can become necessary to terminate the process. Below are a couple different approaches you can employ to terminate, forcibly close, a process/program.
Continue reading
Today, I thought I’d demonstrate a couple distinct methods that can be used to validate whether a file exists or not.