Help: VBA project open/locked when run
CADForums.net Forum Index CADForums.net
Discussion of AutoCAD and other CAD software.
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web cadforums.net
Help: VBA project open/locked when run

 
Post new topic   Reply to topic    CADForums.net Forum Index -> VBA
Author Message
Kevin_Van
Guest





Posted: Mon Mar 28, 2005 7:46 pm    Post subject: Help: VBA project open/locked when run Reply with quote

A person in the office created a VBA project that is our shared menu interface to the office blocks library & layer tools. It gets launched by a lisp from a toolbar. The problem is when the first person initiates the menu, that person has it open (locked) & it can't be edited until they exit AutoCAD. Is there anyway it can launched & run but not opened/locked?

If this helps, the following is the lisp that first runs the VBA project:
(defun c:URSCL()
(setq OLDCMD (getvar "CMDECHO"))
(setvar "CMDECHO" 0)
(command "-vbarun" "G:/CAD-UTILS/VBA/CAD LIBRARY/URSCL.dvb!URSCL.StartMe")
(setvar "CMDECHO" OLDCMD)
(princ)
)

Thanks for any & all help.

Back to top
Chris Shoemaker
Guest





Posted: Mon Mar 28, 2005 7:51 pm    Post subject: Re: VBA project open/locked when run Reply with quote

Good question. What i've been doing as a workaround is maintaining a
seperate "development" copy of the project, and then overwriting the
"working" copy when I can (afterhours, etc).

-Chris

"Kevin_Van" <nospam@address.withheld> wrote in message
news:19625437.1112021234580.JavaMail.jive@jiveforum2.autodesk.com...
Quote:
A person in the office created a VBA project that is our shared menu
interface to the office blocks library & layer tools. It gets launched by a

lisp from a toolbar. The problem is when the first person initiates the
menu, that person has it open (locked) & it can't be edited until they exit
AutoCAD. Is there anyway it can launched & run but not opened/locked?
Quote:

If this helps, the following is the lisp that first runs the VBA project:
(defun c:URSCL()
(setq OLDCMD (getvar "CMDECHO"))
(setvar "CMDECHO" 0)
(command "-vbarun" "G:/CAD-UTILS/VBA/CAD
LIBRARY/URSCL.dvb!URSCL.StartMe")
(setvar "CMDECHO" OLDCMD)
(princ)
)

Thanks for any & all help.
Back to top
TomD
Guest





Posted: Mon Mar 28, 2005 7:57 pm    Post subject: Re: VBA project open/locked when run Reply with quote

They way I understand it, you have to be sure unload the DVB after running
the routine(s).

"Kevin_Van" <nospam@address.withheld> wrote in message
news:19625437.1112021234580.JavaMail.jive@jiveforum2.autodesk.com...
Quote:
A person in the office created a VBA project that is our shared menu
interface to the office blocks library & layer tools. It gets launched by a
lisp from a toolbar. The problem is when the first person initiates the
menu, that person has it open (locked) & it can't be edited until they exit
AutoCAD. Is there anyway it can launched & run but not opened/locked?

If this helps, the following is the lisp that first runs the VBA project:
(defun c:URSCL()
(setq OLDCMD (getvar "CMDECHO"))
(setvar "CMDECHO" 0)
(command "-vbarun" "G:/CAD-UTILS/VBA/CAD
LIBRARY/URSCL.dvb!URSCL.StartMe")
(setvar "CMDECHO" OLDCMD)
(princ)
)

Thanks for any & all help.


Back to top
Laurie Comerford
Guest





Posted: Tue Mar 29, 2005 1:08 am    Post subject: Re: VBA project open/locked when run Reply with quote

Hi,

If you have developed a routine to the extent that you have deployed it to
the office, surely it should not need editing on a regular basis.

Make a copy for editing, and deploy "out of hours".

--


Laurie Comerford
CADApps
www.cadapps.com.au

"Kevin_Van" <nospam@address.withheld> wrote in message
news:19625437.1112021234580.JavaMail.jive@jiveforum2.autodesk.com...
Quote:
A person in the office created a VBA project that is our shared menu
interface to the office blocks library & layer tools. It gets launched by a

lisp from a toolbar. The problem is when the first person initiates the
menu, that person has it open (locked) & it can't be edited until they exit
AutoCAD. Is there anyway it can launched & run but not opened/locked?
Quote:

If this helps, the following is the lisp that first runs the VBA project:
(defun c:URSCL()
(setq OLDCMD (getvar "CMDECHO"))
(setvar "CMDECHO" 0)
(command "-vbarun" "G:/CAD-UTILS/VBA/CAD
LIBRARY/URSCL.dvb!URSCL.StartMe")
(setvar "CMDECHO" OLDCMD)
(princ)
)

Thanks for any & all help.
Back to top
Kevin_Van
Guest





Posted: Tue Mar 29, 2005 2:24 am    Post subject: Re: VBA project open/locked when run Reply with quote

Thanks for all the replies.
You're right - it's no big deal to live with. We have been doing the same workaround of keeping a master and deploying changes afterhours when warranted. I just thought there might be some command/process we don't know about to free it up after use.
Thanks again for the help.
Back to top
 
Post new topic   Reply to topic    CADForums.net Forum Index -> VBA All times are GMT
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




Windows Server DSP VoIP Electronics New Topics
Powered by phpBB