XP - retrieving data from excel using VBA

[mastro78]

What would be the easiest way to retrieve data from various cells in an Excel spreadsheet? Especially when the Excel spreadsheet name could change.

 

[SkipVought]

Hi,

It the name chages, you'll have to know what name it changed to.

Is it the kind of name that has a "date" appended?

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}

 

[mastro78]

Well, here is the scenerio:

An Excel spreadsheet stores various data. Once all the data is collected it is placed in a directory. Then the whole process begins again with a new Excel spreadsheet, so the file name will change everytime but it's location will not. Basically it's some sort of indexing.

 

[SkipVought]

"Basically it's some sort of indexing."

Basically, that's what you have to find the logic for.

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}

 

[mastro78]

I'm thinking browse to variable to locate the excel docs will work as well...

 

[SkipVought]

Excel has a GetOpenFilename Method.

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}