code to open a file selection window

[hilyete]

3 years ago I made a "Flash Card" program for my students using PowerPoint and Excel. The PPt presentation allows the student to up-load the vocabulary from Excel sheets. When the school updated to 64 bit computers, the PPt would not work, giving an error message about updating the API calls. I put in the "PtrSafe" as directed and everything works again EXCEPT the code that opens a file selection window that lets them browse to find the Excel file they need. I no longer get an error message, but the file selection window just doesn't open. Does anyone have code (or can point me in the direction) for opening a file selection window using 64 bit computers? (And will that work now on 32 Bit computers?

Thanks

Tom

 

[John_w]

GetOpenFileName or Application.FileDialog(msoFileDialogFilePicker) should work on 32-bit and 64-bit computers.