How do I extract data from multiple workbooks using VBA

[Harrish]

Hello,

I am trying to create functions in VBA and I need to extract data from multiple workbooks. For example, is it possible to sum data(numbers) contained in multiple workbooks using VBA? If so, how do I create that function in VBA.

Any suggestions would be much appreciated,

 

[xzerox]

xzerox,




Does Excel 2004 on a MAC allow for macros?

Yes.

 

[hiker95]

xzerox,

I would suggest that you start your own new post, and add the following link as a reference:
http://www.mrexcel.com/forum/newreply.php?do=newreply&noquote=1&p=2572253

I am not familiar with Exceo 2004 on a Mac.

Did you try the macro code?

You would have to change the:
MyDir = "C:\FLDR 1\"

And, what is the worksheet name?
With .Sheets(1)


And, you should supply screenshots of your summary workbook, and screenshots of the workbooks in the folder/directory.

Here are three possible ways to post small (copyable) screen shots directly in your post:

Please post a screenshot of your sheet(s), what you have and what you expect to achieve, with Excel Jeanie HTML 4 (contains graphic instructions).
http://www.excel-jeanie-html.de/html/hlp_schnell_en.php

or
RichardSchollar’s beta HTML Maker -...his signature block at the bottom of his post

or
Borders-Copy-Paste


Or, you can upload your workbook to www.box.net and provide us with a link to your workbook.

 

[xzerox]

ok, in few minutes i will upload all.

 

[xzerox]

btw

Did you try the macro code?

You would have to change the:
MyDir = "C:\FLDR 1\"

And, what is the worksheet name?
With .Sheets(1)

Yes, i try macro and it returns me 0. i think that is because of directory path where's files.

 

[hiker95]

xzerox,


Please follow the instructions on my reply #22.

 

[xzerox]

ok, new post! :D sry for new THREAD.
I need extract data from multiple workbooks into other workbook cell. just like in this post on beginning BUT i need code to work in Excel 2004 on Mac.

Did you try the macro code?

You would have to change the:
MyDir = "C:\FLDR 1\"

And, what is the worksheet name?
With .Sheets(1)

I tried macro code and yes i need to change MyDir line. Worksheet name is in every workbook same Price. And everything is like in this first post. I think that's only problem in path.
Here is path screenshot:
http://img155.imageshack.us/img155/1903/picture1dz.png