Consuming excel connection

[magnus101]

Hello,
This is a 2 part question.

#1
In vba I can create a data connection and put the data on a worksheet.
However, in vba can I create a data connection and just read the data?
Without writing the data to a worksheet?

#2
If in one workbook I have a named range, with a data value.
When I create a data connection to that workbook and place the connection on the page,
My named range with one value turns into a table. With my value as the header.
Is there a way to get a named range and have it just a single text in the master workbook?

thank you

 

[Fazza]

hi

#1. VBA can connect to data, such as via ADO or ADO, and populate a recordset. No data need be written to a worksheet. You can work with the recordset object in VBA. It is like an array, you can loop through and do things. In ADO there are some methods that can be used, such as for filtering.

#2. Maybe in the connection string you can define that there are no headers.

HTH

 

[Fazza]

Via google, I found "HDR=NO" goes into the connection string. cheers