Macro Error Help!!

TheMSsForum.com: The Microsoft Software Forum

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
Top

Re: Macro Error Help!! by Ron

Ron
Fri May 09 09:15:27 CDT 2008

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" <Yossy@discussions.microsoft.com> wrote in message news:86ED1732-D0CA-4B51-AFD4-F574B9FD4A5F@microsoft.com...
> 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
>
Top

Re: Macro Error Help!! by Yossy

Yossy
Fri May 09 09:24:14 CDT 2008

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" <Yossy@discussions.microsoft.com> wrote in message news:86ED1732-D0CA-4B51-AFD4-F574B9FD4A5F@microsoft.com...
> > 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
> >
>
Top

Re: Macro Error Help!! by Ron

Ron
Fri May 09 09:41:17 CDT 2008

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" <Yossy@discussions.microsoft.com> wrote in message news:9742B711-4302-4226-A2BC-EBE304552319@microsoft.com...
> 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" <Yossy@discussions.microsoft.com> wrote in message news:86ED1732-D0CA-4B51-AFD4-F574B9FD4A5F@microsoft.com...
>> > 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
>> >
>>
Top