PC Review


Reply
Thread Tools Rate Thread

Windows Common Dialogs in VBA?

 
 
Leonard Jonas
Guest
Posts: n/a
 
      22nd Jul 2003
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 With Quote
 
 
 
 
Bill Lunney
Guest
Posts: n/a
 
      22nd Jul 2003

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Windows Vista Common Dialogs and SharePoint schyler.jones@arcomm1.com Windows Vista General Discussion 1 7th Feb 2008 12:59 AM
Windows Vista Common Dialogs and SharePoint schyler.jones@arcomm1.com Windows Vista Networking 0 6th Feb 2008 11:12 PM
Common Dialogs Edit/Remember positions =?Utf-8?B?U2Vt?= Windows XP Customization 0 20th Oct 2004 02:05 AM
How can I execute File Operations using the Windows File Transfer Common Dialogs? Christian Blackburn Microsoft VB .NET 3 20th Oct 2003 01:40 PM
IO Common Dialogs Andy Janssen Microsoft Dot NET Framework 2 13th Oct 2003 08:29 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:19 PM.