Topic: Pasteing excel spreadsheets into autocad

[ELOQUINTET]

i have an idea for a lisp but am not sure if i need lisp. this has been on my wishlist for awhile now. when we paste excel spreadsheets this is the proceedure we use:

pastespec
paste link
select ole object
right click
set ole text size to .159

i would like to hit a button and have all of this happen.

would this require lisp or could it be done using a macro?

[Bob Wahr]

hate to give a BS answer but...

Try making a macro to do it.  If it works then yes a macro will work, if not then maybe it still will with tweaking.

Sorry

[ELOQUINTET]

bob made a funny. if making a macro was an easy thing in 2006 that is. damn cui      

[ELOQUINTET]

if i could figure out how to reselect the image after it gets pasted i think i could get it. i tried previous but it says no previous selection set. i seem to remember figuring this out at some point but i'm having a brain fart at the moment. help anyone

[Bob Wahr]

try last instead of previous.

[ELOQUINTET]

o yeah is there a way to issue an arrow key via a macro. i am trying to scroll down to pastelink in the pastespec dialogue

[V-Man]

Here try this. This is a Great program. Just follow the instructions.

File is called AutosXeduLe.xls

Once on the pond look under my name.... "dvarino"

http://http://www.theswamp.org/lilly_pond/temp

[Murphy]

Or you can follow the link in my signature.

[ELOQUINTET]

i saw that a long time ago but forgot about it. when i hit the button it tells me that the macro can not be found. were these created previously or do i have to create them. i have a macro workbook which loads on startup should i create a macro and what would it look like. thanks newts  

[Murphy]

Load Excel, go to Tools
Select Macro
Select Security
Change to Medium or Low. If you set it on Medium it will ask you everytime you load AutosXeduLe if you want to enable Macros.

You will then have to hit Alt+F11.
Press Ctrl+F
Look for ".15" (without the quotes)
Look in Current Project
Any that you find (there should be only 3) change to .16
Next go to Tools
Select References
Scroll down to Autocad 2006 and click the check box.
You can uncheck any other versions of AutoCAD that are checked.

This should fix your problems.

[Jim Yadon]

Just a thought...
... if you are working in 2k6, why wouldn't you come up with a macro that dynamically updates a table object rather than use something with the limits of an OLE spreadsheet? I only have 2k5 and haven't had much time to play with said process. I've modified Spanner to a point where I haven't needed anything else for years and I'm kind of married to it at the moment. So like I said, just food for thought.

[ELOQUINTET]

i tried what you said and it's not working for me. i still get the same message that it can't find the macro. it does not ask me to enable macros upon startup

[Murphy]

Do you have the autosxedule.xls file open before you open the file you want to draw into cad?

[ELOQUINTET]

murphyi closed my drawing then reopened it with my excel already open and i got the message to enable macros. i reopen my spreadsheet and try to draw in cad and i get this error:

object variable or withblock variable not set

what does this mean and how can i fix it?

thanks

[Murphy]

Please download this file and open it.

You will then have to hit Alt+F11.
Go to Tools
Select References
Scroll down to Autocad 2006 and click the check box.
You can uncheck any other versions of AutoCAD that are checked.

Save the AutosXeduLe 2k6.xls file, with it still loaded open the sheet you want to draw into cad.

Open AutoCAD.

Hit the draw schedule button. If it gives you an Error click Debug.
Please copy the line that causes the error and post it here.

Sorry for the problems.