I have written a number of macros that use the following code,
With Application.FileDialog(msoFileDialogFilePicker)....
Something (?) has happened and now this portion doesn't work any longer. When clicking on the macro I get the error variable not defined with the msoFileDialogFilePicker highlighted.
When I look at the references I don't have the choice of the Microsoft Office 11 Object Library. The macros have been working for several months so I know that the code is OK.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
Discuss This Question: