Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 40
Default Specify Path / open all files in folder...

hi there

i want to open all files in folder (except open file) - copy data from
sheet one, then close each file (maybe change name of file to include
'copied'


i also need to be able to specify folder/full path in userform...

arrghgh

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 172
Default Specify Path / open all files in folder...

http://www.rondebruin.nl/ado.htm


"Buffyslay" wrote in message
oups.com...
hi there

i want to open all files in folder (except open file) - copy data from
sheet one, then close each file (maybe change name of file to include
'copied'


i also need to be able to specify folder/full path in userform...

arrghgh



Reply
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
Path and Number of files in a folder. - Pass to Macro. Richard Excel Discussion (Misc queries) 1 December 21st 06 09:20 PM
set var to folder path using Open Dialogue box BillyRogers Excel Programming 3 April 25th 06 11:32 PM
Finding the Path to the Program Files Folder JGS[_2_] Excel Programming 2 December 12th 05 09:16 AM
Open files in folder - skip if already open Steph[_3_] Excel Programming 6 March 25th 05 06:49 PM
open all files in a folder and ... walt Excel Programming 5 August 7th 03 02:23 AM


All times are GMT +1. The time now is 08:11 AM.

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"