Macro Error Help!!
Please I need help in resolving this error "Sub or function not defined". I
tried using Ron's code http://www.rondebruin.nl/copy3.htm and i get error. Please help me in identifying what am doing wrong. all responses appreciated. Sub RDB_Module1() ***** This get highlighted Dim myFiles As Variant Dim myCountOfFiles As Long myCountOfFiles = Get_File_Names( _ ****this also gets highlighted I believe these two function are not properly called or referenced to. HELP Thanks Yossy |
Macro Error Help!!
Hi Yossy
Use the example workbook on this page http://www.rondebruin.nl/fso.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Yossy" wrote in message ... Please I need help in resolving this error "Sub or function not defined". I tried using Ron's code http://www.rondebruin.nl/copy3.htm and i get error. Please help me in identifying what am doing wrong. all responses appreciated. Sub RDB_Module1() ***** This get highlighted Dim myFiles As Variant Dim myCountOfFiles As Long myCountOfFiles = Get_File_Names( _ ****this also gets highlighted I believe these two function are not properly called or referenced to. HELP Thanks Yossy |
Macro Error Help!!
Thanks - Works now.
"Ron de Bruin" wrote: Hi Yossy Use the example workbook on this page http://www.rondebruin.nl/fso.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Yossy" wrote in message ... Please I need help in resolving this error "Sub or function not defined". I tried using Ron's code http://www.rondebruin.nl/copy3.htm and i get error. Please help me in identifying what am doing wrong. all responses appreciated. Sub RDB_Module1() ***** This get highlighted Dim myFiles As Variant Dim myCountOfFiles As Long myCountOfFiles = Get_File_Names( _ ****this also gets highlighted I believe these two function are not properly called or referenced to. HELP Thanks Yossy |
Macro Error Help!!
Tip:
Install the Merge add-in if you want it easy http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Yossy" wrote in message ... Thanks - Works now. "Ron de Bruin" wrote: Hi Yossy Use the example workbook on this page http://www.rondebruin.nl/fso.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Yossy" wrote in message ... Please I need help in resolving this error "Sub or function not defined". I tried using Ron's code http://www.rondebruin.nl/copy3.htm and i get error. Please help me in identifying what am doing wrong. all responses appreciated. Sub RDB_Module1() ***** This get highlighted Dim myFiles As Variant Dim myCountOfFiles As Long myCountOfFiles = Get_File_Names( _ ****this also gets highlighted I believe these two function are not properly called or referenced to. HELP Thanks Yossy |
All times are GMT +1. The time now is 04:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com