ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   File Search for Combo Box Usage - Excel 2007 (https://www.excelbanter.com/excel-programming/418826-file-search-combo-box-usage-excel-2007-a.html)

Marvin

File Search for Combo Box Usage - Excel 2007
 
I am looking for a routine that will read Excel files from a folder and place
them in a spot on a sheet for usage in a combo box file selection routine.
Application.FileSearch no longer works in Excel 2007.

Ron de Bruin

File Search for Combo Box Usage - Excel 2007
 
Start here
http://www.rondebruin.nl/copy3.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Marvin" wrote in message ...
I am looking for a routine that will read Excel files from a folder and place
them in a spot on a sheet for usage in a combo box file selection routine.
Application.FileSearch no longer works in Excel 2007.


Ahmad

File Search for Combo Box Usage - Excel 2007
 
Hi Marvin,
Have you found solution for your question? I have the same problem. If you
have found the solution will you send a copy or an example?
Thanks
Ahmad

"Marvin" wrote:

I am looking for a routine that will read Excel files from a folder and place
them in a spot on a sheet for usage in a combo box file selection routine.
Application.FileSearch no longer works in Excel 2007.



All times are GMT +1. The time now is 02:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com