Hi Anita

Post it in the Mac newsgroup
microsoft.public.excel.macintosh

I have never used a Mac


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



"Anita" wrote in message ...
Hi Ron,

Tried to follow it Step by step, but went wrong at the first step. I think I
forgot to mention I'm using a Mac. Changed c:\data into 'Macintosh
HD:Users:myname:Desktop:test' but then he tripped over

ChDrive MyPath

Can you help me out?

"Ron de Bruin" wrote:

See
http://www.rondebruin.nl/copy3.htm

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



"Anita" wrote in message ...
I'm setting up a webshop and using Excel to put in the products.
I've got seperate workbooks for my 20 product-groups (20 excel documents),
and each group is devided in brands (a min. of 5 brands per product group),
which are in worksheets.

I would like to make a file that import all the data from all the
worksheets, without me having to save each worksheet into a different text
file.
I've tried to copy the data and past it as a link, but when a row is added,
updating the link doesn't add the added row.
I've tried to import from text files, it does add added rows, but I've got
to save all my worksheets as text files.

Can anyone help me out?