Visualbrin's Q&A profile

• Visual Basic Run a macro with .Net

  Hello! I just wonder how can I run a macro with .Net I have an excel workbook and I need to open a workbook, run a macro, close the workbook... My code actually opens the workbook and runs the macro, but the instance-thread doesn't stop running... If I execute the code three times so I'd have 3 instance of EXCEL.EXE running I really need a solution .... I w onder these post could help! Thanks a lot. ---------------------------------- The code: Private Sub runMacro() Dim oExcel As Excel.ApplicationClass Dim oBook As Excel.WorkbookClass Dim oBooks As Excel.Workbooks Dim fileName As Object = "c:\MYFILE.xls" Dim updateLinks As Object = 1 Dim macroName As ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Managed DirectX 9.0 Deployment via VS 2005

  I have been researching this question on the net a few days and have not had much luck. I have a project that uses DirectSound to play WAV files and I want to include the DirectX redistributable files in my install. Some of my users apparently do not have DirectX installed and are having issues running my application. (These users are using Windows 2000 without the latest service packs in an environment where they do not have an internet connection.) I found a Managed DirectX 9.0c bootstrapper package that was made in 2005, but it no longer works with the latest August 2006 DirectX redistributable files. The bootstrapper package interfaces with the Visual Studio 2005 bootstrapper, and enables the author to check a box for Managed Dir ...Show All

• Visual Studio Crystal X1 and VS2005

  Hi, I have installed VS Team System for Software testers which comes with Crystal Reports 10 by default.I want to the developers to use Crystal Reports 11 in the VS2005 designer instead of Crystal 10 because in our production environment we have Crystal 11 runtimes installed.What do I do Also on a side note can somebody expalin to me the difference between Business Objects XI and Crystal Reports XI.Are they two different products Thanks. Rafeeq. HI, To do this, install Crystal Reports XI and then Update it to R2 to make it compatible with Visual Studio 2005. Download the patch: http://www.businessobjects.com/products/reporting/crystalreports/compatibility_vs2005.asp Business Objects XI, ...Show All

• SQL Server Report Parameter viewer

  Does anyone have a control that can just view/update values of Report Parameters Basically the microsoft control without the report body. ...Show All

• .NET Development how to add a user control dynamically ?

  Hi guys, Is there a way that i can add a user control to a page dynamically Since dotnet code has to be pre-compiled, if i add the control dynamicaly it gets rendered only after the page is rendered. Is there anyway to handle this infact im doing some study abt fusebox technology, but i think it only applies to cold fusion... regards, Abhi Hi, Yes, you can add it to any object, like a table or any other container. Check for the "Controls" collection on the destination conatiner. ex: YourCell.Controls.Add(YourDynamicControl); Does this help Cheers ...Show All

• Microsoft ISV Community Center Forums Forms Text Input

  Hi All... I have an EXCEL workbook with two sheets A & B On Sheet A i have a Display Page with Various vlookups from Sheet B ... I created a Form which has a text box '1' with a number which is taken from Sheet A (a3) & an other empty text box '2' which is also taken from sheet A (comments d5).... What i need is a string that takes the text that is inputted in t extbox2 on the form finds the number which is on textbox 1 on Sheet B and inserts the text in same row but in the a different column of sheet B . I hope u can help me ...cos i am going nuts !!! Here's a quick script I whipped up that will do what you want. You'll need to tweak it a bit to make it fit your needs exactly. Ba ...Show All

• SQL Server Building/Running a Package.

  Hi, I have a solution, and I have a few projects in this solution. Each project has a few packages in them. The problem/question I have is this: when I am working on one of the packages, I have only this package open. When I try to run/test this package, every single package in every project gets opened, recompiled/rebuilt before my current package gets to run. It's very frastrating and time consuming. Is there a way to somehow disable this weird behavior Is there a way to just build the package I am currently working on Please, help. Thanks, Victor. This behavior occurs if you configured the project to build deployment utility - unfortunately, opening package was required for this. You may sw ...Show All

• .NET Development List of MSIL instructions?

  Hi A list that describes all MSIL instructions, does such one exists Kind Regards Hi Frank! That what exactly what I was looking for, thanks! ...Show All

• Smart Device Development stop " Turn off device if not used for .. "

  Hello .. I am tryin to make alot of program like a player .. I face a little problem .. For examble if the user set his device to turn off if not used for 3 minutes , the pocket will turn off after 3 minutes and stop the program and stop the player .. I want to stop this function and return it after closing the program .. How can i do it .. with my best regards ,, tmn You can register for WM power notification events and choose appropriate action for your application. Go thru this MSDN article http://msdn2.microsoft.com/en-us/library/aa373195.aspx (mostly C++). You can also use State & Notification Broker to achieve the same. Link here http://msdn2.microsoft.com/en-us/library/aa455748.aspx ...Show All

• Visual Studio Express Editions ListView Scroll Vertical

  I just would like to know how to make my listview having a Vertical Scroll and not the Horizontal ! I think you may have to use Win32 ShowScrollBar: http://msdn.microsoft.com/library/default.asp url=/library/en-us/shellcc/platform/commctls/scrollbars/scrollbarreference/scrollbarfunctions/showscrollbar.asp example (unsure if this will work) //top of class, just after class declaration: [DllImport("user32.dll")] public static extern int ShowScrollBar(IntPtr handle, int wBar, int bShow) //method to show the scroll bar: ShowScrollBar(this.listView.Handle, 0, 0) hope it helps in some way! ...Show All

• Windows Forms get pictures from server in windows form

  Hello, I would like to get several pictures (depending on user input) from a web server and display them in one of my windows forms. I will have the absolute path to the pics on the server. Can anyone tell me how to connect and bring them across to the user's machine so that I can display them in my form Thanks! RC Hi, using just PictureBox, the code would look like: pictureBox1.Load(" http://forums.microsoft.com/library/toolbar/3.0/images/banners/msdn_masthead_ltr.gif " ); Look for LoadAsync() method for loading images asynchronously. Andrej ...Show All

• Windows Forms ClickOnce through Proxy with Authentication

  Hello, I have a problem with ClickOnce Deployment: My app runs on Windows Server 2003, IIS 6. In my university we have a proxy which needs authentication, and if I click the .application file, first there is a login window for the proxy, then the window ("verifying application...") comes up, but then there is an error message, saying that the file *.application can not be downloaded. In the log file is an entry: the server is unreachable, so I think the process which downloads the .exe and the other .dlls don't know the proxy authentication information. what can I do, to run the application behind such a proxy thanks, marco Which port is ClickOnce using if you know the port, you can configure the firewall / proxy properly (provi ...Show All

• .NET Development Get the LastModified date of the application

  Is there any way to programmatically determine when the running exe was last modified absolutely :-) you can try this: FileVersionInfo theVersionInfo = FileVersionInfo.GetVersionInfo(Application.ExecutablePath); MessageBox.Show(theVersionInfo.FileMajorPart.ToString() + "." + theVersionInfo.FileMinorPart.ToString()); ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Managed C# performance loss.

  I caught some people quoting managed performance loss at only 2% (over unmanaged). I am just curious how accurate that assessment is. Last time I was looking into it, DX programmers were quoting 90% of managed performance as a BEST case scenario. (usually much lower) If the margin has grown so low, is there any large scale games developed using C# This is an ever returning question. I am a real C# fan simply because it is easy to use :) A language like C# does not make you worry about pointers etc which enables you to focus on great software designs. In the end having a good design might be most important especially in the context of a game which tend to become exponentially complex as they grow in si ...Show All

• Windows Forms Sending a new form to a hotmail account

  Hiya, I'm trying to send a form which I've created to a hotmail account but when I do it just sends a blank email to the hotmail account instead of my form!! ! What do I need to do to get my form to send properly Please Help!! xXx The basic of sending a email are the following: MailMessage message = new MailMessage( " jane@Domain11111.com ", "ben@ Domain11111.com ", "Quarterly data report.", "See the attached spreadsheet."); SmtpClient client = new SmtpClient("my.Mailserver.netname"); client.Send(message); HTHs, James ...Show All