Answer Questions

• Greg Shaffer What MSDN editions have non-English Windows XP?

  I have a client that wants me to test his VB6 application on various foreign language Windows XP installations. He's willing to pay for me to get the OSs to test on. I'm wondering what is the cheapest version of MSDN that has all the languages like the old MSDN Universal did. I assume the MSDN Operating System subscription is just English, right I would also assume that MSDN Pro doesn't have it since the old Pro didn't, right Does M ...Show All

• Montana16 How to read a URL?

  hi, i want to read a URL into an excel macro, ( it's asp page that i want to download to search for specific fields to store in the excel sheet) anyone could help Hi, Excel macros are very powerful and you have the freedom to use a lot of stuff there. So you may create a new instance of the Msxml2.XMLHTTP and gets a http response like in JavaScript or any other application. A sample code is ...Show All

• Nay Lin uppercase and lowercase letters made equivalent

  Is there a way in VBA for Excel to make uppercase letters equivalent to lowercase ones Otherwise, comparing strings of the same letters but different capitalization results in no match Thanks, Antonio no, character's A and a have completely different ASCII code/Unicode values. The compare method generally has a parameter to ignore case but VBA doesn't have that option. All I can suggest is ...Show All

• PederO Challenging Topic: Online Gaming Portals!

  This is one topic that I have not found any resources on. I am interested to know if any ISVs have actually designed any gaming portals, something similar to msngames.com or pogo.com, further to that, I am interested in knowing more about the architecture of such gaming portals. I hope architects be among those who reply ;) Hi, Unless some of the other community members can share their experie ...Show All

• zaidm EXCEL, VBA and DLL

  Hi, I want to put some of my VBA macros that I have generated for EXCEL into a DLL. I want to keep them in VB(A) language, do I need to use VB Studio to do this Many thanks in advance. ...Show All

• mluloh ListParagraphs collection in table

  When I run this code on a simple doc containing bullet list paras, some of which are in a table and some not, only the list paras outside the table are found. The first red line counts only list paras outside the table. The second count (in a table cell with a list) finds no list paras. Any ideas how I can rectfy this Cheers, Mark If vTab.Cell(1, gReqIdCol).Range.Characters.Count > 2 Then temp = Application.ActiveWindow.Do ...Show All

• Scott Lentz Help with DDEExecute

  Hello, I have created two excel workbooks called Server.xls and Client.xls. Client.xls has a button which when clicked executes the code below. Private Sub cmdSendCommand_Click() lChannelNum = DDEInitiate("Excel", "[Server.xls]Sheet1") sRequeststr = "[New]" DDEExecute lChannelNum, sRequeststr DDETerminate lChannelNum End Sub When the button is clicked in Client.xls indeed a new blank workbook ...Show All

• Jordy Boom Business Scorecard Manager 2005 Beta 2 Setup

  Hello All, While running setup for the Business Scorecard Manager 2005 Beta 2, when I get to the feature requirements analysis under web parts, I get the message "Failed Microsoft SharePoint Extended Site" and I can't continue with the setup. How do I go about this in order to continue Regards, Sam. Given that there are quite a few questions around BSM, the product team has recently set up a blog with a common issues FAQ. Check it out on ...Show All

• JimSeidel Future of VBA (and VBScript)?

  We developped a number of tools in VBA or VBScript, sometimes using COM objects, and the large compatibility of VB, VBA and VBScript was certainly nice. We would no mind moving to .NET (the framework API being quite interesting), but it is not clear what is going to be the future for VBA and VBScript. Can we expect a VB.NET"A" and a VB.NET"Script" Thanx! Nice to hear this. I am unclear on what the migr ...Show All

• duck123 Needing Transform XML in Excel

  Hi, I'm head over heel s with this problem I'm trying to obtain some results with Excel to display XML datas. I don't know if this is possible. The question: I'm trying to apply a XSLT transformation on a XML file.  This same XSLT file takes as parameter another XML file (node set).Then  It merges the > two XML files. I already did transformation in Excel with one XML and one XSLT and it was all OK. My fil ...Show All

• ReinerP Dump data into 2 databases automatically

  Is there a way to dump data into 2 databases automatically So when I enter in data through an MS Access Form, it loads the data into a Table in that database, and then also loads the data into another Table in another database (or Excel file) Essentially, single entry to dual tables. Thanks, Mark Hi Mark, Yes the ...... represents something else you should be putting in. The thing is I cannot comp ...Show All

• Arun Sivaraman VBA HELP ON WORKSHEET

  Hi Im trying to get data out of an excel file using a input box with column A - M WHEN YOU ENTER IN THE DATE IT SHOULD RETURN THE ROWS OF DATA THAT IS IN THE ROW OF THE OPEN DATE COLUMN Per the support engineer: We have standard questions we ask every time and they usually save us and our partners a lot of time. Please bear with me as I gather the information I need to work with. The ...Show All

• Kenia Access 2003 Printer Settings

  I'm trying to set the printer, paper size and source tray via vba code. I can set the Printer using the following code Dim p As Printer For Each p In Application.Printers If (StrComp(sPrinter, p.DeviceName, vbTextCompare) = 0) Then Application.Printer = p SetPrinter = True Exit For End If Next p Though, when I set the PaperBin to anything, no matter which printer I have, it sets it to the first tray only. Should the command " ...Show All

• Rob Eisenberg Custom Date Picker Control

  I am developing a form for entering data into Excel and for some of the fields have dates as values. I really like the built-in date and time picker control for this, except that I want to be able to change the background colour of the part of the control that looks like a combo box. And that is simply not possible with the standard date and time picker. How can I get around this problem I have been trying to create a custom control to ...Show All

• andy72 a big thank you!

  Hi All, I just wanted to express my thanks to Derek and all of you who have stepped in to help your fellow coders! It takes some time on my end to escalate these questions and I'm so glad that many of you are getting answers to your questions more quickly with the help of other community members. - brenda (ISV Buddy Team) Hiya Brenda, I have thought about it yes. Last time I read about the MVP program it mentioned that it w ...Show All