Answer Questions

• GalenC Installing VBA6.0 on XP

  Good morning and hello.   Ages ago I received a SDK 6.1 containing the latest release of VBA 6.0. I happily and without problem installed this on my laptop running Windows ME and all was well. I have since updated my laptop to one running Windows XP Home and when I went to install the SDK I was confronted with an error stating that "....You first must install Microsoft Visual Basic 6.0 Service Pack 3 to install the VBA ...Show All

• TheShark What is the difference between SET and Assigning a value to a variable?

  Hi, Can anybody advise what the difference between SET and assigning a value to a variable Example: Sub NewWorksheet() Dim ws As Worksheet Set ws = Worksheets.Add ws.Name = "New sheet" End Sub =================== Set ws=Worksheets.Add vs. ws.Name="New Sheet" Why not just write ---> ws=Worksheets.Add ----- for the former Regards, Patrick Just to expand o ...Show All

• Nate52 Collections of control - evaluating the name of a control that has been "pressed"

  Hi, I have created a form in Excel, upon which is a multipage control, with a set of combo boxes placed on. One combobox is populated by a pre-defined list of text, which upon user selection runs a macro that defines the population of a second combo box.......like a choice - sub-choice set up. The user is able to add and delete pages to their requirements, which also add and deletes the combo boxes on each page, however the user will always be p ...Show All

• Mark Sonnier Help with interface?

  Hey Just completed my set of macros that i need to fully automate a process i am responsible for in work.  However, i am a bit lost as to the best way to run them i.e. link them to buttons in excel etc.  Is is possible to design some sort of interface in VBA and have it load with the spreadsheet    Normally i will be recieving a spreadsheet containing reams of data which have to be sorted and updated.&nbs ...Show All

• vinnisharma Roll-up KPI indicators to Objectives Doesn't work

  Hi, I'm working with a Balanced Scorecard with several KPIs and Objectives. I have two datasources (Cubes), one for Targets and another for Actuals. The Scorecard View has a filter of time. With the Roll-Up option selected, if there is an error (empty value) on Actuals column on only one of several KPIs above an objective, this objective doesn't show the roll up indicators. Can anyone help me Per the ...Show All

• Beaulieu accessing IPTC metadata

  Hi! How can I manipulate IPTC metadata of jpeg-files in VBA Many thanks for your help in advance! Armin Per one of our support engineers: How are you Let’s talk about following issue about IPTC header in JPEG File. Actually, there’s no build-in API in VB6 to handle JPEG header, nor the Windows API. The common way to handle this issue is to parse the JPEG files in binary. Here are my suggestions regarding ...Show All

• AnthonyEY never heard back

  I signed up... never heard back. I do widows forms in C# in Dallas. .V SiSTeR Technologies is seeking a Visual C++ Guru with a strong background in Microsoft DirectShow Editing Services to take our media generation platform to the next level. Successful candidate will be familiar with the inner-workings of Windows Media and most of the Microsoft APIs and toolsets related therein. See examples of our ...Show All

• basedissonance How do you test a user's input for alphabets?

  Hello programming gurus! Is there anyway to test if a user's input contains only alphabets Thank you! Wonderful! Thank you Derek and Chris! Hmmm. Okay. I'm not really code savvy but can I simply use it like this Do while variable <> "\p{L}" STUFF Loop Thank you. Thanks Chris. Is there code to tes ...Show All

• Kevin Rodgers Application Deployment Problem using GPO

  We have a domain migration process going on. A new AD -domain has been established. The problem is that when we try to use old domain’s server’s folder as a software installation point, system accounts on new domain’s client computers do not have access to these shared folders. Group policies can’t then install anything. Domains have two way trust relationship. "Everyone" has read rights as well as "domain computers" of ...Show All

• Ranjan VBA Information.

  Is it possible to write code so that when I click on a Excel Workbook Icon, it will load up other workbooks as well. I have several Workbooks I access on a daily basis for work and I want to just open one documnet up rather than 6. I have already created the Buttons for the other Workbooks but can not get the coding right so that it opens the workbook up when the button is pressed. I hope that makes sense. If not, reply and I shall try and word ...Show All

• NewScience Speed up processing time Excel Macro

  I had some questions about Office and performance. I would like to figure out what specifically will affect the runtime of macros in Excel. Currently this user has a Dell Optiplex GX520 with the following specifications: IntelR PentiumR 4 Processor 640 with HT (3.2GHz, 2M, 800MHz FSB) 1.0GB DDR2 Non-ECC SDRAM,533MHz, (2DIMM) 80GB SATA 3.0Gb/s and 8MB DataBurst Office 2000 Pro She is running macros in large Excel spreadsheets (30 - 60MB) that ...Show All

• Kevin Remde Does the VBA save word as XML???

  Hello! I'm really needing to know if there's any VBA code able to save a Word document as an XML doc. Any sample is appreciate. thanx Marcos Hercules dos Santos Looking at it again, there are a few other methods you could try Search in the help for... ExportXML() and SaveAsXMLData() You'll see something called XmlMaps, I believe this is a Schema mapping that describes what you want to export. There ...Show All

• V-P Macros - Excel

  Hi, I have made a macro for a project which i am working on. I have to run this macro every week on different files. These files have names which include the date of the data. Now without overwriting this file i want to run the macro but want the date of this file to be included in the final file which i have made. Is there anyway to do this for eg: Data file : Name : ABC 10-3-06 i want the final output files name to be : XYZ 10-3-0 ...Show All

• Simon Detheridge Read data from excel through VB.NET

  Hi friends, I need to read symbols(like ALPHA,BETA,MEU) from excel and show it in a data grid through VB.NET.Later insert it into Oracle 8i DB. I am able to read entire data but i am getting 'a' instead of ALPHA symbol and 'b' instead of BETA symbol. I am querying excel via OLEDB provider.The following snippet is using for accessing excel. Dim MyCommand As System.Data.OleDb.OleDbDataAdapter Dim MyConnection As System.Data.OleDb.OleDbConnection ...Show All

• Aeneas117 Please Help with Access 2003 and ActiveX Controls

  Hello everyone, I am having a major problem and I can not find a resonable answer any where, so I hope some one here can help me out. I have been working with Access 2000 for a long time and have always been able to Insert the ActiveX control "Microsoft Common Dialog control, version 6.0". I now have made the jump into Office 2003 and Access 2003 which when I try to Insert the ActiveX control "Microsoft COmmon Dialog control ...Show All