Mr Ron,
Regarding to your "merge data from all workbook" (fso page),
especially macro RDB_Filter_Data.

I set the 'include subfolder' to true,
so may be the code will search into
the workbook in about 300 folders.
May be the user want to interrupt
the current searching process
(by hitting cmdStop Search). If so,I want
the code to stop searching (run) or
Go To another code line ( may be a
msgBox that tell the user how many
records been catched).
Thank's

Rgds,

Shiro

"Ron de Bruin" wrote in message
...
More info please

--

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


"shiro" wrote in message
...
Regarding to Mr Ron's RDB_Filter_Data code,I need a
code for cmdButton to stop the current Search process.
Please advise some guidance.
Thank's

Rgds,

Shiro