rob_a89's Q&A profile

• Microsoft ISV Community Center Forums vlookup

  Hello can anyone help me with how to write the excel vlookup function in vba the function in excel looks like this VLOOKUP(O2,'[Consolidated list of supplier.xls]Sheet3'!$A$5:$F$218,6,FALSE) how can i get something similar working in a macro. thanks namrata Hi, How about some like this Dim rngLookupValue As Range Dim rngtable As Range Dim lngColIndex As Long Dim blnRangeLookup As Boolean Set rngLookupValue = Range("O2") Set rngtable = Workbooks("Consolidated list of supplier.xls").Worksheets("Sheet3").Range("$A$5:$F$218") lngColIndex = 6 blnRangeLookup = False vntResult = Application.WorksheetFunction.VLookup(rngLookupValue, rngtable, lngColI ...Show All

• Software Development for Windows Vista "Workflow Patterns" evaluation of Windows Workflow Foundation?

  Has anyone (familiar with the Workflow Patterns work of Dr. Wil van der Aalst) undertaken or is anyone considering a Workflow Patterns evaluation of Windows Workflow Foundation Please contact me. Michael Herman Parallelspace Corporation Workflow Patterns web site: http://www.workflowpatterns.com/ I found the following link in my own search. http://www.infosys.tuwien.ac.at/staff/urbanec/bpm_keynote.ppt. Keynote presentation on the Workflow Foundation by Dave Green ...Show All

• Visual Studio 2008 (Pre-release) Transforming a TXT file into XML with Linq to Xml

  Hi Folks, I am working on a Linq to Xml code that is intended to read a log file from IIS 5.1 and transform it to an XML file. The log file is saved in W3C Extended Log File Format, which looks something like this: #Software: Microsoft Internet Information Services 5.1 #Version: 1.0 #Date: 2006-06-23 12:37:18 #Fields: time c-ip cs-method cs-uri-stem sc-status 12:37:18 127.0.0.1 GET /cobrabca 404 12:37:25 127.0.0.1 GET /cobranca 401 12:37:25 127.0.0.1 GET /cobranca/ 302 12:37:25 127.0.0.1 GET /cobranca/ 403 12:37:30 127.0.0.1 GET /cobranca/Default.aspx 401 12:37:53 127.0.0.1 GET /cobranca/Default.aspx 200 12:37:53 127.0.0.1 GET /cobranca/_content/stylesheets/home.css 200 12:37:53 127.0.0.1 GET /cobranca/_content/clientScripts/navegaca ...Show All

• SQL Server Can I retrieve a result set from a sp into a variable within a Execute SQL Task?

  Can I retrieve a result set from a sp into a variable within a Execute SQL Task I have done it using the result set property for that. I guess you can do the same using a SP but may be you need to use the parameter tab of the Execute SQl task to set an output parameter that is mapped to the variable. ...Show All

• SQL Server Executing Package From Web Service

  Hi, I'm having another go at attempting to call an SSIS package from a web service. The Web Service is set up on the same server as the sql server and SSIS package deployment. When i attempt to run the pacage from the web service it starts and then inmediately fails. I can see this in both the Integration Service Logs and the event viewer. If i click on the package itself and run it using the DTExecUI, it runs without a problem. No logs are output by the package when called by the web service. Can anyone suggest anything that i could to see if i can diagnose where the problem stems from. Many thanks in advance, Grant Handling Package Events Programmatically ( http://msdn2.microsoft.com/es-es/library/ms135 ...Show All

• Visual Basic Add items to listbox

  Hello, I'm trying to make a project where when the user clicks btnCalculate an input box shows asking to input SPEED in miles per hour, followed by another inputbox asking for the amount of TIME in hours. It should then use a loop to display in a listbox on the form the distance the vehicle traveled for each hour of that time period. This is what I have thus far but I am stuck once again! This is an example of the output in the listbox: Vehicle Speed : 60 MPH Time Traveled : 7 Hours Hour        Distance traveled 1             60 2             120 3     &nbs ...Show All

• Visual Studio Class not registered - DTSConnection

  I have created a number of reports on my local machine which work well. These have been incorporated into our web site. When the reports are run on our development machines they can be seen. When we made the site available on our web server then the error “Class not registered – DTSConnection” is given. I have not been able to solve this problem. Can any one help Server Error in '/' Application. Well... as a Crystal Developer, this is another new nightmare that I faced recently.. But, this one unlike the others was able to be solved with ease... In my case ----------------------------------------------------------------------------------------- Server : Windows Server 2003 Reprot Application ...Show All

• Smart Device Development Is any sample for reciving sms in C#.Net?

  I try to develop a program for my PPC for receiving sms and do some operations on them. But the only sample that I found was for eVC++! I need the C# sample. Please help me! What do you mean "receiving" If you want to see the SMS messages that have already arrived to the client, you need to use Microsoft.WindowsMobile.PocketOutlook namespace on Windows Mobile 5 or IntheHand.PocketOutlook namespace on WM 2003. If you want to be able to intercept incoming SMS, on WM5 use Microsoft.WindowsMobile.PocketOutlook.MessageInterception namespace. On WM2003 you need native code - C++. ...Show All

• Windows Search Technologies Enormous number of items to scan

  My indexing status shows 25,000,000 items left to scan and 19,000 indexed so far. I have chosen to index Outlook and My Documents (nothing unusually large about either). Is there a way to troubleshoot this I've resolved the issue by uninstalling WDS. I found that the disk queue length was permanently high until I stopped searchindexer.exe. What is irritating is that I now cannot search in Outlook, nor can I load Lookout anymore in Outlook 2007. Maddening. ...Show All

• .NET Development Nested Groups with Same Element

  Hi Folks, If I have an XML document with several nested elements (<g> elements in SVG for example) how do I match a particular node set within the document.  Say I wanted to match all nodes within <g id='match_this'> in the XML below. <svg>   <g>     <g id='match_this'>       <g>         <rect x="100" y="100" width="10" height="10" />         <rect x="300" y="100" width="10" height="10" />         <rect x="500" y="100" width="10" height="10" />       </g>     </g>   </g ...Show All

• Audio and Video Development Video Events

  How can I handle video events in the script For example, when new chapter started. Or when certain frame reached.     I'm confused. try { Player.video.main.capture(filename,VideoMainCaptureCallback); } Shouldn't it be: try { Player.video.main.capture(filename, VideoMainCaptureCallback(int status, String uri)); } To match the signature specified in Z.10.19.3 And also, I don't understand why the interface for that callback. Why pass the uri and status ...Show All

• SQL Server Monitor Jobs on SQL Server

  Hi, I'd like to know if I can monitor all the jobs in SQL Server 2000 or 2005 using SMO Objects. Specifically, I'd like to know if the jobs has been run, executed suceefully or not (recording to Log files). I also like to view/enumerate all the existing jobs. I'd like to know if all these are possible if I use SMO Object with Visual Basic.net.. If possible please give me sample code or web site so I can learn how to do it. Thanks for reading my post. Hi folks Now I have SQL Server 2000 & Visual Studio 2003 How can i Import this NameSpace " Microsoft.SqlServer.Management.SMO.Agent as well as the .SMO and .Common namespaces." which Reference i want to add this If its Not possible than How can i run ...Show All

• Visual C# Working with Excel files - MSDN let me down :-(

  Hi all, I'm having major problems accessing Excel data in files. I've found the following snippet which seems to work:                  Range range = firstSheet.get_Range("A1", "C3");                 //Retrieve the data from the range.                 Object[,] saRet;                 saRet = (System.Object[,])range.get_Value(Type.Missing);                 //D ...Show All

• Audio and Video Development WMP11 not giving mousemove events in full-screen mode

  WMP11 Beta breaks my application that works well with WMP10. I am using the WMP ActiveX control. I receive Mousemove events in full-screen mode in order to provide a custom control panel that appears when the mouse is moved. This works well with WMP 10, but in WMP11 Beta, I get no mousemove events in full-screen mode. Is this by design (although I can't imagine why), or is this a bug that will be fixed when WMP11 is released I need to know if I should find a way to work around this (no ideas yet) or if it won't be an issue with the release version. Any help on this issue will be much appreciated! I ended up working around the problem by subclassing the WMP window and checking for mouse move messages in my ...Show All

• Microsoft ISV Community Center Forums random letters

  Hi, I need help with a excel file. I have excel pro 2007 beta loaded. These are the questions. For a scoring system in horseshoes. There are 3 worksheets. On the 2 nd sheet when you click the green button on that sheet which runs the macro. It will randomly change cells D3-D11 column on the 3 rd sheet with 2sets letters A,A B,B C,C D,D E and matching cell colors on the 3 rd sheet column D3 through D11. So the matching letters and colors will correspond to be opponents in that round of play. Once any team is out after two losses. The cells in column D3 through d11 turn black letting you know you are Out of the game. I need on the next round to click the green button again. So team opponents can be picked accord ...Show All