| Author |
Message |
D. Duke
Guest
|
 Posted:
Fri Apr 30, 2004 8:09 pm Post subject:
importing excel file into a DGN file |
|
|
I have been trying to import an excel file into a DGN file but the
results have been subpar. When I bring it into a file with the 'paste
special' command and import with "linked microsoft excel file", then
the text is single character and badly spaced, no matter how much I
try to space the characters out. Linking it will get the numbers to
change if something changes in the excel file, but it looks like crap.
If I do a simple paste, I lose all the linework. Has something else
been developed?
Thanks
Dave
|
|
| Back to top |
|
 |
Bill
Guest
|
| Posted:
Sun May 02, 2004 8:03 am Post subject:
Re: importing excel file into a DGN file |
|
|
On 30 Apr 2004 09:09:34 -0700, intercad83@hotmail.com (D. Duke) wrote:
| Quote: | I have been trying to import an excel file into a DGN file but the
results have been subpar. When I bring it into a file with the 'paste
special' command and import with "linked microsoft excel file", then
the text is single character and badly spaced, no matter how much I
try to space the characters out. Linking it will get the numbers to
change if something changes in the excel file, but it looks like crap.
If I do a simple paste, I lose all the linework. Has something else
been developed?
Thanks
Dave
|
Check out:
http://members.optusnet.com.au/~forwardthinking/html/mdl_mac_ucm.htm
Look for the link to surgery.ba. You will have to e-mail and Bear will
send you a copy. The app has a couple of other features as well as
Excel import.
HTH
Bill |
|
| Back to top |
|
|
Kevin Snook
Guest
|
| Posted:
Sun May 02, 2004 7:23 pm Post subject:
Re: importing excel file into a DGN file |
|
|
No..no..no... Don't use surgery, use quantab from Tim Shoemaker.
You will be able to do so much more with this excel macro.
http://www.geocities.com/tshoemaker/utils/quantab8.zip
"Bill" <carver3(remove)3@bellsouth.net> wrote in message
news:vis89016hb5lomnuqp00ib3nrc28mriaot@4ax.com...
| Quote: | On 30 Apr 2004 09:09:34 -0700, intercad83@hotmail.com (D. Duke) wrote:
I have been trying to import an excel file into a DGN file but the
results have been subpar. When I bring it into a file with the 'paste
special' command and import with "linked microsoft excel file", then
the text is single character and badly spaced, no matter how much I
try to space the characters out. Linking it will get the numbers to
change if something changes in the excel file, but it looks like crap.
If I do a simple paste, I lose all the linework. Has something else
been developed?
Thanks
Dave
Check out:
http://members.optusnet.com.au/~forwardthinking/html/mdl_mac_ucm.htm
Look for the link to surgery.ba. You will have to e-mail and Bear will
send you a copy. The app has a couple of other features as well as
Excel import.
HTH
Bill
|
|
|
| Back to top |
|
|
Anthony and Kirsty
Guest
|
| Posted:
Sun May 02, 2004 11:05 pm Post subject:
Re: importing excel file into a DGN file |
|
|
However if you do want to stick to Excel then cut and paste one column at a
time-
when you do I recommend you take a couple more rows than necessary which
will
allow for expansion.
Take to opportuntiy to keep your file names and paths very very simple
because
you may want to use your new table of information as a template- long names
are a
pain to deal with.
I have only been able to get a Microstation file to update when Excel is
actually
open, I could never get it to automatically open, also it give a new warning
when it comes across a link that it cannot update- you will have to warn
other users about this-
confuses them terribly (the poor darlings!)
Coxy |
|
| Back to top |
|
|
D. Duke
Guest
|
| Posted:
Mon May 03, 2004 8:13 pm Post subject:
Re: importing excel file into a DGN file |
|
|
intercad83@hotmail.com (D. Duke) wrote in message news:<6cdf4e3c.0404300809.3420e3@posting.google.com>...
| Quote: | I have been trying to import an excel file into a DGN file but the
results have been subpar. When I bring it into a file with the 'paste
special' command and import with "linked microsoft excel file", then
the text is single character and badly spaced, no matter how much I
try to space the characters out. Linking it will get the numbers to
change if something changes in the excel file, but it looks like crap.
If I do a simple paste, I lose all the linework. Has something else
been developed?
Thanks
Dave
|
Thanks for the help. |
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in