Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Windows Common Dialogs in VBA?
I'm writing a series of excel macros for sound processing and would like
to present the user with a FileOpen common dialogue so that they can select a wave file to take data from. In VB I would use Project|Components... to add the control for the windows common dialogue. In VBA there is no such menu item. There is a Tools|Add Controls... item, but it is deactivated. I can load the add-in manager, but it doesn't have any add-ins to chose from. Anyone know how I might get myself a common dialogue control in VBA? Thanks Lenny *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Windows Common Dialogs in VBA?
Load vFilename = Application.GetOpenFilename(Title:="Enter file name", MultiSelect:= False) Save vFilename = Application.GetSaveAsFilename(Title:="Enter file name", InitialFileName:="") http://www.billlunney.com/Excel/FAQ/...?ExcelFAQID=71 -- Regards, Bill Lunney www.billlunney.com "Leonard Jonas" wrote in message ... I'm writing a series of excel macros for sound processing and would like to present the user with a FileOpen common dialogue so that they can select a wave file to take data from. In VB I would use Project|Components... to add the control for the windows common dialogue. In VBA there is no such menu item. There is a Tools|Add Controls... item, but it is deactivated. I can load the add-in manager, but it doesn't have any add-ins to chose from. Anyone know how I might get myself a common dialogue control in VBA? Thanks Lenny *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates in Excel 2007 graph axis dialogs | Charts and Charting in Excel | |||
Application.Dialogs(xlDialogPrint).Show - prints too soon | Excel Discussion (Misc queries) | |||
how to delete unused footer dialogs in excell | Excel Worksheet Functions | |||
How do I work with the "dialogs" I can insert as worksheet tabs? | Excel Worksheet Functions | |||
Dialogs | Excel Discussion (Misc queries) |