I have a spreadsheet that imports xml data files.
Rather than have the user go to the Developer Tab and click Import, I would like to have a button on a form they can click that opens the File Open dialog so they can browse and choose the file.
I've seen the application.getopenfilename macro, but I don't know if I can use that.
Thanks,
Bob
Rather than have the user go to the Developer Tab and click Import, I would like to have a button on a form they can click that opens the File Open dialog so they can browse and choose the file.
I've seen the application.getopenfilename macro, but I don't know if I can use that.
Thanks,
Bob