Get two Values from closed Workbooks

[Roger Larsson]

Hello Excelworld

I'm Roger Larsson from Sweden and it's my first time in this forum.

How do I get Two (or more) Values from each closed Workbook in a folder that contains only .xls-files. There will be new files all the time. The Range of the Values could be i.e "G6" and "H54". I don't want the Workbooks to be opened, instead I prefere to use i.e "GetValuesFromAClosedWorkbook".

Why do I look for help?

Each .xls-file in the folder has a unique name. i.e 1002.xls
I'm using a Macro that list all the files as Hyperlinks in a new Workbook. (Fakturalista.xls).Sheet("Fakturalista").Column A. Now I want to get the Values above and put them in Column B and C. For this I want to use the same Macro.

The Hyperlink Macro is attached. How do i get this Macro to start the list in Row 4 instead of Row 1?

Thank's for your help Roger

[Norman Jones]

Hi Roger,

See Ron de Bruin at:

http://www.rondebruin.nl/ado.htm#folder

See particularly Ron's GetData_Example4().

Very properly, few in this group would be prepared to open unknown
attachments.

If you still have problems, post the relevant code.

---
Regards,
Norman



"Roger Larsson" <[email protected]>
wrote in message
news:[email protected]...
>
> Hello Excelworld
>
> I'm Roger Larsson from Sweden and it's my first time in this forum.
>
> How do I get Two (or more) Values from each closed Workbook in a folder
> that contains only .xls-files. There will be new files all the time. The
> Range of the Values could be i.e "G6" and "H54". I don't want the
> Workbooks to be opened, instead I prefere to use i.e
> "GetValuesFromAClosedWorkbook".
>
> Why do I look for help?
>
> Each .xls-file in the folder has a unique name. i.e 1002.xls
> I'm using a Macro that list all the files as Hyperlinks in a new
> Workbook. (Fakturalista.xls).Sheet("Fakturalista").Column A. Now I want
> to get the Values above and put them in Column B and C. For this I want
> to use the same Macro.
>
> The Hyperlink Macro is attached. How do i get this Macro to start the
> list in Row 4 instead of Row 1?
>
> Thank's for your help Roger
>
>
> +-------------------------------------------------------------------+
> |Filename: Hyperlink.txt |
> |Download: http://www.excelforum.com/attachment.php?postid=4220 |
> +-------------------------------------------------------------------+
>
> --
> Roger Larsson
> ------------------------------------------------------------------------
> Roger Larsson's Profile:
> http://www.excelforum.com/member.php...o&userid=30441
> View this thread: http://www.excelforum.com/showthread...hreadid=501048
>

[Roger Larsson]

Hello Norman.

Thank you for tip (Ron's GetData_Example4()). It's working, but I still don't know how to get two separated Values i.e "G6" and "H54". And how do I get the list in the new worksheet to start in i.e Row 4?

Reg.

Roger Larsson