Referencing specific cell

  • Thread starter Thread starter Sean
  • Start date Start date
S

Sean

What is the code used to reference a specific cell from
another office application?

For example, I have a project plan in MSFT Project and I
want my code to read the value of cell B1 in an excel
worksheet and then import this value into MSFT project...

this is a very simple, single sheet, excel file...

any help would be greatly appreciated...
 
Dim oxlApp as Object
set oxlApp.CreateObject("Excel.Application")
.. . .
vVal = oxlApp.Workbooks("Myworkbook.xls").Worksheets(1).Range(B1").Value
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional listbox cell populating 4
Run macro on all files in a specific folder 3
How to insert picture using VBA which refer to cell value 1
Enter data in cell referenced in a cell 4
Referencing Inactive Workbook Cells 3
Sheet name=Cell value 2
Set value of a cell with a dropdown list during run time (C#) 10
Disable Clear DContents command in excel - vba code?? 3

Back
Top