LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 396
Default Loop through ".DAT" files, open run code, close next

Hi all,

I have a folder called downloads which contains a number of .DAT files
and i need to loop through them one by one, open them, run some code
which will close it on completion of the code then open the next one
until i have processed all files in the folder. When i have processed
the file i put a "d" at the end of the file name.e.g.
IRSQM_010306.DAT before and IRSQM_010306_d.DAT after.

Is this at all possible ? if so some help with some code would be
appreciated.

Thanks in advance

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
If two instances of Excel open top right "X" close only one [email protected] Excel Discussion (Misc queries) 1 July 16th 08 07:47 PM
change the file open default permanently to "All files" Bob Aloisi Excel Discussion (Misc queries) 0 April 29th 08 12:40 PM
modify how files are displyed in the "file open" window Brett Excel Discussion (Misc queries) 3 February 23rd 08 01:59 AM
Suppress popup "Do you really want to save..." after open and immediate close of excel sheets ? Markus Obermayer Excel Discussion (Misc queries) 2 January 2nd 07 02:12 PM
Suppress popup "Do you really want to save..." after open and immediate close of excel sheets ? Markus Obermayer Excel Worksheet Functions 2 January 2nd 07 02:12 PM


All times are GMT +1. The time now is 10:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"