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!
> >>
> >>
> >>
>
>
>