Posted to microsoft.public.excel.programming

Rob

external usenet poster

Posts: 234

Open Dialog

Excel 2000

I have recorded a macro to open a txt file and then carry out some
formatting, my need is however to run this on several files each with a
different name. How can I display the open file dialog window, select the
file and then run my macro? If I cancel the open dialog window I won't want
to run the macro.

Hopefully this makes sense!

Thanks, Rob

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Open XML dialog box	Keithmeister	Excel Discussion (Misc queries)	0	March 13th 09 12:20 AM
Open Dialog Box	Steven	Excel Discussion (Misc queries)	1	January 6th 09 10:10 PM
Open Dialog Box	MichaelR	Excel Worksheet Functions	1	June 5th 08 05:36 AM
open dialog box	Carrie	Excel Discussion (Misc queries)	1	January 19th 07 10:43 PM
File open dialog	Vaughan	Excel Discussion (Misc queries)	0	May 12th 05 08:50 AM

All times are GMT +1. The time now is 09:12 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us