Thanks for the offer, Dennis. I would like to see your code for a File Dialog box if you can find it. I'm pretty good at converting VB to VBA. -Tim
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Jensen Sent: Friday, July 20, 2007 10:47 AM To: [email protected] Subject: RE: [Access VBA Central] Trouble opening Common Dialog Box As far as I know there are not any easy methods for this, however, if you are really hurting for it.. I can see if I can find the one I wrote a while back when I needed something without all the Common Dialog Box's window dressings. It might not be exact but it should give you a leg up on it -- although I wrote it in VB so I can't say if it will work 100% in Excel's VBA but you are welcome to give it a try. --- "Heaton, Timothy H. (USD)" <[EMAIL PROTECTED]> wrote: > Thanks Dennis. Where did you find this information? > I tried the solution > suggested at > http://www.miesoftware.com/Support/Articles/ols25.htm > but > it didn't help. > > Is there some alternative to COMDLG.OCX? All I want > to do is search for > data file within Excel so I can "decode" it into a > spreadsheet. The > Common Dialog Box is the perfect facility for file > hunting, so I'd > rather use that than write my own. > > -Tim > > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf > Of Dennis Jensen > Sent: Wednesday, July 18, 2007 10:14 AM > To: [email protected] > Subject: Re: [Access VBA Central] Trouble opening > Common Dialog Box > > Okay on a quick search I find that > > 1) COMDLG32.OCX is depenedent upon COMCAT.DLL > > 2) COMDLG32.OCX is not recommended to be used in > conjunction with MS Excel by Microsoft > > --- "Heaton, Timothy H. (USD)" <[EMAIL PROTECTED]> > wrote: > > > When I try opening the common dialog box in Excel > > using the following > > code I get an error "Object required." I have a > > reference to > > COMDLG32.OCX, and this code works using the same > > reference in Access. > > Any ideas? > > > > CommonDialog.Filter = "Excel files (*.FX)|*.FX" > > CommonDialog.CancelError = True > > CommonDialog.ShowOpen > > > > -Tim > > > > > > > ________________________________________________________________________ > ____________ > Need a vacation? Get great deals > to amazing places on Yahoo! Travel. > http://travel.yahoo.com/ > > > > Yahoo! Groups Links > > > > ________________________________________________________________________ ____________ Get the Yahoo! toolbar and be alerted to new email wherever you're surfing. http://new.toolbar.yahoo.com/toolbar/features/mail/index.php Yahoo! Groups Links
