Posted to microsoft.public.excel.programming

Gregg[_4_] Gregg[_4_] is offline

external usenet poster

Posts: 17

How to capture file name in a folder?

In a folder exists one .ppt file and a non .ppt file. In vba I want to
capture the name of the ppt file. Can someone tell me the best way to
do that?

For example, the path is c:\whatever and the ppt name might be
anything. I just want the name of the ppt file, not the other file.

Thanks.

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
Excel screen capture to capture cells and row and column headings	jayray	Excel Discussion (Misc queries)	5	November 2nd 07 11:01 PM
Need code to save file to new folder, erase from old folder	Ron M.	Excel Discussion (Misc queries)	1	February 24th 06 06:02 PM
open file from folder save in new folder	tim64[_3_]	Excel Programming	20	June 17th 05 07:58 PM
Create Folder and Text File in folder	Todd Huttentsine	Excel Programming	2	April 29th 04 03:41 PM
VBA capture File SaveAs Event	Linda Mcfarlane	Excel Programming	2	September 17th 03 04:06 AM

All times are GMT +1. The time now is 05:38 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us