Thanks for you two (TheTick and EEnd)
I've deployed my library on all machines and register it with
regsvr32 tool, (because my library is a VB6).
And now its works perfectly.
For you question Eric, yes I was trying to have my DLL on a local server with different access path depending on the...
Nobody has enough knowledge in VB to help me in my issue ?
I thought that I was the only-one to write macro usable in different countries and languages ...
What are your advises so ?
SW2007 SP5
Worksatation HP wx4300 2GB
NVidia Quadro FX 3450
Good Morning ;
In my macros, I'm using some home-made DLL.
I want that my macros aren't saved with fixed path on used DLL. Because, this macro are duplicated on different sites, and I want to manage them simply (eg : update by replace the swp file).
I tried to add this code ...
As I said in my previous post, when you are in the MS Visual Basic Editor, you click on the menu Tools/References.
Then you can chech the box which correponds to the library MS Scripting Runtime.
SW2007 SP5
Worksatation HP wx4300 2GB
NVidia Quadro FX 3450
I would erase (or rename to be able to rollback) th registry key :"HKEY_LOCAL_MACHINE\SOFTWARE\SolidWorks"
Win+R -> regedit -> the access the key -> rename it
And try to re-install
SW2007 SP5
Worksatation HP wx4300 2GB
NVidia Quadro FX 3450
Ok, sorry to forgot that.
In fact, I use Dictionary (by reflex) because it's more efficient that simple array.
You only need to add an reference (Tools/References) which named "Microsoft Scripting Runtime"
This will make macro able to use this library, then Dictionary object.
SW2007 SP5...
We have this problem since long time ago (2007 SP0).
We are all working over a gigabit network.
The problem occurs on different workstations and in the same 2-3 days. Then we haven't the problem for 15 days.
Sometimes the problem occurs even if SW is accessing to only local files.
But, in...
fcsuper ;
sorry for my bad English but, I don't understand what you mean by "Autoloading".
The icon is loaded dynamicly. Is that what you wanted to say ?
In my case, I use the same picture for the button toolbar and the icon in title bar.
For your second question, I really don't understand ...
Spurs ;
I'm not sure that I understand what you want to do. But as I understand your needs, I advise you to use Excel API.
In oder to do that, you can add as references of your project the "Microsoft Excel X Object Library".
Then you'll able to do same actions than Excel VBA permits you...
Thanks TheTick,
That's what I've ever done, but I think it isn't clean ...
Whereas it works on Excel, I don't understand why it doesn't on SW ... !!!
Ho ! Thanks for your tip about DoEvents that I didn't know ; sure it's useful ...
SW2007 SP5
Worksatation HP wx4300 2GB
NVidia Quadro FX 3450
Hi,
If you want to add an icon in your VBA UserForm ; the same one than your button in toolbar for example.
You can add this code in UserForm's code.
Add this code at the begining of the code
' first we declare some external used functions
Private Declare Function FindWindow Lib "user32"...
Hi ;
All is in the title.
On a macro with one UserForm, I want to catch some keyboard events.
EG : Escape key to end the macro.
I tried to use "Private Sub UserForm_KeyPress( ByVal KeyANSI As MSForms.ReturnInteger)" but unfortunatly, it doesn't work.
I copy/paste my sub on an excel macro, and...
Thanks TheThick.
I've ever thought to this solution, but didn't want to do it, in oder to manage only one code.
Unfortunatly, it seems to be the only solution.
Thank you still.
SW2007 SP5
Worksatation HP wx4300 2GB
NVidia Quadro FX 3450
Hi evrybody ;
I've developped an standalone executable to process many files with Visual Basic 6.
Now, I want to re-use the code and forms that are already written to make an integrated macro which will process the current opened model in SW.
But when I try to import the form in the SW IDE, the...
