| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open files with String prefix
Hi All......
Present problem is, how can I open all the files in the default directory that have a specific string as the prefix (ie: abcdefg) so that I may extract data from them? I do not know how many files there will be, and the directory will have other files in it that I do not wish to open. Any guidance would be much appreciated, Vaya con Dios, Chuck, CABGx3 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open files with String prefix
Hi Chuck
I have a filter option for file names and sheets in this add-in http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "clr" wrote in message ... Hi All...... Present problem is, how can I open all the files in the default directory that have a specific string as the prefix (ie: abcdefg) so that I may extract data from them? I do not know how many files there will be, and the directory will have other files in it that I do not wish to open. Any guidance would be much appreciated, Vaya con Dios, Chuck, CABGx3 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open files with String prefix
Thanks Ron.........it looks really terrific, but I can't use an add-in in
this case. I just need a little code to step through the default directory and open the files I want.......sans that, then to step through a special directory and open all the files, one at a time. Vaya con Dios, Chuck, CABGx3 "Ron de Bruin" wrote in message ... Hi Chuck I have a filter option for file names and sheets in this add-in http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "clr" wrote in message ... Hi All...... Present problem is, how can I open all the files in the default directory that have a specific string as the prefix (ie: abcdefg) so that I may extract data from them? I do not know how many files there will be, and the directory will have other files in it that I do not wish to open. Any guidance would be much appreciated, Vaya con Dios, Chuck, CABGx3 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open files with String prefix
Hi clr
I am ver busy this week I try to past a code example at the end of the week or in the weekend -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "clr" wrote in message ... Thanks Ron.........it looks really terrific, but I can't use an add-in in this case. I just need a little code to step through the default directory and open the files I want.......sans that, then to step through a special directory and open all the files, one at a time. Vaya con Dios, Chuck, CABGx3 "Ron de Bruin" wrote in message ... Hi Chuck I have a filter option for file names and sheets in this add-in http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "clr" wrote in message ... Hi All...... Present problem is, how can I open all the files in the default directory that have a specific string as the prefix (ie: abcdefg) so that I may extract data from them? I do not know how many files there will be, and the directory will have other files in it that I do not wish to open. Any guidance would be much appreciated, Vaya con Dios, Chuck, CABGx3 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open files with String prefix
Thanks Ron........that will be appreciated
Vaya con Dios, Chuck, CABGx3 "Ron de Bruin" wrote in message ... Hi clr I am ver busy this week I try to past a code example at the end of the week or in the weekend -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "clr" wrote in message ... Thanks Ron.........it looks really terrific, but I can't use an add-in in this case. I just need a little code to step through the default directory and open the files I want.......sans that, then to step through a special directory and open all the files, one at a time. Vaya con Dios, Chuck, CABGx3 "Ron de Bruin" wrote in message ... Hi Chuck I have a filter option for file names and sheets in this add-in http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "clr" wrote in message ... Hi All...... Present problem is, how can I open all the files in the default directory that have a specific string as the prefix (ie: abcdefg) so that I may extract data from them? I do not know how many files there will be, and the directory will have other files in it that I do not wish to open. Any guidance would be much appreciated, Vaya con Dios, Chuck, CABGx3 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open files with String prefix
Hi Chuck
Start here http://www.rondebruin.nl/copy3.htm And use this to use the files that start with "week" FilesInPath = Dir(MyPath & "week*.xl*") -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "clr" wrote in message ... Thanks Ron........that will be appreciated Vaya con Dios, Chuck, CABGx3 "Ron de Bruin" wrote in message ... Hi clr I am ver busy this week I try to past a code example at the end of the week or in the weekend -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "clr" wrote in message ... Thanks Ron.........it looks really terrific, but I can't use an add-in in this case. I just need a little code to step through the default directory and open the files I want.......sans that, then to step through a special directory and open all the files, one at a time. Vaya con Dios, Chuck, CABGx3 "Ron de Bruin" wrote in message ... Hi Chuck I have a filter option for file names and sheets in this add-in http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "clr" wrote in message ... Hi All...... Present problem is, how can I open all the files in the default directory that have a specific string as the prefix (ie: abcdefg) so that I may extract data from them? I do not know how many files there will be, and the directory will have other files in it that I do not wish to open. Any guidance would be much appreciated, Vaya con Dios, Chuck, CABGx3 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open Text Files/Format/Save as .xls for multiple files. | Excel Programming | |||
| How to change default Open/Files of Type to "Microsoft Excel Files | Excel Discussion (Misc queries) | |||
| HOW TO GET OVER WITH THIS ANNOYING LINKED FILES MSG BOX WHEN I OPEN FILES WHICH HAS LINKS | Excel Programming | |||
| Macro to open *.dat files and save as .txt (comma delimited text files) | Excel Programming | |||
| file open via IE hyperlink causes already open files to shrink and tile | Setting up and Configuration of Excel | |||
Hybrid Mode
