Topic: Extracting text to excel in the order it is selected in Autocad

[ELOQUINTET]

fatty it's not allowing me to load the file. when i try via vbaload it says wrong file format? I saved it as .dvb so i'm not sure what's going on

[Guest]

fatty it's not allowing me to load the file. when i try via vbaload it says wrong file format? I saved it as .dvb so i'm not sure what's going on

You didn't paste it into Notepad and then save it with a DVB extension did you??!?

[ELOQUINTET]

ummmm  yes How am I supposed to do it. When I've gotten stuff from here before it was already saved so how do I create the file? 

[ELOQUINTET]

whoops my brain is waking up now. i created a new file from vbaman and am trying it out now , will let you know. fatty i mistyped when i typed sond. i will not typically need to reduce by a given increment so that part can be taken out.

[ELOQUINTET]

fatty in theory it works but i have a few suggestions. first off i select the room name then the shade sizes. then i hit enter and it says interrupted by user. i though it would not do this until i hit 2 enters? what would be more useful to me would be to ask the user if it is a single or double shade. it seems that it should be after each 2 picks so you would select the width and height then move to the next shade assembly. the picture i shared with you shows all double shades but we have single shades as well which would only have a single width and height. am i making sense? cool stuff though i think you get the general i dea of what i need. thanks

[Fatty]

Hi Dan
See attched picture this will
explain to you selection order
much better than me

~'J'~

[ELOQUINTET]

that's how i was selecting but when i press enter after pick 5 it says interrupted by user. below is the sequence the routine should follow:

i select the room name
i receive a prompt asking if my shade is a single or double
i select the width and height
it asks me if that is all the shades in the room
if answer is no it asks if my shade is a single or double
i select the width and height
it asks me if that is all the shades in the room
if answer is yes it prompts me to select next room name
and so on and so on
if i select enter twice it will give me a prompt like i am finished i want to generate my schedule
or i have more rooms to add

Does this make sense?

[Fatty]

This picture just for to show you an algorithm
You can add the room as many as you need
But I recommend you test it on, say, 2-3 rooms
in the first time

Btw did you check your private msgbox?

~'J'~

[ELOQUINTET]

fatty,

i am trying to tell you that it is not working the way you say. i cannot add more than one room at a time it either adds it to one room or the routine ends and i have to restart it which puts the next stuff in a seperate read only excel file. i did see your message but haven't had time to post anything yet. i've been very overloaded with work the past few days. i will try to before i leave today. thanks

[Fatty]

Dan
This is strange
On my machine this worked good for me
but I didn't test it extensively though
Okay, still waiting for the working drawing from you
Btw I use A2007eng only

~'J'~

[ELOQUINTET]

i sent you the cad file and excel schedule. i just noticed my tag is wrong on here i'm actually using autocad 2008 now. i saved it down to 2004 so hopefully you can open it. let me if you have any problems

dan

[Fatty]

Dan,
this dvb file worked nice with your
drawing and Ecel file
Just select all with accuracy, do not miss
Let me know if I missed something there

~'J'~

[ELOQUINTET]

fatty,

i tried this and noticed that you hard coded my schedule name into the code which i don't want to use for testing. i tried to change the line back to dat.xls and now it no longer works. it opens the excel file but does not go back into autocad. when i maximize the autocad window it say interrupted by used. i even tried opening the dat.xls file before running the routine but still doesn't work, what is going on?

[ELOQUINTET]

Fatty,

Take a look at this Illustration. I think it shows what I have in mind pretty well. Let me know if you have any questions.

Illustration

[Fatty]

fatty,

i tried this and noticed that you hard coded my schedule name into the code which i don't want to use for testing. i tried to change the line back to dat.xls and now it no longer works. it opens the excel file but does not go back into autocad. when i maximize the autocad window it say interrupted by used. i even tried opening the dat.xls file before running the routine but still doesn't work, what is going on?

Hi Dan, sorry for the late
After the Excel file window will be minimized,
you can just click on AutoCAD icon at the bottom
of screen, I tried to do it programmable with using
of API function 'Setfocus' and with VBA AppActivate
function, but with no luck at the moment
Just for interest, why do you wan't to test it
on Excel file you sent me?
I tested it on this file only, please try with this file
and send your comments back
Unforunatelly I haven't have a 2008 version
maybe problem is on

~'J'~