Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / Visual Studio.NET / Debugging / November 2004

Tip: Looking for answers? Try searching our database.

howto debug a dll that is latebound within VBA

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
pieter - 17 Nov 2004 15:29 GMT
Hi All,

I have a problem for which I am unable to find a solution myself. The
scenario is like this:

We have a slow-starting application (that has a VBA sub-system which
works the same as Word's VBA) for which we develop applications in VBA.
My current task requires me to develop a certain subcomponent in a C++
dll.

The VBA references the dll with a declare statement, ie it late-binds
to the dll.

When the dll is loaded (or its methods executed) the first time it
loads and works fine. However it seems as if this application then
locks the dll. When I try to rebuild this dll i get a "LINK : fatal
error LNK1104: cannot open file 'Debug/filename.dll'" error from Visual
Studio.

I presume that this is because the big application stil has a reference
of some sort to it and therefore I am unable to overwrite it.

Is there a way to overcome this problem? As I stated earlier the bigger
application is rather SLOW in starting so restarting it each and
everytime to release the dll this way is rather cumbersome. I am really
looking for a OS specific way of releasing the application's dependancy
on the dll.

Any comments or suggestions would be appreciated.
Friendly Regards
Pieter Breed
pieter - 18 Nov 2004 05:15 GMT
Hi All,

It seems I have solved my own problem. For those who are interested:

It seems as if the dll lock was kept by the specific VBA project which
I was working on.  Since there is a command line with which I can call
the VBA Sub from within the master application, it will work if I do
the following:

"vba load file; vba run function; vba unload file"

In this way the dll lock is released and I can recompile the dll from
within VS.

Friendly Regards
Pieter Breed

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.