Hello, I need to pick your collective brains for advice.
I have a spreadsheet which serves as our block library, with categories, names, part numbers, descriptive info, .wmf images. Under each image is a cell with the block name. What I'd like to do is have the user "pick" on the block name cell, and pass the name to Acad for the insert command.
This the outline:
1) User opens block library spreadsheet via command or menu selection.
2) Insert command is initiated and paused for input.
3) User selects block by clicking block name.
4) Block name is passed to insert command.
I've looked at writing an Excel VB macro that would write the block name to a text file, and having lisp check for the file, read the string in it, then erase the file. But this brought up the issue of needing to automatically enable macros in the spreadsheet (to avoid the macro alert box) when the file is opened. I've never had to add a macro the signed, trusted source list before, it looks like a hassle.
I also need a way to make sure that only the block name cells are the only ones passed to lisp - the user might click on other cells in the spreadsheet, any of which may also contain text.
Any ideas? Thanks in advance!
Using vanilla Autocad 2002 & Excel 2002.