Bwilhite's Q&A profile

• Visual Studio Express Editions opening file error

  Dim oXL As Excel.Application Dim oWB As Excel.Workbook Dim oSheet As Excel.Worksheet Dim oRng As Excel.Range ' Start Excel and get Application object. oXL = CreateObject("Excel.Application") oXL.Visible = True ' open selected workbook oWB = oXL.Workbooks.Ope n(openfiledialog1.filename ) I am getting :- HRESULT : 0X80020003 (DISP_E_MEMBERNOTFOUND) COM exception error I am guessing it doesnt know what (openfiledialog1.filename) is and I dont know how to fix it..... Openfiledialog1.filename is called in sub button1_click...... I have tried declaring it globally but that didnt work.... If anyone can point me in the right direction, I would appreciate it.......... ...Show All

• Visual Basic Operand Errors in Visual Studio 2005

  I am trying to make a calculator when I go to do the * button, clear button or even the + button I get blue lines under the word Operand1 or if I type to go past that and type [Operator] it gives me blue lines under that word and says I cant go any futher cause it has a error. Anybody know what I am doing wrong :( Private Sub Button8_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button8.Click Operand1= TextBox1.Text() [Operator] = "*" TextBox1.Text = "" End Sub or Private Sub Button13_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button13.Click Operand1 = TextBox1.Text() [Operator] = "+" TextBox1.Text = "" End Su ...Show All

• .NET Development Static methods behind the scene

  How static methods work inside CLR Is it similar to the old C++ architecture with a single copy of the method for all instances How member functions work/represented inside CLR Yes, static methods belongs to type, not to instance. And they are located in another then instance methods, let's say, "table" inside the CLR. For each class there is a "Type-object" inside the CLR. This object contains all the information about the type and all the static methods are located in it. For each instance CLR creates an "instance-object" which contains instance related data (properties, methods) and the reference to the "Type-object". You can read Jeffrey Richter's book ...Show All

• Microsoft ISV Community Center Forums Marking a location for return

  Once upon a time I had a macro that would mark a spot within an MSWord document, with a second macro that would return the cursor to that marked spot. I would like to recreate these two simple macros. Any ideas as to how to go about doing this Thanks in advance. Hi, No idea if this is what you had before but using the macro recorder I generated these 2 routines. Sub MarkSpot() ' ' MarkSpot Macro ' Macro recorded 31/01/2007 by Andy Pope ' With ActiveDocument.Bookmarks .Add Range:=Selection.Range, Name:="MySpot" .DefaultSorting = wdSortByName .ShowHidden = False End With End Sub Sub ReturnSpot() ' ' ReturnSpot Macro ' Macro recorded 31/01/2007 by Andy Pope ' On Error GoTo ErrReturnSpot Selectio ...Show All

• .NET Development "Metadata file 'System.Runtime.Serialization.dll' could not be found" during dynamic compilation

  Good afternoon, I am trying to write code that takes metadata from a running WCF service (knowing only the service's address), and using that metadata (after running it through a wsdlImporter and xsdDataContractImporter) to compile an assembly that (hopefully) contains the data contract object used by the web service. However, when the code reaches the "CompileAssemblyFromDOM stage, the compilation fails, leaving the message "Metadata file 'System.Runtime.Serialization.dll' could not be found". It's really rather annoying, since the file in question is one of Microsoft's (and in the GAC, for that matter). The code I've been using is as follows: System.ServiceModel.WSHttpBinding binding = new WSHttpBinding(); MetadataExchangeClient ...Show All

• SQL Server SSIS Dynamically Naming Output Files

  I've just started using SQL Server 2005 Integration Services and I've come up against a situation where I need to name output files dynamically (i.e. based on a timestmap). Looking through this newsgroup, and other web resources it looks like my only option is to use a Script Task/ActiveX Script Task to rename the file after it has been created with a generic file name. I was wondering if there was a different approach or if there was a way to pass in a variable to the file connection manager that I could append to the file name at run-time. Thanks Bill You can use a variable in an expression, as applied to the connection string property of your connection, e.g. @[User::FilePath] + "\\" ...Show All

• .NET Development VS 2003 in 64 bits server

  Please, somebody can help me ... i get this error when i try to view a crystal report (VS 2003 web app) in 64 bits server Invalid export DLL or export format.  Thanks, VS 2003 is a 32bit application you need to enable 32 bit on IIS for it to work. cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1 ...Show All

• .NET Development TransactionScope and Jet OLEDB

  I'm doing some POC work on System.Transactions and I am having some difficulty getting it to work via OleDb with the Microsoft Jet 4.0 OleDb provider. I can use DBTransactions just fine against my test database, but if I try to use TransactionScope, I get an error message stating that the ITransactionLocal interface is not supported by the Jet OleDb provider. However, I found the following on MSDN http://support.microsoft.com/default.aspx scid=kb%3Ben-us%3B221071 that claims that Jet 4.0 does support ITransactionLocal. I am going to try against MySql, but didn't want to get to far in to this if System.Transactions only supports SQL Server (which, so far is the only DB I can get it to work against). Thanks ...Show All

• Windows Forms Controls position on window resizings...

  Hi all, I have a WinForm that has a DataGridView, TextBox, ComboBox, ListBox & 2 buttons on it... how do I get the layout to stay the same or the DataGridView to resize it self to the current window size with out it all being out of sight in the From Thanks. ...Show All

• Visual Studio Express Editions Error 80040154

  I have this problem with a form that I created. FrmPrint.MdiParent = Me FrmPrint.Show() Everything worked fine, then suddenly I get this error System.InvalidOperationException was unhandled Message="An error occurred creating the form. See Exception.InnerException for details. The error is: Retrieving the COM class factory for component with CLSID {27CE30A0-91FF-101B-AF4E-00AA003F0F07} failed due to the following error: 80040154." I have never seen something like this. I didn't change anything to the frame for it to do this. The other 48 forms in this project still works fine. I tried to remove the form and redo it, but the I kep on getting the same error with the new form. I did this again and gave the ...Show All

• .NET Development ID process of my application ?

  How can i receive unique identifier of the process of my application Hi Andy, try the following code: Process currentProcess = Process .GetCurrentProcess(); int processId = currentProcess.Id; Andrej ...Show All

• SQL Server SQL 16-bit client tools install fails

  I get an error during the SQL 16-bit client that I grabbed from the SQL 6.5 CD and I'm installing onto a Windows 2000 SP4 Server. I choose TCPIP from the Network Protocol dropdown, that's the only option I change. First error pops up with the DSHELL in the title bar: An error has occurred in you application. If you choose Ignore, you should save your work in a new file. If you choose Close, you application will terminate. I click on Ignore and get the following error with Application Error in the title bar: DSHELL caused a General Protection Fault in module MSCUISTF.DLL at 0003:1FA2. Choose close. DSHELL will close. I saw one post on another forum regarding the same exact thing but on that board it went unanswered. ...Show All

• Architecture Record Locking / Conflict Management Approaches

  We have an application wherein all screen will open up in seperate tabs. The question is since all the screens open in tab mode how does one handle record locking i.e. One user opens the record for modifying and does not close or save the changes made, another user opens this records for processing. How can this situation be handled One way I was thinking of is to have a conflict management in place where in discrepancy in records edited and the one fetched from the database would be alterted and user would be asked for a decision. We can find out which is the latest record by maintaining custom version numbers for each record. Any thoughts on this pls. -Sai That's the basic reason for implementing locki ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Help Needed Building first XNA Xbox 360 Game

  Third Infantry Productions Project Code Name - Anarchy: Brief description: Have you ever wondered what it had to have been like living in America's infancy It's 2020, terrorist have attacked America leaving few survivors. The main land has been destroyed, and the capital is still burning. All branches of the government have been destroyed. Who will lead their group to topple the terrorist and restore Diplomacy in America Target aim: Platform and PC ---- M Rating (Violence, Language) Compensation: Royalties and the thrill of starting a cultural phenomenon!!! Technology: Microsoft XNA Game Studio, C++, Maya, Poser, 3d Max, Cinema 4d, Lightwave, MS Net Meeting, Open GL, Open AL, Fruity Loops, Cubase Talent needed: 1.Lead Pro ...Show All

• Windows Live Developer Forums Hide the scalebar in V3?

  I am working on upgrading from V2 to V3 and notice that I can no longer hide the scalebar I tried guessing around with the MapControl.Features to figure it out, but no dice. Any ideas In the virtual earth SDK they have a code to add a Hidhe and Show button. If that is what you want here is the code <html> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <script src="http://dev.virtualearth.net/mapcontrol/v3/mapcontrol.js"></script> <script> var map = null; function GetMap() { map = new VEMap('myMap'); map.LoadMap(); } functio ...Show All