Answer Questions

• Tom Chen ActiveX RICHTX32.OCX

  I am using  the RICHTX32.OCX in a vba application.However, when I installed the program on a new pc with WinXP SP2 this ActiveX was different from the one on my SP1 machine.ThisActiveX was suddenly not allowed in VBA. Why Please, what is a "Microsoft Visual Basic 6.0 UserControl control", or where is it ... Thanks RESOLUTION If you design solutions for Microsoft Office, you must avoid using this control directly. If you have t ...Show All

• Ronalld 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 Hi Brenda, I'm trying to apply this macro you did, but in the line after "End With" it's been a sintax error. Would it be anything to include in references or troubles with the version I'm using Office2003. There an XML format ...Show All

• Amir19 Buddy hasn't contacted me yet...

  A few weeks (months) ago, I signed up for the Buddy program (great idea!). I got an e-mail stating that there were some matches several weeks after that. I picked a buddy from the list and got that confirmed. However, since then, I have not heard anything at all from my Buddy, who was (if I understand it well) supposed to contact me first. SA. Hello, Please send your name and email address to budsup@microsoft. ...Show All

• smart_saqib143 .NEt and industrial automation

  Hi all, I want to get information or links to read about combination the .Net framework on the industrial automation. I mean SCADA and HMI or OPC in . Is there any classes or components that deals with these issus s there and open sourse tutorials of these systems Regards... Per one of our internal support engineers: Our ISV buddy’s question: ===================== I want to get information or links t ...Show All

• faltopar After_Save Event???

  Hi to all. I have a problem. For some sheets, I set to invisible before save. Now, I need set to visible the sheets after save, but there aren`t a After_Save Event... How can I solve my problem Any idea Thanks & Regards. thanks * 100000...!!! you have save my life!!! hehe really thank you very much friend. Regards. thank you very very much!! now, I try do it. I hope that works. thanks ;-) ...Show All

• Fire2Burn Someone mind helping me with Error 426

  I am hoping that someone wouldn't mind helping me out here. I have a macro in Excel 2003 which I use to modify some data and then put it into MapPoint 2004. I noticed the memory usage for MapPoint jumps up to 175-180 MB when I initialize territories so I decided I would create a subroutine to close the program and then reopen it. Unfortunately MapPoint 2004 does not let you close a file, only the entire program (unless you are using "Map ...Show All

• amit_toney Application Error

  Hi experts, We have an application written in VBA. The application is failing with the following log entry in the event log. Faulting application: appname.exe Faulting Module: VBE6 Version: 6.4.99.72 Fault Address 0x000dc6f2 Event ID: 1000 The application is running on Windows XP SP2 with Office 2003 SP2. Help would be much appreciated. Thanks Steve Hi, The following is the code that was causing the a ...Show All

• Allan Kor XP style appearance

  hiya this might be the wrongplace to ask this question but on the computer the other day one of my kids deleted the windows xp appearance so all we are left with now is the rubbis windows classic appearance which is very boring i was wondering if anyone knew how you can reinstall or download the windows xp style appearance thanks phill phils right, ur reply was not helpful, i also accidentally deleted the w ...Show All

• Wanda Sue Microsoft Access Runtime/Developer (XP) - compatibility issue with XP SP2?

  I have software that I packaged with Microsoft XP Developer SP1 edition which  does not  function on Windows XP SP2 systems but ran fine on all prior operating systems. The wording I am getting when I launch the installer is: "Visual Basic 6.0 Setup Toolkit" "The Application you are installing requires updated system components. To continue, install the Office System Pack. For assistance, contact your applicaton provider" Is there ...Show All

• Michael Xing - MSFT VBA 6.4 now available on MSDN Subscription

  We now can download VBA 6.4 from MSDN Subscription. ...Show All

• Aneo Creating AD user with profile & home directories

  I am using Excel VBA to create AD users from a spreadsheet of names. I can create the users in the correct OU and can add the home drive and profile path to the user object. However, unlike when creating the User from the "AD Users and Computers", the folders themselves and the relevant permissions are not created automatically. Creating the folders themselves will be no problem, but how can I then assign the correct security permissions to the ...Show All

• Steini Deployement project build ERROR - URGENT!

  Hello Everyone, I wrote a little program in C# to read and write from a ms access database and I wanted to create a deployment project. I followed the wizard and included Documentation, Source, Debug, and primary files to the Setup project. also under detected dependencies I added the Microsoft .NET framework and System.Data.SqlClient.dll. BUT when i try to build it it gives me this warning: Warning 1 Unable to find dependency 'SYSTEM' (Si ...Show All

• theBiscuit Left Joins with Multiple Conditions in VBA

  Hello, I am trying to run a query in Excel VBA. The query has a left join with a two conditions -- every time I run it excel crashes. If I remove the brackets enclosing the two conditions, the query fails. The query itself is correct because if I run it directly in Oracle it works. Also I can run it thru excel via Date->Import External Data but not thru VBA. Also if I restrict myself to one condition instead of two it works thru VBA. Any one ...Show All

• Tomas Martinez Outlook tasks - how can I see them?

  Hi everyone, I was wondering if there was an easy way to connect to MS Outlook and get a list of the users tasks... Any sample code would be greatly appreciated. I think I need to add a reference to Outlook 11 object library... or is there a totally different solution to this. Any help is appreciated. Thanks. Per the support engineer: Try this. using Outlook = Microsoft.Office.Interop. ...Show All

• CindyKansas work localy with database

  hello, i have a database on the network and when i run a function with many queries it works really slow. is there a way to copy the database to the local computer, make the queries and continue working on the database on the network other users also work on the network database so it's important that the file stays linked to that DB. please help... refael You can keep your existing Access database and move the tables to S ...Show All