Answer Questions

• Robert Neal Products Roadmaps

  I wonder if MSF does help to create, or at least to follow, a product roadmap... Or what is the best way to create a software product roadmap Ximena Per the product team: Yes, MSF v4.0 provides clear guidance on creating a vision statement for a product and planning a series of releases of that product based on prioritized functionality described in usage scenarios written around a set of persona ...Show All

• David_Som Executing an insert statement in VBA

  Hi, I have made an insert statement in the query. I'm having the correct result everytime I double click the query itself. However, when I put the query in the code and execute it. it does not work. Please Help... Thanks, PSD What application version are you using -brenda (ISV Buddy Team) ...Show All

• Fazeel Shaikh VBA WORKSHEET

  COMPILE ERROR END IF WITHOUT BLOCK IF Sub EnterDates() Columns().Clear Dim EilDownloadSheet As Worksheet Set EilDownloadSheet = Workbook.Worksheets("Name of worksheet") Dim startDate As String, stopDate As String, startCel As Integer, stopcel As Integer, dateRange As Range On Error Resume Next Do startDate = InputBox("Please enter start Date: format (dd/mm/yy)", "Start Date") If startDate = &q ...Show All

• The_Assimilator Excel::NetDDE and DDEShare

  Has anyone tried to link two workbooks running on different machines I found an interesting article on how this can be done -- http://support.microsoft.com/default.aspx scid=kb;en-us;128491 This is exactly what I want to do -- only problem I can't get it to work!! I am using Windows XP and Excel 2003. I have two seperate machines and I have enabled NetDDE on both of them. Also I know that NetDDE itself is working because I can use the Cli ...Show All

• bsmhis Changing Outlook email settings with VBE

  I would like to change the "Leave a copy of messages on the server " option in Outlook with Visual Basic Express. The Visual Basic Express code would change that setting for all or some of the email accounts. Ideally, it should be possible to do it on computers on a network. Does anyone know how this can be done Thanks, Antonio Hi Brenda, Thank you for your detailed reply. ...Show All

• xWindx oledb connaction display xml

  When I change my connection string from ADO to oledb my xml display is broken the error I go is wrong data type. I use ASP classic. Would you please help here. Thanks in advance! can you post the two connection strings, the original and what you changed it to. Could you post your query and some of the code you use to call the query. ...Show All

• Paul Mestemaker - MSFT Problems with BSM

  Hi! Now we're trying to deploy a BSM-project. There're some comments and maybe questions. First of all I want to notice bad work with localized systems. English version of BSM requests 1033-folders. But russian version of SharePoint doesn't contain this folder (only 1049). As result some pages looks incorrectly (e.g. there's a problem with css in the page filter editor). The second problem is that the page filter doesn't work with me ...Show All

• stemill ADOdb w/ SQL producing unspecified error (-2147467259)

  Following code snippet is called where UPSZone is an integer ranging from 1-4 and estWeight is a decimal value that is always 1 or greater. I get the same error using VB.NET with an Access2000 database, but only with one of many database calls, and then not always (mostly). If I run the VB app via the developer it never fails. I tried putting in waits (timed loops), but it makes no difference. Dim DBConnSN12 As OleDbConne ...Show All

• Icarrus Unable to publish scorecard to SPS

  Hello, In our dev environment, I'm set up both as admins for SharePoint and BSM 2005. I can create scorecards fine, and I can create SharePoint sites just fine. However, when I tried to publish a scorecard to the SPS site, it gives me the "An error occured while deploying the Scorecard to SharePoint. Make sure the Page Name, Site URL, and Document Library is valid" error. But, as I can see - the BSM wizard were able to read inf ...Show All

• kamran_kamaei Closing a dependent file in Excel97

  I am trying to set up programming for an Excel97 spreadsheet. Because the file (call it Alpha) takes a long time to save, I want to put the code in another file (call it Beta) and call it from Alpha. I have that figured out, and the references set up. The problem is that I want Beta to close automatically when I close Alpha. I tried putting a Close command in the Before_Close subroutine, but then I get an error message telling me that I cannot c ...Show All

• Donald D. Drake - MSFT Shared Addin using Word

  Hello Everybody, i have created a shared addin for word. i succeded with adding an item in the context menu of word (text context menu). The menu which appears during right click of a text. I did that thru adding an control button on "TEXT" commandbar which is for context menu thru addin. The problem now i am getting is the associated event for that command button which newly inserted is not firing. If i try to add the item in some other menus s ...Show All

• Tuan Pham Accessing Tables in Access 2000 that are linked from an SQL Server using VB code

  Hello, I am not sure if I am posting to the correct forum, but here it goes: I am trying to create an Access 2000 application to pull data from a table that is linked to a SQL Server Database using VB code. However, I cannot seem to get it to work, as I keep getting type mismatches and object not defined errors. I would post my code, but I have made a complete mess of it. Would anyone be able to show me simple code to accomplish setting u ...Show All

• Gary Katz VBA WORKSHEET

  COMPILE ERROR END IF WITHOUT BLOCK IF Sub EnterDates() Columns().Clear Dim EilDownloadSheet As Worksheet Set EilDownloadSheet = Workbook.Worksheets("Name of worksheet") Dim startDate As String, stopDate As String, startCel As Integer, stopcel As Integer, dateRange As Range On Error Resume Next Do startDate = InputBox("Please enter start Date: format (dd/mm/yy)", "Start Date") If startDate = &q ...Show All

• Sergey Okhotny Changing Outlook email settings with VBE

  I would like to change the "Leave a copy of messages on the server " option in Outlook with Visual Basic Express. The Visual Basic Express code would change that setting for all or some of the email accounts. Ideally, it should be possible to do it on computers on a network. Does anyone know how this can be done Thanks, Antonio Hi Brenda, Thank you again for your insig ...Show All

• AlexZakharov Distribute elements extracted from XML to ListColumns or Cells

  Hi, people I'm already get the connection using MSXML, rather than winhttpRequest in VBA code. The response that I'm obtaining for while just is displayed in specific cells. Well, when I do a simple query it's all O.k, the problem comes when I need to access many datas (from ISBN numbers), in this case what I've got it's only one item. Or be, I can't view the others datas from others books.. I already saw something to work ...Show All