magicalclick's Q&A profile

• Microsoft ISV Community Center Forums Fastest Processor for Running Excel VBA Macros

  i have written a series of complex VBA macros in excel as part of a system to generate hundreds (even thousands) of data reports from large data sets. on my old desktop (p4 @ 3.2; 3gb ram) some of the macros take hours to execute - i even let them run overnight. i wanted a new computer that could run them in much less time. so we invested 5k in a new desktop (dual core xeon @ 2.8; 4gb ram; twin 15k rpm hard drives). i ran a simple macro for 1 minute on both computers - the new one is about one third SLOWER than the old. my hypothesis: processor clock speed is what determines the speed at which a macro runs AND the fact that it's ...Show All

• Visual Basic Loop without Do Error - End If

  Hey all. Can you help What am I missing in this section of code This exact bit of code runs just fine in one 6 of my spreadsheets, but it hangs up in a spreadsheet that is pretty much identical. When I break the loop and hit debug, it goes to the End If line near the end of the code. I have changed the structure of the if statements, and then I get a Loop without Do error. I am going insane. Thanks. Sub DeleteWorthlessRows() Dim i As Integer i = 3000 Application.ScreenUpdating = False Do     'this loop deletes irrevalent rows between rows 7 and 3000     i = i - 1     If Cel ...Show All

• Visual Studio Express Editions C# and Sql Server Express Edition, Using Visual C# Express Edition

  Hello! Doing some C# and trying to access my db. Following a book from Wrox: 'Wrox's SQL Server 2005 Express Edition Starter Kit' - they use VB - there is my problem. How would I translate the following to C# Dim PKvalue As String = FilterInput.Text; // Filterinput ar en textbox DIM Rowlocated AS DataRow = Me.MyDBDataSet.Person.Rows.Find(CType(PKvalue,Integer)) If Not ( RowLocated Is Nothing) Then MessageBox.Show(CType(Rowlocated(1),String)) Else MessageBox.Show(PKvalue & " record not located" ) End if I tried out the Converter from VB to C# : http://www.developerfusion.co.uk/Utilities/convertvbtocsharp.aspx But that di ...Show All

• Visual Basic Transparency seems impossible in Visual Basic 2005 :..(

  Hi, I've been using VB 6.0 in the past, but .gif transparent images were too limited in colors, and .png seems so much better. So I got the beta 2 edition of Visual Basic 2005 (free off Microsoft's website, nice surprise!). The thing is though, transparency like on the image I attached above doesn't seem possible. The transparent pixels just show the form background, not the other image below. Am I missing something here I was wondering what the best way (that's still simple for someone who hasn't programmed in a while, hehe) to make it work In VB 6 a transparent text layer worked perfectly. So for example I could have giant "RELOAD" te ...Show All

• Software Development for Windows Vista Installing Windows Workflow Foundation Beta 1

  There have been several threads with questions about installing Windows Workflow Foundation Beta 1.  I'm hoping to summarize the installation instructions for anyone else that might be having trouble.   These instructions are also available on the WindowsWorkflow.net community site here .  James Conard Architect Evangelist - Windows Workflow Foundation http://www.WindowsWorkflow.net http://blogs.msdn.com/jamescon -------------- Windows Workflow Foundation Beta 1 is compatible with the .NET Framework and Visual Studio 2005 Beta 2 (builds 50215.44 & 50215.45). Windows Workflow Foundation Beta 1 is not co ...Show All

• Windows Forms ToolStripItems: how to duplicate?

  In my scenario, I have a context menu which should show additional sub-menus from loaded plugins. As I want to use the visual designer (not create the menus each time in code), my problem is how to copy some ToolStripItems from a ToolStrip menu to another. What's happening on simple copy (enumerating in first menu and adding to second) is that the items are removed from the source menu on copy (I assume the Owner changes so the item is automatically removed from the source owner). ex: ctxMenuDestination.Items.AddRange(ctxMenuSource.Items) does not work, as copying removes them from the source collection and gives an enumeration error. Betwee ...Show All

• SQL Server error of Initializing SQL Server Reconciler has failed using SQL Server CE 2.0

  hi, i'm using SQL Server CE 2.0 in my application. When i try to synchronize my database by calling replicator.Synchronize(); errors :   Initializing SQL Server Reconciler has failed. process could not connect to Distributor SQL Server does not exists and access denied. what i did right now is i try to register regsvr32 "C:\Program Files\Microsoft SQL Server CE 2.0\Server\sscerp20.dll" regsvr32 "C:\Labs\NorthwindTempFiles\sscesa20.dll" both of the DLL files were succeed register. However, when i try to re-do the synchronization. The same error still happened!!! I do not know what's going wrong..=( Who can help m ...Show All

• Visual C# Is it possible to add separators to a StatusStrip using Visual Studio's Designer?

  Hi all, is there a way to add separators to a StatusStrip using Visual Studio's Designer The designer only offers StatusLabel, ProgressBar, DropDownButton and SplitButton to add to the StatusStrip.   However, if I add a ToolStripSeparator manually in the *.designer.cs file, it works fine...     Best Regards Bernd Ritter It should work just fine. StatusStrip derives from ToolStrip . In actuality the status controls that you can drop onto the StatusStrip are actually just ToolStripItem -derived classes. In theory you could drop them on a ToolStrip and have them wor ...Show All

• Visual FoxPro how to SET DEFAULT TO "running program's dir" ?

  Please Help.... <SET DEFAULT changes the default directory to the directory you specify. MicrosoftR Visual FoxProR searches for a file in the default Visual FoxPro directory. The default directory is the one from which you start Visual FoxPro.> If A program called “DISP.EXE” displaying customer.dbf installed in a directory Created by user, then how to tell the DISP.EXE to look for the database (customer.dbf) The problem is if   SET DEFAULT TO “C:\PROGRAM\DISP.EXE” Then it only run at that location. How to make it run at any location (directory) prefered by the user   Thanks so much! Joe Hi Joe, In your ma ...Show All

• SQL Server Query Designer Toolbar

  I have added the Query Designer toolbar to my Management Studio environment. After open a new query window this toolbar stays greyed out. How can I use this toolbar with my queries Thanks, Hello CRdesigner, The only thing that should be greyed out from the toolbar should be "Change Type" button. Other buttons should still be available for you to use. The "Change Type" button has been greyed out intentionally. We are hoping to bring it back in future versions. You can use "Change Type" if you bring up a Query Designer from Visual Studio. Thanks! ...Show All

• Windows Forms Cntl - A or Cntl-F in a multiline text box

  Why can't I use either in a multiline text box.  Cntl-A is most important for me, rather than having to click at the top and scroll down the whole text. dennist685 Hi, I just sent you a mail containing the project that I tinkered with. Try tweaking it and to find out what part of your code is missing... BTW, got a problem on sending a rar file to gmail. So I removed the extension. Just rename the file to .rar upon downloading.   cheers, Paul June A. Domag ...Show All

• Visual Basic Copy a locked file.

  I have a application that locks a file when it is open. While the application has the file open I am not able to perform a copy on the file. Notepad is not able to open this file as well. Is there a means to override this lock and make a copy of this file. Thanks Mark Baird It is an application that we purchased that is locking the file. It is a text file in which we would like to generate a checksum using Perl through some code automation using a file watch in VB.NET. The file watch waits for the ceation of the file when the user saves the file. Mark Baird ...Show All

• Windows Forms KEyboard Control

  Hi, Is there any customisable keyboard control that I can use in my application    I might need to customise it to remove a few keys, add new keys and change the functionality of a few keys.  Can I download code from somewhere  or some DLL may be  thanks,  I have a simmalar problem... is there a few lines of C++ code I could use to Disable the real keyboard for the durati ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Device Lost Problem

  I am having a problem with losing the device that I'm not sure about. The window can be minimized, lose focus to another app, and be resized with no problem. The problem occurs if in WinXP the user hits cntl-alt-del and then goes back (either by canceling or by unlocking later). The device can't seem to recover properly from this. Sometimes I can even continue drawing to the device after coming back but resizing it immediately breaks it (when you could resize fine before). Has anyone had this kind of experience and solved it Does somebody have a clear example in C# for how to handle the device lost, resize, and reset events cleanly in MDX ...Show All

• .NET Development APIs similar to RAIL

   Hello,            RAIL is a set of APIs to change (instrument) the assembly. Instead of using IL, it allows us to do the changes in an object-oriented way using c#.                                                                      &nb ...Show All