VladAll's Q&A profile
Visual Studio Tools for Office Print an excel file
Hello I wonna print an existing excel file. But i have always an error with my code "Code: Dim wb1 As Excel.Workbook wb1.Workbook.Open("C:\Brandstoffen Van denbrande-VanRoie\Mazoutprijs-ingevuld.xls") DirectCast(wb1.Sheets(1), Excel.Worksheet). _ PrintOut(From:=1, To:=1, Copies:=1, Preview:=False) Why doesn't work this Or have some ...Show All
Smart Device Development Name Resolution
I'm really newbye on Device Emulator. That's my problem: I have to use ActiveSync with a server for what i cannot have a certificate. I would like to us local PC host file to map "server.domain.com" to another IP address so that the certificate I have for "server.domain.com" could be used for that Sync. I don't know if the certificate will function well, but my first problem is: how does the Device Emulatro resolve netw ...Show All
Visual FoxPro Time format saved a character field
Hi, Can somebody pls help me figure out how am i going to compute the time format such as this one "05:32:44" saved in a character field. The output should also be a time format not like this one when i'm summing up all the records "190:119:255". The time is in this format Hour:Minute:Second. I will appreciate very much if somebody can help me on this. Thank you in advance You can use conversion fun ...Show All
SQL Server How to check if row exists...
Hello, I'm SQL Server 2005 newbie, could you be so kind and help me how to write the most efficient way stored procedure, which checks by PK if specified row exists, then updating the row, otherwise inserting new one. Thank you for your kind help. If EXISTS(select 1 from MyTable where MyPK = @PKValue) Insert else Update ...Show All
Visual Studio Team System Associating server folders with comment.
Hello, Is there any way that I can associate a server folder with some text properties or comments or anything like that Thank you, Hello Martin. I want to associate development branches with "Software Change Request" numbers. I have a simple structure: $/TeamProject/Mainline $/TeamProject/Branches For every change request I branch the mainline into a directory in Bra ...Show All
SQL Server How do you export SQL 2005 Maintenance Plans?
I am in SQL management studio right now and I have created a maintenance plan. However I see no way of exporting that maintenance plan so I can install it on another SQL 2005 server. I would normally expect to right click on my maintenace plan and have the ability to import or export, that feature is not there. Infact I have found that there are a lot of features missing from management studio, in general it lacks a lot of the right click functi ...Show All
Visual Studio Team System WEB unit test in TFSBuild and TestrunConfig
Recently i'm 'analysing' Team build and the configuration to eneable Web tests and web unit tests aswell on Local machine, as on the dedicated Build server. I have two separate testrunconfig files for the two environments. When i run tests within the solution on the client machine everything works fine. However, when i try to run a team build, WEB unit tests fail because team build is looking in the <TFSBuild>_precompiledwebsites directory ...Show All
Visual Studio 2008 (Pre-release) Do I need WSE3 if I have WCF
Do I need to download and install Web Enhancements Version 3.0 if I have the latest version of WinFX (Windows Comunication Foundation) thanks Ralph For now, I have a sample called SecureService on this link: http://www.dasblonde.net/PermaLink,guid,190eae14-9f0d-42b4-b27e-69af5bfcec9c.aspx It illustrates wshttpbinding with windows, then username with a custom provider. You have to uncomment ...Show All
Visual J# System.InvalidOperationException Every Time I try a particular Web Reference
Greetings Fellow J# Developers! I am currently working on a project which requires me to make references to the Autodesk Vault Web API. This API apparantly at some point passes in an array of INTS or LONGS. Although I cannot post the code from their end (on account it is closed source), I can post my code that is generating the error (though I don't feel it will be of any help). I posted this to the Autodesk Vault user group, ...Show All
Smart Device Development Unable to Register COM/Activex in Windows CE .NET Emulator
Hello Sir, I want to register "OCX" control in Windows CE .NET Emulator. For that i copied "my.ocx" into the emulator. For registering, i opened command prompt and executed the command "regsvrce my.ocx".But i am getting the error "can't execute regsvrce.exe". How to solve this problem I need your help. Please Can you confirm if regsvrce.exe is in your image If not check your image settings (if y ...Show All
Visual C# System.Management (WMI) question
Hi, I'm new to this forum and C#, so I apologize in advance for any silly mistakes. I'm trying to rename a network interface using the System.Management namespace, a.k.a WMI. I'm pasting the code that doesn't work below. I'm using Visual Studio 2003, but loaded version 2.0 of System.Management dll. I'd appreciate any help. Thank you. static void Main (string args[]) { Console.Write("\r\n\r\nNew NIC Name: "); &nb ...Show All
Visual Studio Team System How can I get project list in VSTS Beta3 !!
I used the following code to get project list in vsts beta 2. But in beta 3, I can't find the 'BisProxyServices'. BisProxyServices bps = new BisProxyServices(); ICommonStructureService iss = bps.GetTfsProxy(Tfs, typeof(ICommonStructureService)) as ICommonStructureService; ProjectInfo[] projects = iss.ListProjects(); Is 'BisProxyServices' renamed or moved to different assemb ...Show All
Visual C++ message box
i have troubles with this code: #pragma once #include "gerenciamento_bb_mysql.h" using namespace System; using namespace System::ComponentModel; using namespace System::Collections; using namespace System::Windows::Forms; using namespace System::Data; using namespace System::Drawing; namespace form_050826 { /// <summary> /// Summary for interface_incluir_papel /// /// WARNING: If y ...Show All
Visual Studio Express Editions probing
Hi to all, I created a private assembly for example mydll.dll,and i didn't placed this dll in application folder.I placed it in another folder for ex dir1 in application folder in order to implement probing.my application is mydllclient.cs.I created a config file with code < configuration > < runtime > < assemblyBinding xmlns = " urn:schemas-microsoft-com:asm.v1 " > < probing privatePath = &q ...Show All
Visual Studio Team System How to link multiple work items quickly?
We've created 150 requirement work-items by importing from pre-existing Excel sheets. We then imported 350 task work-items from pre-existing MS Project. We now want to link each task to the related requirement. Linking them one at a time is a big effort. Is there any way to do this more efficiently It would be nice to be able to select tasks from a query result and paste the list of their IDs in the "Choose Related Work Item" dialog ...Show All
