It looks like you're new here. If you want to get involved, click one of these buttons!
Hi, the company I work for has recently converted from AutoCAD to BricsCAD (on my recommendation), they use a number of Lisp routines to make life a bit easier, while the majority work perfect, albeit with a little tweek here and there, one however is refusing to cooperate.
the operation is as follows, click a command button on the ribbon and excel opens a recently created data sheet, the issue being excel opens but to the front screen not the file, is this due to BricsCAD using .CSV rather than .XLS?
I should point out that all these codes were written by someone else 8 years ago and any alterations I have made have been using done the knowledge of other users on forums such as this one (due to lack of experiance with such things) up until now all has gone well but this has beaten me.
Here is the LISP code
(defun c:openxl (/ lst)
(acet-error-init (list '("cmdecho" 0) T))
(if (setq lst (acet-openxl-ui nil))
(acet-openxl (car lst) (cadr lst))
(setvar "tilemode" 0)
(setvar "filedia" 0)
(setvar "cmddia" 0)
(command "regenall" )
(setq a (command "script" "Iso2.scr" ))
(setvar "filedia" 1)
(setvar "cmddia" 1)
and here is the .SCR it points to
EXCEL.EXE "C:\Users\majhu\CAD\Iso Info\Cad 1\Iso.csv"
I dont have a copy of BricsCAD as my trial version ran out so I can't continue to experiment and I dont even have a copy at work as I am no longer part of the CAD division, however, the two people who are have no idea or interest and i get called in to set everything up and resolve any issues, they also dont believe in the phrase "just google it", so to maintain my title as miricle worker I require a little help.