ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro Error Help!! (https://www.excelbanter.com/excel-programming/410695-macro-error-help.html)

Yossy

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


Ron de Bruin

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


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



Ron de Bruin

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