cad+excel generate a budget

[Richard.Vivanco]

Hi

I have a query, maybe simple for the experts.

This is a office furniture company that use blocks to draw their projects.  This blocks doesnt have attributes.

Right now they use a vba program,  it allows to select the blocks and then generate a budget in excel.  It uses the block name as a code and connect to an excel file that contain the list with the code, description and price of each block.   Then put the information in other excel that have  the budget template.

The problem is that the system is not consistent, it works fine in one machine but in other with the same version of autocad, office and windows it doent work, appears an error message.  And in the future when they change the version of the programs or SO, they will need a new compilation of the system.

So, my question is if exist another method to create a budget with cad blocks and excel.

Thanks

(sorry for my english)

[Ed__Jobe]

No matter what language/platform you choose, any custom solution to make Excel work with AutoCAD is going to require maintenance. Things will change and so the program has to change.

If you want help fixing the vba solution, more info is required. Can you report the error to whoever is in charge of fixing it?

[Richard.Vivanco]

Hi Ed thanks for your response.

Maintenance is very important, but im not sure if autodesk or microsoft will continue develop vba for the new versions of software and SO.

My big problem is that my budget system doesnt work in pcs with the same softwares versions.  Another limitation is that my system not allow to change the location of the budget file (xls), vba only allow to put the file inside the folder where the system was compiled

I attach some pictures to clarify. 

(* im not the developer)

[Ed__Jobe]

All those are solvable issues. Are you now going to fix the code? Are you asking for programming help?