So, I'm currently trying to open a .xls/.xlsx file, tell it to run a macro to refresh the workbooks, and then save the file as a different file name, thus leaving the original untouched.
Now, technically, it is working, because the last person who held my position wrote a dll to handle the interation. However, it leaves everything declared as an object, which is great up until you have someone who programs option strict on, option explicit on. Then I can't declare my objects at the last minute, and the whole assembly falls apart.
It also sometimes falls apart anyway. He was a sloppy programmer at best.
What I need to do it keep or improve that functionality, but be able to keep my programs option strict on, option explicit on. I'm looking for basically any help here (an actual project that does this would be a great help, naturally, but I haven't found one), up to and including pointers for rewriting the dll so that it complies with my needs.
Thanks for your help, everyone!