So far so good.Ĭlick "Assign Macro…", then click "PERSONAL.XLS!Open_File", and click OK.Īssuming you have the Standard toolbar visible on the sheet, click on the Open icon, and repeat Step 8 and Step 9. In the Name field, you should see something like "&Open…". This will pull down the File menu options, and at the same time, enable the "Modify Selection" button on the Commands tab of the Customize dialog box.Ĭlick "Open" on the File menu, then click the "Modify Selection" button on the Customize dialog box. With the Customize dialog box open, click on File from the worksheet menu bar. While in VBE with the Personal.xls project selected, click Insert > Module, and paste this in:Ĭlick View > Microsoft Excel, or press Alt+F11.Ĭlick on Tools > Customize > Commands tab. See Excel’s on line help for creating a Personal workbook. If you do not already have a Personal.xls project created, then create one, and return to Step 1. If the Project Explorer is not visible, while in the VBE click View > Project Explorer, or press Ctrl+R.
To get to the VBE, click on Tools > Macro > Visual Basic Editor, or press Alt+F11. Notes (in case anyone reading this does not know): Go to the VBE, and in the Project Explorer, click on VBAProject(Personal.xls). There is a numeric constant to "Microsoft Excel Files" that I think is 2 or 3 or 4.I cannot remember so you'd have to experiment with what the exact number is, by replacing the line in Step 4 fromĪpplication.Dialogs(xlDialogOpen).Show Arg1:="*.*"Īpplication.Dialogs(xlDialogOpen).Show Arg1:="*.2" 'or 3 or whatever the constant is, I cannot remember.
How to change default program file type how to#
The steps below are how to change the default to "All Files" in the Files of Type open dialog box.
0 kommentar(er)
