---

VBA and Microstation point3d in excel
Dear Friend!
I was able to use every class in VBA under Excel from Microstation 2004(v8) and change some attribute as well but unfortunately not any POINT3D.
It is amazing because most importatnt thing is Point3D, which is easy to instantiate in VBA under Microstation but it is not possible in VBA under Excel.

My question is, who it couls be possible that you would be able to use a lot of other objects of Microstation CAD under Excel-VBA but not Point3D!!  Point3D is first thing for every geometry

Thank you for the help.

Best regards,
F. Tasnimi

Eine Antwort auf diesen Beitrag verfassen (mit Zitat/Zitat des Beitrags) IP

---

hello tasnimi,

i will try to help you, but you should tell me the version of your microstation and what you want especially do with an point3d in excel?
you only want to create an object of point3d in excel?
have you set your queries in excel to the libraries of microstation?

... and donŽt ask one question in four forums. thatŽs no good idea!

with nice greets TP

------------------

Eine Antwort auf diesen Beitrag verfassen (mit Zitat/Zitat des Beitrags) IP

---

Point3D.gif Bentleyreferenced.gif

Thank you for Help,

It is really so1 exactly as you mentioned.
Microstation is version 2004 as well as V8.
I added the reference of microstation in Excel and no problem.
I want only to make an object of Point3D like other objects. It is really stange because All other objects have b enn instantiated by me and were working very well except Point3d.

Only Point3D dosn't exist in excel. I have Excel 97.
In excel I have made a new Application of Microstation and opened an existing Designfile and change some elements. All thing is excelent.
But no Point3D is possible. It is but really stange.

Option Explicit

Dim MYMicros As MicroStationDGN.Application
Dim myDesignFile As MicroStationDGN.DesignFile

Dim MyPoint3D As ????????????????

Sub test()

Set MYMicros = New MicroStationDGN.Application
    MYMicros.OpenDesignFile ("C:\Tasnimi\Project4_Electric\Objects\Carbody.dgn")

End Sub

My targhet is to declare and than instantiale MicroStationDGN.Point3d  but this is not existing in Excel, while it is working in Microstation very well.

Thank for Help.
yours,
Farshid

Eine Antwort auf diesen Beitrag verfassen (mit Zitat/Zitat des Beitrags) IP

---

Hi Farshid,

are there other [extended] Libraries for Microstation or is this reference the only possible for it?
What's the 3DPoint-Object in Microstation VBA, properties??
An array like point(0)=x1 : point(1)=y1 : point(2)=z1 : point(3)=x2 : point(4)=y2 ... etc ?

Sorry, but i've no Microstation and no Excel97, Excel97 use vba5 for instance, however, that's just by the way and sure, maybe not the problem;-)

CU Nancy
    

Eine Antwort auf diesen Beitrag verfassen (mit Zitat/Zitat des Beitrags) IP

---

point3d_object.jpg references.jpg

Hello Farshid,

i have no problems with point3d and excel. you can see it in my attachments. the difference is, that iŽm using office 2003. i will try it with your version of excel, but not today. Sorry, that i have no better news for you.

with nice greets TP

------------------

Eine Antwort auf diesen Beitrag verfassen (mit Zitat/Zitat des Beitrags) IP

---

Hello Farshid,

sorry, I canŽt find an old version of excel. IŽm sure that it is running in excel 97 too. There are no differences between referencing libraries of Microstation in Excel 97 or 2003. The objects are the same and are defined in Microstation.
You can try it from an other application with a VBA interface. So you can figure out, whether it is a problem in Excel or Microstation.
Do a new installation of Microstation with all features, hoping it will help.

cheers TP

------------------

Eine Antwort auf diesen Beitrag verfassen (mit Zitat/Zitat des Beitrags) IP

---

Hello All friends,
Thank you very much fpr all of your efforts. It was relly big help for me.
We will try them in new instalation or meybe in newer Excel version.

I wish you all. Best life

till soon
Farshid

Eine Antwort auf diesen Beitrag verfassen (mit Zitat/Zitat des Beitrags) IP

---

Hi again,
I tested it in other Computer with the same application and prpblem is still there. It means no Point3d in the Library of microstation is declareable.
there is only one Library and is the same as for you written above "Bentley Microstation V8 DGN 8.0 Object Library"

But as I see it was possible in your computer and xyour Excel but not in my Excel.97

I'm getting slowly headach.

Than you very much till now

Eine Antwort auf diesen Beitrag verfassen (mit Zitat/Zitat des Beitrags) IP