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.
Mandark just sent a post and now it seems like they took it away, saying if I share this code, you guys might know how to fix Shockwave Flash so you can bypass it. The person who made the Macro is already gone. Is there anyone out there willing to help with that?
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!