Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Excel import to Microstation

29 views
Skip to first unread message

Kevin Snook

unread,
Sep 12, 2002, 10:39:03 PM9/12/02
to
This is a poll for the users out there to see how many people
would be interested in such a program. Please read on. And
respond via the thread or by emailing me directly.

I have an excel addin nearly completed that will allow exporting
of excel data directly into Microstation. It comes in three parts.
One is the excel addin that loads at startup with excel, the second is the
settings manager that allows you to have different settings and
output based on a particular client by saving seperate settings files,
and the third is the macro in Microstation that allows you to select
the certain file to be imported. It has settings for borders and text alike.
I guess I'm wondering how many people would be interested if
I were to set up a website for downloading the setup. This program
beats the Axiom Office impoter hands down. There really is no comparison
to the control you have. It doesn't link the spread sheet as Axiom does, but
I personally have had nothing but problems with linked workbooks anyway.
Thanks

Kevin Snook


Steve Palmer

unread,
Sep 12, 2002, 2:17:06 PM9/12/02
to
Kevin Snook wrote:

> ... I have an excel addin nearly completed that will allow exporting of excel
> data directly into Microstation. ...

Hi Kevin,
Please send me a demo. Is Yaggy Colby Associates paying you to develop this
utility?
--
Steve Palmer
Product Manager
Axiom International

Kevin

unread,
Sep 12, 2002, 4:58:18 PM9/12/02
to
No Steve this is on my own time. We use it here but I wrote
the code and compiled the program on my own time.

Kevin


"Steve Palmer" <p...@axiomint.com> wrote in message
news:3D80D86A...@axiomint.com...

Bill Dickens

unread,
Sep 13, 2002, 8:36:10 AM9/13/02
to
Please let me have a copy.

We did bring in a building code search at Harley which was many pages
long and It came in with the graphics... Reversed bars, shaded areas
etc. It was linked.
No need for extra formatting. It is a convoluted process but it does
work. Pretty much ate up a 30x42 sheet and looked very impressive.

Dickens

"Kevin" <ksn...@yaggy.com> wrote in message news:<Td7g9.30$zV6....@news.uswest.net>...

Mike Otte

unread,
Sep 13, 2002, 12:10:05 PM9/13/02
to
I would like to take a look at your program

Mike Otte
E&A Consulting Group, Inc.


steve robertson

unread,
Sep 13, 2002, 12:06:25 PM9/13/02
to
On Thu, 12 Sep 2002 15:58:18 -0500, "Kevin"
<ksn...@yaggy.com> wrote:

>No Steve this is on my own time. We use it here but I wrote
>the code and compiled the program on my own time.
>
>Kevin
>
>
>"Steve Palmer" <p...@axiomint.com> wrote in message
>news:3D80D86A...@axiomint.com...
>> Kevin Snook wrote:
>>
>> > ... I have an excel addin nearly completed that will allow exporting of
>excel
>> > data directly into Microstation. ...
>>
>> Hi Kevin,
>> Please send me a demo. Is Yaggy Colby Associates paying you to develop
>this
>> utility?
>> --


I find the following function quite useful both in larger
VBA programs and in ad-hoc export. I do not know how to
create DGN files, but this is handy for script files
("@textfile.txt"). I use other commands such as
"place lstring space",
"place text;"&(cell_with_textstring)&";"&ustnpoint(A1,B1,C1)
to insert data into a DGN file in an ad-hoc way.

Function ustnPoint(N As Double, E As Double, _
Optional h As Double) As String

If IsMissing(h) Then
ustnPoint = "xy=" & Format(E, "0.000") & "," _
& Format(N, "0.000") & ",0.000"
Else
ustnPoint = "xy=" & Format(E, "0.000") & "," _
& Format(N, "0.000") & "," & _
Format(h, "0.000")
End If

End Function

steve

steve robertson

unread,
Sep 13, 2002, 12:08:16 PM9/13/02
to
On Fri, 13 Sep 2002 16:06:25 GMT, steve robertson
<steve_period_robxxxson@_telus_.net> wrote:

I also meant to say that this is obviously not anywhere near
the sophistication of the program(s) being spoken about
here. I just put it out there for people doing the odd
import task, or writing a VBA to generate simple script
files.

steve

B. Shervey

unread,
Sep 13, 2002, 12:27:16 PM9/13/02
to
Hi Kevin. I would like to look at this as well. Have you seen or tried
surgery.ba from John Chugh?


Bewildered

unread,
Sep 14, 2002, 9:31:20 AM9/14/02
to
"Kevin Snook" <ksn...@charter.net> wrote in message news:<uo13esb...@corp.supernews.com>...

This is a poll for the users out there to see how many people
would be interested in such a program. Please read on. And
respond via the thread or by emailing me directly.

Hello Kevin
Count me in; good luck with your application, if it is user-friendly &
reliable you should get a heap of interest. Have tried a couple of
alternatives but found them baffling &/or cumbersome; linking is as
you say troublesome. Bentley don't feel its their job to integrate
Excel properly, maybe they're right- they blame clipboard limitations
for the inability to link large amounts of data, although apparently
Microsoft have overcome the problem in the latest release of
Excel/Office. Goody, another upgrade cost (NOT!)
GD

Žobert

unread,
Sep 14, 2002, 11:21:36 AM9/14/02
to
It's a nice bit of code which is very effective.

--

Regards

Žobert

@ Home = MS8.00.07.06 - XP Home - P4 1.7 - GeF2 nVidia - 512SDRam

--

It's no secret that a client, can sometimes be a pest
It's no secret that a deadline, bites the nails of success

"steve robertson" <steve_period_robxxxson@_telus_.net> wrote in message
news:3834ou01cnl3brhc4...@4ax.com...
: On Fri, 13 Sep 2002 16:06:25 GMT, steve robertson

0 new messages