vba (2,278)


vb6 - How to use a mutex in Visual Basic

I have imported the kernel32 library so I have the createMutex function available but I am not quite sure of the various parameters and return values. This is classic Visual Basic, not Visual Basic.N…


c# - Drag and Drop to a hosted Browser control

I have a WinForms program written on.NET 2 which hosts a webbrowser control and renders asp.net pages from a known server. I would like to be able to drag, say, a tree node from a treeview in my win…


vb.net - Equivalent VB keyword for 'break'

I just moved over to the Visual Basic team here at work. What is the equivalent keyword to break in Visual Basic, that is, to exit a loop early but not the method?…



Is there a way for MS Access to grab the current Active Directory user?

I'm working on a spec for a piece of software for my company and as part of the auditing system I think it would be neat if there was a way to grab the current Active Directory user. Hopefully someth…


user interface - Do you name controls on forms using the same convention as a private variable?

For some reason I never see this done. Is there a reason why not? For instance I like_blah for private variables, and at least in Windows Forms controls are by default private member variables, bu…


Refresh Excel VBA Function Results

How can I get a user-defined function to re-evaluate itself based on changed data in the spreadsheet? I tried F9 and Shift+F9.The only thing that seems to work is edit…


How to parse XML using vba

I work in VBA, and want to parse a string eg<PointN xsi:type='typens:PointN' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema'><X>24.365</X><Y>78.63</Y>…


c# - Office VSTO Word 2003 project keeps trying to autoconvert to 2007

I am working on a Office Word add-in for Word 2003. When I reopen the project, the VS2008 auto covert dialog box opens and tries to convert it to the Word 2007 format. How can I reopen this file and…


Alternatives to Visual Sourcesafe that integrate with Visual Studio

I am interested in dropping Visual Sourcesafe in favor of a version control application that offers branching. Sourcesafe's integration into Visual Studio makes checkins/outs a breeze. Can anyone s…


How can I represent a very large integer in.NET?

Does.NET come with a class capable of representing extremely large integers, such as 100 factorial? If not, what are some good third party libraries to accomplish this?…




excel how from access with and value net macro get