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