Thanks for the feedback



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



"JCanyoneer" <JCanyoneer@discussions.microsoft.com> wrote in message news:8071E5D1-1659-439B-9B44-9ECEE817763C@microsoft.com...
> It works perfect. Sorry, I just opend the link without reading which part you
> suggested I look at. I was also looking for ADO code (just to make it similar
> to database access I am currently using), so I just skimmed the link. Played
> with it this morning and it all works awesome. Thank you!
>
> "Ron de Bruin" wrote:
>
>> Hi JCanyoneer
>>
>> My example is doing this
>> What have you try ?
>>
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>>
>> "JCanyoneer" <JCanyoneer@discussions.microsoft.com> wrote in message news:BE475EB0-9ABD-4AC5-B50F-76B72664F240@microsoft.com...
>> > Not really,
>> > I have a workbook open (call it OrderForm1). On Sheet 1 of this work book
>> > I would like to have a button which will run code to:
>> > Open c:\Tracker.xls
>> > Put the value of cell B5 from Order1 in cell A2 on Tracker
>> > Save the Tracker file
>> > Close the Tracker file
>> >
>> > I have written code but it doesn't work. I am doing this with mutiple cells
>> > so the code is fairly long but the above gives the jist of what I'm trying to
>> > do.
>> > Both files are excel, one is currently open and the other is not.
>> >
>> > "Ron de Bruin" wrote:
>> >
>> >> Do you mean this
>> >> http://www.rondebruin.nl/copy1.htm
>> >>
>> >> See the example
>> >> "Example If the Database sheet is in another workbook"
>> >>
>> >> --
>> >> Regards Ron de Bruin
>> >> http://www.rondebruin.nl
>> >>
>> >>
>> >>
>> >> "JCanyoneer" <JCanyoneer@discussions.microsoft.com> wrote in message
>> >> news:4B951D7D-5AD2-4B8B-9D40-6F5F5EF9641B@microsoft.com...
>> >> >I would like to write a macro that will open a designated excel file, (really
>> >> > doesn't have to open it visibly, I just need to be able to insert items in
>> >> > the next empy row) Order Form.xls, find the first empty row, insert values in
>> >> > certain cells in that row based on values from the excel file that called the
>> >> > macro, save the Order Form.xls file, close (if opened) and return to the
>> >> > original excel worksheet. I have a function currently that does something
>> >> > similar into an access file. Are the methods similar?
>> >>
>> >>
>> >>
>>
>>
>>