Shafin Sadarwar Siffa na Microstation da Rarraba Chart

Mun fara 'yan kwanaki da suka wuce game da yadda za a yi haka, amma yin kaddamarwa a Excel don AutoCAD ko daga CSV zuwa Microstation; duka biyun da tsarawa. Saboda haka wasu shakka sun tashi Idan akwai aikace-aikacen da baya buƙatar kwafin kwafi, amma zai yi ma'amala tare da adreshin Excel kuma maimakon maki zai samar da layi, bayan bincike na gaji, kuma tabbas akwai mdl da yawa don Microstation da Lisp don AutoCAD ... Abin baƙin ciki ban sami yawa ba ... hakan zai yi aiki

Iyakar abin da zan iya samuwa shine aikace-aikacen da aka samo a cikin Kayayyakin Kayan Na'urar V8 Rumbosdisttoexcel.mvba, zaku iya sauke shi a zip daga wannan.

1 Yadda za a dauka

• Bayan saukar da shi dole ne ka cire shi
• Don loda shi, yi waɗannan abubuwa: masu amfani / macro / manajan aiki / loda aikin / nemi aikin inda kuka ajiye shi / sannan zaɓi ok

2 Yadda za a kashe shi

• Da zarar ka loda shi, za ka zaɓi shi daga Project Manager kuma yi amfani da blue kibiya "macros"
• Sannan ka zabi aikace-aikacen "RunApplication.runMainMenu"
• Kuna amfani da maɓallin "gudu".
• kuma kwamitin kamar haka zai bayyana

3 Abin da aikace-aikacen ya yi

Wannan aikace-aikacen yana da ayyuka biyu, duka aiki tare da Microstation Geographics.

• Fitarwa zuwa Excel, saboda wannan, yi shinge wanda ke kewaye da polygon, sannan zaɓi zaɓi na Export
• Wannan yana haifar da fayil ɗin a Excel, inda aka raba raguwa, nesa da kuma UTM.
• A lokaci guda kuma yana sanya tsaunuka zuwa polygon farawa da wanda ya fi kudu maso yamma.
• Har ila yau yana ba ka damar yin kuskure, daga bayanan da ke cikin Excel zaka iya sake gina polygon.

Wannan bidiyo nuna yadda yake aiki

Idan wani yana so ya gwada shi, zazzage shi kuma ya sanar da ni idan ya ba ku matsala ... amma kash VBA yana da kalmar wucewa, idan wani ya kuskura ya karya shi ... yana yiwuwa a ba shi damar da yawa.

Na fahimci cewa yakamata yayi aiki tare da Microstation na al'ada, kodayake a bayyane yake yana buƙatar Microstation Geographics tare da buɗaɗɗen aikin, kowa. Bai kamata kuma tare da Microstation's Visual Basic edita yakamata ya zama zai yiwu a cire wannan ɓangaren ... ba shakka, don haka dole ne ku karya kalmar sirri.

Ayyukan masu jiran aiki:

• Gwada wannan kuma gaya mani
• Ya kamata mutum ya san yadda za'a jefa kalmar sirri, saboda aikace-aikacen yana da zafi sosai
• Idan wani ya san game da aikace-aikace, zai zama maraba