excel values for acad drawing

[Anonymous]

I've searched the forums and cant find what I'm looking for. I created a userform in autocad 2015 that asks for length and width of a rectangle and then draws it for the user. what i really one is to extract the length adn width from an excel file with the same name as the drawing and use that to draw the rectangle. 

I have no preference whether it is in Acad VBA or Excel VBA. I just dont know where to start. 

[Alfred.NESWADBA]

Hi,

>> I created a userform in autocad 2015 that asks for length and width of a rectangle and then draws it for the user

So you know how to use VBA to draw a rectangle in AutoCAD.

>> what i really one is to extract the length adn width from an excel file

So you need the info how to get access to an Excel file and read the values stored there?

I would search in Excel VBA forums then, as they handle Excel access. At least this depends on what Excel API you use, what Excel version is installed (or how to do if no Excel is installed). All that has nothing to do with the AutoCAD VBA forum here.

Or do you already have some code for reading XLS-file(s) and you get some error or so? Then please show the code and mark the position at which you are currently or something fails.

Good luck, - alfred -

[Anonymous]

I actually figure this out but thanks for your response.