You're welcome. Nice thing is, users have excel built right
into AutoCAD. Don't unload your form containing the
spreadsheet when it's closed and the data will persist until
the drawing is closed. You can also caputre the closing of
the drawing and do some testing to see if you need to
prompt them for a save. Obviously you can have a save
button right on the form also, but they will forget to use
it.
Check the properties for the spreadsheet once you dump
it on a form. Lots there to customize. Also, the control is
version sensitive so make sure you use the same version
of the control the users will be using. The latest version
will be availible when you right-click on the toolbox,
but you can browse to older versions for every version
of Excel you have installed.
gl-Paul
"john coon"
wrote in message
news:5320416@discussion.autodesk.com...
Paul,
Thanks, I will give it a try. Most of the simple routines I do include
writing in or writing out data to text or excel files.
I would be nice to be able to see or edit those excel files before I run
them. It should be a fun learning experience. Thank you for your time.
Have a great day
John Coon
"Paul Richardson" wrote in message
news:5318943@discussion.autodesk.com...
Yes you can. You will have calls like Spreadsheet1.ActiveSheet.Cells...
so just prefacing your Excel Cell calls with the Spreadsheet... will get you
close.
>Any links you know of working with the OWC where the user enters column
>data
>like station & offset in the form based excel component and then
>run to place in the drawing.
May samples of using the control on the web. Very simple to use with
AutoCad since you are already there. Simple calls, using 'ThisDrawing'
and 'Spreadsheet1' directly to communicate between the two. It also
imports and exports csv files directly which is nice, and offers modest
events. The help file if pretty good, just have at it and you'll pick it up
quick. I was just winging it a few years back, before I even knew there
was a help file for it, and found it intuitive.
Post if you have any problems.
"john coon" wrote in message
news:5318934@discussion.autodesk.com...
Laurie, Paul,
Thank you for the info I'll check the Civil 3D sample you noted as I am
using C3D.
From Paul's post it sounds like I might be able to use the same cell calls I
have in older excel routines.
is that correct? I have tons of routines that post data to excel, if I could
reuse them that would be sweet instead of having to create new ones.
Any links you know of working with the OWC where the user enters column data
like station & offset in the form based excel component and then
run to place in the drawing. I done a lot of these in the past but I've used
comma delimited text files to read in the data for Land functions. I would
be great to have that data available for the person to edit in the form if
they didn't like the results.
Thanks and have a great day
John Coon
"Laurie Comerford" wrote in message
news:5318852@discussion.autodesk.com...
Hi John,
If you have Civil 3D installed, their is a Flexgrid control in the
Alignment/Station report program. If you work with that, you know it will
be installed for Civil 3D users. It's a bit quirky, but can be used once
you get the hang of it.
--
Laurie Comerford
CADApps
www.cadapps.com.au
"john coon" wrote in message
news:5318566@discussion.autodesk.com...
Fatty,
How do you connect to a flexgrid?
John Coon
wrote in message news:5314101@discussion.autodesk.com...
You can play with FlexGrid or SpreadSheet controls
See example with SpreadSheet control
~'J'~