Get Cell Values from Other .xls files

Hello -

I need some conceptual help and some specific help.

I have many excel files being sent to me. All are in the same format :-)
I want to make a new .xls file (Master) that goes out into this directory
where all these .xls files are and "gets J2 and puts it in column A1 of the
Master workbook, then gets P4 and puts in in column B1 of the Master
workbook... when done, go get the next .xls, open and put in A2 and B2,
etc...".

I'm having difficulty finding what the objects are called and the syntax
that goes with them. Once I get a handle on this, I'll be able to ask better
questions to this group. until then -

Thank you VERY much!

Use this one
http://www.rondebruin.nl/summary2.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"DTTODGG" <DTTODGG@discussions.microsoft.com> wrote in message news:2E09F434-2D21-4B35-9C17-3202F93686E4@microsoft.com...
> Hello -
>
> I need some conceptual help and some specific help.
>
> I have many excel files being sent to me. All are in the same format :-)
> I want to make a new .xls file (Master) that goes out into this directory
> where all these .xls files are and "gets J2 and puts it in column A1 of the
> Master workbook, then gets P4 and puts in in column B1 of the Master
> workbook... when done, go get the next .xls, open and put in A2 and B2,
> etc...".
>
> I'm having difficulty finding what the objects are called and the syntax
> that goes with them. Once I get a handle on this, I'll be able to ask better
> questions to this group. until then -
>
> Thank you VERY much!

Thank you, Ron.
I appreciate all your work putting these examples together.
I used you sample, made the adjustments, but I'm getting a:
Run-time error '1004' when I run within VB. If I run the macro outside VB I
get a 400 in the msgbox.

Could you tell me where I can learn more about error messages, what they
mean, how to fix them? I'm certain this is something simple, but I'm "dead in
the water".

I need to learn how to debug and fix my programs.

"Ron de Bruin" wrote:

> Use this one
> http://www.rondebruin.nl/summary2.htm
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "DTTODGG" <DTTODGG@discussions.microsoft.com> wrote in message news:2E09F434-2D21-4B35-9C17-3202F93686E4@microsoft.com...
> > Hello -
> >
> > I need some conceptual help and some specific help.
> >
> > I have many excel files being sent to me. All are in the same format :-)
> > I want to make a new .xls file (Master) that goes out into this directory
> > where all these .xls files are and "gets J2 and puts it in column A1 of the
> > Master workbook, then gets P4 and puts in in column B1 of the Master
> > workbook... when done, go get the next .xls, open and put in A2 and B2,
> > etc...".
> >
> > I'm having difficulty finding what the objects are called and the syntax
> > that goes with them. Once I get a handle on this, I'll be able to ask better
> > questions to this group. until then -
> >
> > Thank you VERY much!
>
>
>

Hi DTTODGG

Where have you copy the code ?
When do you get the error ?
Show me the macro with your changes

--
Regards Ron de Bruin
http://www.rondebruin.nl


"DTTODGG" <DTTODGG@discussions.microsoft.com> wrote in message news:80FADFAD-8CB3-45E6-84F1-C737289EE2FA@microsoft.com...
> Thank you, Ron.
> I appreciate all your work putting these examples together.
> I used you sample, made the adjustments, but I'm getting a:
> Run-time error '1004' when I run within VB. If I run the macro outside VB I
> get a 400 in the msgbox.
>
> Could you tell me where I can learn more about error messages, what they
> mean, how to fix them? I'm certain this is something simple, but I'm "dead in
> the water".
>
> I need to learn how to debug and fix my programs.
>
> "Ron de Bruin" wrote:
>
>> Use this one
>> http://www.rondebruin.nl/summary2.htm
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>> "DTTODGG" <DTTODGG@discussions.microsoft.com> wrote in message news:2E09F434-2D21-4B35-9C17-3202F93686E4@microsoft.com...
>> > Hello -
>> >
>> > I need some conceptual help and some specific help.
>> >
>> > I have many excel files being sent to me. All are in the same format :-)
>> > I want to make a new .xls file (Master) that goes out into this directory
>> > where all these .xls files are and "gets J2 and puts it in column A1 of the
>> > Master workbook, then gets P4 and puts in in column B1 of the Master
>> > workbook... when done, go get the next .xls, open and put in A2 and B2,
>> > etc...".
>> >
>> > I'm having difficulty finding what the objects are called and the syntax
>> > that goes with them. Once I get a handle on this, I'll be able to ask better
>> > questions to this group. until then -
>> >
>> > Thank you VERY much!
>>
>>
>>

Ron, I have gotten past the 1004 error (syntax in my GetOpenFilename line)
But, I don't get any of the cells - just the file name gets into column 1
and the other cells are yellow.

It seems to not like the line:
SheetCheck = ExecuteExcel4Macro(PathStr & Range("A1").Address(, , x1R1C1))

Can you explain what's here? what is Excel4Macro?

Thank you!

"Ron de Bruin" wrote:

> Hi DTTODGG
>
> Where have you copy the code ?
> When do you get the error ?
> Show me the macro with your changes
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "DTTODGG" <DTTODGG@discussions.microsoft.com> wrote in message news:80FADFAD-8CB3-45E6-84F1-C737289EE2FA@microsoft.com...
> > Thank you, Ron.
> > I appreciate all your work putting these examples together.
> > I used you sample, made the adjustments, but I'm getting a:
> > Run-time error '1004' when I run within VB. If I run the macro outside VB I
> > get a 400 in the msgbox.
> >
> > Could you tell me where I can learn more about error messages, what they
> > mean, how to fix them? I'm certain this is something simple, but I'm "dead in
> > the water".
> >
> > I need to learn how to debug and fix my programs.
> >
> > "Ron de Bruin" wrote:
> >
> >> Use this one
> >> http://www.rondebruin.nl/summary2.htm
> >>
> >> --
> >> Regards Ron de Bruin
> >> http://www.rondebruin.nl
> >>
> >>
> >> "DTTODGG" <DTTODGG@discussions.microsoft.com> wrote in message news:2E09F434-2D21-4B35-9C17-3202F93686E4@microsoft.com...
> >> > Hello -
> >> >
> >> > I need some conceptual help and some specific help.
> >> >
> >> > I have many excel files being sent to me. All are in the same format :-)
> >> > I want to make a new .xls file (Master) that goes out into this directory
> >> > where all these .xls files are and "gets J2 and puts it in column A1 of the
> >> > Master workbook, then gets P4 and puts in in column B1 of the Master
> >> > workbook... when done, go get the next .xls, open and put in A2 and B2,
> >> > etc...".
> >> >
> >> > I'm having difficulty finding what the objects are called and the syntax
> >> > that goes with them. Once I get a handle on this, I'll be able to ask better
> >> > questions to this group. until then -
> >> >
> >> > Thank you VERY much!
> >>
> >>
> >>
>
>
>

I reply to your private mail with a example workbook

--
Regards Ron de Bruin
http://www.rondebruin.nl


"DTTODGG" <DTTODGG@discussions.microsoft.com> wrote in message news:CF486108-1DF7-4AD2-A2C5-01AC51D5DD3B@microsoft.com...
> Ron, I have gotten past the 1004 error (syntax in my GetOpenFilename line)
> But, I don't get any of the cells - just the file name gets into column 1
> and the other cells are yellow.
>
> It seems to not like the line:
> SheetCheck = ExecuteExcel4Macro(PathStr & Range("A1").Address(, , x1R1C1))
>
> Can you explain what's here? what is Excel4Macro?
>
> Thank you!
>
> "Ron de Bruin" wrote:
>
>> Hi DTTODGG
>>
>> Where have you copy the code ?
>> When do you get the error ?
>> Show me the macro with your changes
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>> "DTTODGG" <DTTODGG@discussions.microsoft.com> wrote in message news:80FADFAD-8CB3-45E6-84F1-C737289EE2FA@microsoft.com...
>> > Thank you, Ron.
>> > I appreciate all your work putting these examples together.
>> > I used you sample, made the adjustments, but I'm getting a:
>> > Run-time error '1004' when I run within VB. If I run the macro outside VB I
>> > get a 400 in the msgbox.
>> >
>> > Could you tell me where I can learn more about error messages, what they
>> > mean, how to fix them? I'm certain this is something simple, but I'm "dead in
>> > the water".
>> >
>> > I need to learn how to debug and fix my programs.
>> >
>> > "Ron de Bruin" wrote:
>> >
>> >> Use this one
>> >> http://www.rondebruin.nl/summary2.htm
>> >>
>> >> --
>> >> Regards Ron de Bruin
>> >> http://www.rondebruin.nl
>> >>
>> >>
>> >> "DTTODGG" <DTTODGG@discussions.microsoft.com> wrote in message news:2E09F434-2D21-4B35-9C17-3202F93686E4@microsoft.com...
>> >> > Hello -
>> >> >
>> >> > I need some conceptual help and some specific help.
>> >> >
>> >> > I have many excel files being sent to me. All are in the same format :-)
>> >> > I want to make a new .xls file (Master) that goes out into this directory
>> >> > where all these .xls files are and "gets J2 and puts it in column A1 of the
>> >> > Master workbook, then gets P4 and puts in in column B1 of the Master
>> >> > workbook... when done, go get the next .xls, open and put in A2 and B2,
>> >> > etc...".
>> >> >
>> >> > I'm having difficulty finding what the objects are called and the syntax
>> >> > that goes with them. Once I get a handle on this, I'll be able to ask better
>> >> > questions to this group. until then -
>> >> >
>> >> > Thank you VERY much!
>> >>
>> >>
>> >>
>>
>>
>>