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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open files with String prefix
Hi Ron......
Thanks for getting back to me on this.........I just got in from grocery shopping and am ready to crash, but printed out your response.....all 15 pages...WOW, there ought to be some thing in there that will do it for me........ Many thanks, Vaya con Dios, Chuck, CABGx3 "Ron de Bruin" wrote in message ... 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 |