Pulling data from exccel

[deqw]

I am trying to pull out several cells worth of data, namely our daily
chargback rate. How do Ireference that from within VBA and project?

 

[John]

I am trying to pull out several cells worth of data, namely our daily
chargback rate. How do Ireference that from within VBA and project?

deqw,
That depends. The information you gave is inadequate to allow a
definitive answer. For example. Are you trying to import data form Excel
to Project with a VBA macro in Project? How is the data organized in
Excel? What do you intend to do with the data in Project (i.e. where do
you want the data to go)? Etc.

You help us, maybe we can help you.
John

 

[Jeff]

I would like to reference a cell in an equation cost =work*rate. I am
trying to do earned value in excel since we do not keep rates in the
resource sheet I ned to substitute it from its origin, which is
another excel spreadsheet.

 

[JulieD]

Hi Jeff

are you "deqw" the OP in this thread or is this a completely different
question to his?

Cheers
JulieD

 

[Buster]

I'll try and be more clear. . . . .how do I reference the cell in the
spreadsheet that holds the vallue for rate in the equation "cost =work*rate"
I know I can open the sheet through vba, make it active and locate the cell,
but I'd like to be able to reference the ceell without opening the
spreadsheet. Also the sheet is located on a network drive, so i need some
way of making reference to it without hardcoding the drive letter since
other people use different drive letters for the same shared drive.

Jeff

 

[John]

I would like to reference a cell in an equation cost =work*rate. I am
trying to do earned value in excel since we do not keep rates in the
resource sheet I ned to substitute it from its origin, which is
another excel spreadsheet.

Jeff,
The description is still lacking in sufficient information to give a
definitive answer. . . at least from me. What are you trying to do? I'm
sure it is clear in your mind, but we can't read your mind.

John

 

[John]

I'll try and be more clear. . . . .how do I reference the cell in the
spreadsheet that holds the vallue for rate in the equation "cost =work*rate"
I know I can open the sheet through vba, make it active and locate the cell,
but I'd like to be able to reference the ceell without opening the
spreadsheet. Also the sheet is located on a network drive, so i need some
way of making reference to it without hardcoding the drive letter since
other people use different drive letters for the same shared drive.

Jeff

Jeff,
Your question sounds like it is better suited for the Excel vba
newsgroup. Although I have done a considerable amount of VBA between
Project and Excel, I have never needed to reference an Excel formula, if
that's what you are trying to do. I would have to look in the Excel VBA
help file for an answer but then that's something you can do yourself.
And it is still not clear what you are trying to do. Are you in a
Project VBA macro and trying to extract data from a cell in the Excel
without having Excel open? It may be possible but I don't know how to do
it.

If I were writing a macro to be used by different people who may use
different drive letters for a shared drive, I would probably have the
code open Excel and then get the data from the spreadsheet. The
GetObject Method comes to mind. If it is just a piece of data that is
needed, there is no reason to have Excel be visible. Just open (in the
background), extract and close. But I gotta question why people in the
same corporate environment do not have a standard convention for
assigning shared drives. Sounds like a great way to make something
unnecessarily complex and confusing. A set of basic rules can go a long
way in fostering efficiency.

John