Excel

A few months ago I developed a program that worked with Dropbox’s API to gather data about Dropbox’’s folders. But since we will be transitioning from Dropbox to Sharepoint, I did not develop it much further than obtaining data. However, it was a good learning experience and practice because it got me acquainted with the…

At this point, I’ve been doing VBA programming long enough that I can “read” my codes and know a code line is supposed to be doing. More importantly, I’m starting to be able to “read” other snippets of codes, so that’s a nice accomplishment. So maybe I can call myself beginner/intermediate? In addition, I think…

I finally figured out how to use VBA with Dropbox’s APIs. This was probably at least 3 days’ worth of trying to figure it out, with about 3 weeks interspersed between the first 2 days of failure and the last day of eventual success. It all began when I needed a list of users in…

Okay, Microsoft had done some more updates and now my computers are getting wonky. My work machine works slightly slower now and was initially giving me a black screen. My home machine now gives me a black screen for some minutes. I haven’t timed it yet, but it’s more than one minute, more like 10…

After a couple of weeks, I have finally figured out what is going on with the “invisible” files. I was starting to feel useless and stupid. A couple of weeks ago, my macro stopped working because it could no longer see the downloaded files from our vendor even though the files were open and appeared…

Grrrrrrrr. There has been so many obstacles lately where things just don’t work. It’s been discouraging. This time it is a Windows machine that won’t allow my macro to recognize files downloaded from the internet which is where our vendor site lies. Let’s call the person with a machine that won’t see the downloaded files…