Is it Visual Basic for Applications or Visual Studio? Which one do I need to pick between them?
Is it Visual Basic for Applications or Visual Studio? Which one do I need to pick between them?
I think you'd have to change the whole thing. Just me using this spreadsheet means I can't touch the code. I just made a few short macros on my own, not many steps at all.
Looking at the code shown above, I don't see why Flash would be a problem. Everything this script is doing is just opening a file window to show any .csv (Excel) files found and saving the path of those files into the fullpath variable. [Note: VBA runs in an interpreter, so you usually don't need to declare variables like fullpath beforehand]. The code looks okay from what I can see, which suggests there might be something wrong with how it's running. It's probably because a change has made the file need Office 365 or some special feature that you don't have installed.
I figured out that resetting VBA and turning off the Shockwave player on my library reference fixed everything. Thanks for everyone who helped me!