eggnog's Q&A profile

• Visual Studio Tools for Office batch conversion of excel files

  I have a directory with excel 2003 documents that I want to convert to 2007 and also apply some conditional formatting supported by excel 2007. Can I implement an add-in to excel that opens a 2003 excel file, upgrades it and saves it again Is there a smarter way of doing this Thanks. /Nikolaj Hi Nikolaj this forum is specific to the VSTO technology. Since your question involves working with Excel files and the Excel object model, it would be better to ask it in an Excel-specific group http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.excel.programming&lang=en&cr=US To answer your basic question, yes: Any COM Add-in (whether programmed in .NET or anoth ...Show All

• Windows Forms Hard Disk Drives Count

  Dim Fxd = IO.DriveType.Fixed For Each Fixed In My.Computer.FileSystem.Drives.Count.ToString Next is this right Function DiskDraw() For Num As Integer = 0 To My .Computer.FileSystem.Drives.Count - 1 If My .Computer.FileSystem.Drives.Item(Num).DriveType = IO.DriveType.Fixed Then DiskGraph(Num) = New Label : With DiskGraph(Num) .Parent = DiskBox(Num) : .BorderStyle = BorderStyle.Fixed3D .BackColor = Color.FromKnownColor(KnownColor.Control) .Location = New Point(6, 16) : .Size = New Size(94, 8) End With End If Next Return Nothing End Function in the yellow color are there any suggetion! ...Show All

• Visual C++ How to show HRESULT in messagebox

  Hi all , How to show HRESULT in messagebox. Your help would be appreciated. -Rups You can use this function to get the complete error description: CString ErrorString(DWORD err) { CString Error; LPTSTR s; if (::FormatMessage(FORMAT_MESSAGE_ALLOCATE_BUFFER | FORMAT_MESSAGE_FROM_SYSTEM, NULL, err, 0 , (LPTSTR)&s, 0 , NULL) == 0 ) { /* failed */ // Unknown error code %08x (%d) CString fmt; CString t; fmt.LoadString(IDS_UNKNOWN_ERROR); t.Format(fmt, err, LOWORD(err)); Error = t; } /* failed */ else { /* success */ LPTSTR p = _tcschr(s, _T('\r')); if (p != NULL) { /* lose CRLF */ *p = _T('\ 0 '); } ...Show All

• Visual Studio Team System vsmdi relationship to TestCase/TestMethods

  I am trying to determine how an entry inside the vsmdi file relates to a test case method. Each test case item in a test list appears to have a unique Guid and the relative path to the assembly that the test case belongs in. However it does not list the test class that the test case belongs to. This information is visible when viewed from the test manager, but does to appear to be stored on the filesystem. Does anyone know how this relationship is maintained Yep, thats' it cracked. To summarise what is required, here's a bit of C#: SHA1Managed crypto = new SHA1Managed (); byte [] bytes = new byte [16]; Array .Copy(crypto.ComputeHash( Encoding .Unicode.GetBytes(className + '.' + meth ...Show All

• Windows Live Developer Forums How do I Add on Information to the Maps?

  Hi, My biggest problem in programming maps is just how do I implement features like traffic, or other things into the map I know the sources of RSS feeds,GeoRSS feeds, but I don't know how to implement them. OK, so it sounds like you need to post the pertinent code so we can look at what you're trying to do and where it is failing (or point us to your page if it is external-facing). It sounds like you're not trying to do anything beyond what you can do with the current API, so there must just be a little glitch in your code somewhere. ...Show All

• Visual Studio Team System Confused about install requirements.

  Hi, I have been reading the posts w.r.t install requirements for VSTE DBPro RTM. I have a MSDN Universal subscription and hence have VSTE SP1 installed. That is what came in my MSDN subscription. My understanding is that I can't install VSTE DBPro RTM. Is this right I suppose my first thought is how can this be Then my second thought is how can I get VSTE DBPro RTM installed without changing my install of VSTE (because I need it work, i.e. no trial jazz). There seems to be some confusion between what the read me states and CTP6 -> CTP7 changes. Can someone clarify the install requirements for MSDN folks Thanks, -Allen Alle (and Mickey), Thanks for all your help! I re-read the readme.h ...Show All

• SQL Server Function Compiling Error 2005(2153)

  Hello! I have scalar function which calls from stored procedure. When SP recompiling (before start) in profiler I see Exception "Error: 536, Severity: 16, State: 5" - Invalid length parameter passed to the SUBSTRING function. at next line of function (original text changed for easy sample) : if @p1=4 set @s1=substring(@ipstr,1,@p1-1) but at same line like: if @p1=4 set @s1=substring(@ipstr,1,3) works good. Somebody can explain such I think you should proivide full repro with variables declaration and initialization. Don't forget to mention MSSQL version you run this script on. ...Show All

• Visual Basic AutoCorrect inellisenseoptions

  Hi, I am struggling to find out how to get that brown colored underscore thing that comes in intellisense, To better explain Use this you will get a brown colored underscore at the end if integ Dim a as integ The problem is I have seen that brown underscore appear several other places, not just keyword error It prompted me to rename my variable names, Can anybody tell me what are the otherways you get this options Autocorrect was something introduced in 2005 and there are a lot of different errors where it will give you options to correct. As far as a list goes, I couldnt find one in the documentation and I only know that there are a lot because I spoke to the Developer of the f ...Show All

• .NET Development USB COM port error

  Dear experts, I am building an application to operate a USB modem, I am currently using VB.NET Studio 2005 and .NET runtime version 2.0. The working: Use a WMI query "SELECT * FROM __InstanceCreationEvent WITHIN 1 WHERE TargetInstance ISA ""Win32_PnPEntity""" to monitor the device insertion event on USB port. Use another WMI query "SELECT * FROM __InstanceDeletionEvent WITHIN 1 WHERE TargetInstance ISA ""Win32_PnPEntity""" to monitor the device removal event on USB port. When the insertion event fired, create a new SYSTEM.IO.PORTS.SERIALPORT class as an communication interface to allow users to operate the modem. When the removal event fired, close and dispos ...Show All

• Smart Device Development Small help..

  Hello here is the attached code i used to send SMS and i got this from MSDN as a sample. But it sends class0 sms, can you please edit the code to send class1 or normal sms. I think the provider specific class has to be changed but i couldnt do it properly. So please help me, thanx a million inadvance. File: SMS.vb ---------------> The class used to send sms Imports System.Runtime.InteropServices Imports interopserv = System.Runtime.InteropServices Public Enum SMS_ADDRESS_TYPE SMSAT_UNKNOWN = 0 SMSAT_INTERNATIONAL SMSAT_NATIONAL SMSAT_NETWORKSPECIFIC SMSAT_SUBSCRIBER SMSAT_ALPHANUMERIC SMSAT_ABBREVIATED End Enum 'SMS_ADDRESS_TYPE Public Structure PhoneAddress '/ <summary>The address type.</summary> Publ ...Show All

• Smart Device Development how can i view HTML content

  how can i view HTML content in textbox You would need to create a custom textbox which can show complex HTML content to do that. Or, you could use WebBrowser control instead. ...Show All

• Visual Studio 2008 (Pre-release) XAML Paging control

  Could any one can explain how we can achieve the paging / Custom paging / Page break functionality in XAML. Is there any predefined control like DataGrid in .Net 2.0. Thanks and Regards Gobi N This forum is for the WPF Designer in Visual Studio. A good forum to ask questions about the WPF runtime is the WPF forum: http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=119&SiteID=1 mark ...Show All

• Visual C# linux application

  Hi to all, is it possible with visula studio to develop a compatible linux application and if i have to use DirectX sdk library wich is the best solution thanks Teo Hi, adding some words to Mark's post to say that the .Net 1.1 is fully supported under Mono and some of the 2.0 version is also supported. Version 3.0 is also being developed. There's also a project for cross platform managed graphics, but it's for the XNA framework. I don't know many details about this project but you can check it here: http://www.taoframework.com/Mono.Xna ...Show All

• .NET Development Column not located is automatically assigned an index of 0

  Howdy, I am writing an application that (in the Reader's Digest Condensed version): looks for new files and if it finds them, looks at the data contained therein, compares it to the data in a database, and if it finds new data, updates the database. This actually works! But only when the file is formatted a certain way. I ultimately will have three different types (formats) of file. Each type contains different data and so has different column headers (fields). So (for example), the first type contains the following fields: Sample&Date NO3 NH3 Dilution Flag and the second contains the following: Sample&Date OP Dilution Flag etc. Right now, I am looping through the columns to determine the field name and determining wh ...Show All

• SQL Server Suppress multiple space to single space..

  How do we suppress multiple spaces to a single space in T-SQL E.G. Field: FullName e.g. WOMENS HEALTH RIVER VALLEY JOHN FAMILY MED GROUP HERSH STWEART P. PARK HEIGHTS MEDICAL CENTER KOPP WHITEFIELD E The o/p wanted is HERSH STWEART P. Thank you. Yog: One way to do it is something like this: -- --------------------------------------------------------------------------- -- If suppression of leading and trailing blanks is not needed, remove the -- LTRIM ...Show All