Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ActiveCell.Offset not supported when coding Excel from MS Project

Status
Not open for further replies.

Palmcrest

Technical User
Jul 10, 2006
66
AU
When I use the offset method in Excel to select an adjacent cell it works fine.
I have pushed some data via MS Project to XL using code in Project. It seems when I use the Offset property it is not supported.
ActiveCell."Offset" does not appear in the object drop downs when coding in Project.
Any thoughts as to how I can deal with this? I want to push data to a new XL file so all the code has to reside in Project.
I have also selected the MS Excel Object library.
Thanks
 
OK so I realised I was not referencing the Excel objects by using Dim XXXX as Excel.Application
All good
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top