View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Leonard Jonas Leonard Jonas is offline
external usenet poster
 
Posts: 1
Default 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!