Answer Questions

• nick5454 Selecting Data By....

  the color of a cells Is this possible Tiger Thank you very much for the replies. They were very helpful. =) Tiger This knowledge base article has a nalternative approach: How to use AutoFilter to filter records based on cell formatting in Excel http://support.microsoft.com/Default.aspx kbid=213923 - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Techni ...Show All

• pooya What about Sourcesafe now too?

  So Empower and Certified partners will not get Team System.  That also screws us up for Sourcesafe doesn't it I quote from the MSDN site ( http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnvs05/html/VSTmSysvsVSS.asp ):   The desktop-based nature of Visual SourceSafe 2005 lends itself well to scenarios where team members may need occasional remote access to files. However, it is not intended for day-to-day usage by a ...Show All

• ZAHID HUSSAIN12 Problem with VBA script

  Dear all, Can you please help me with the following problem I wrote a script to get the data out from the SQL Server and then format the cells. However, it seems it doesn't run the part B to format the cells. Any idea Thanks. 'Part A : Get the data from the SQL Server sqlstring ="select custid, custname from customer" connstring = "ODBC;UID=uid;PWD=p123;DATABASE=prod;DSN=HK0001" With ActiveSheet.QueryTables.Add( ...Show All

• byroman accessing VBA code from VB.net application

  I have a VBA code as a part of a front end MS Access application. I am interested in knowing how I can call a method in this VBA code from a VB.net application of mine Per our support engineer: I am not sure how you want to use this VBA code method. If you want to call this VBA code method like other methods or functions created in .NET assembly, it is not possible. The VBA code method is defined in Access ...Show All

• tfm_mike Migrating from VC++ 6.0 to VC++ 7.1

  Hi, We currently have VBA SDK 6.3 support in our product that is compiled under VC++ 6.0/SP5. When I compile the VBA code in VC++ 7.1, I get the following errors. We are using un-managed code in our application. Is there a patch or a newer version of SDK that I should be using   Is there a migration document that shows how to convert existing applications from VC++ 6.0 compiler to VC++ 7.0/7.1 compiler Thanks for your help, - Vittal Sriniv ...Show All

• vln cannot save file as

  I can't save any files on any of my other drives. The message comes up as save file not responding. Also szAppname:WINWORDEXE, szAppver:11.06568.0, szModname:hungapp. Why can't you ever get help from microsoft without a fee After all this is their product. Per our support engineer: Thanks for using ISV Community Forum. According to your problem, I’m wondering whether you are saving the Word document manual ...Show All

• Jim Lux XML view in IE

  Hi All, I am new to this forum and I am not sure if the following question has already been raised earlier. I have an xml file as follows: < xml version="1.0" encoding="UTF-8" > < xml:stylesheet href="styles.xsl" type="text/xsl" > <collection> <book> <index>1</index> <author year= "1990" > John Doe </author> <title> JavaScript &l ...Show All

• Baolong Chai Collating Data from Multiple Excel Sheets

  Hello, My manager has given me a project of collecting skills of all the employees. I have made and sent out a Excel sheet for employees to fill and send it back to me. It asks the Empployee to enter the following details Employee Name: Employee ID: Date of updattion: There is whole list of skills against which they have to Self Rating (Scale of 1 to 3) Mention the Level of experience (A,B,C,D) Training Undergone (Interna ...Show All

• Brian Hartman What's your experience with the buddy program?

  Started by admin at 03-28-2005 5:11 PM. Topic has 2 replies. 03-28-2005, 5:11 PM admin Joined on 12-16-2004 Posts 14 What's your experience with the buddy program We've already received a couple of posts on buddy experiences (thank you!) and would love to see more of them, so feel free to jump in and reply to this post and share yours! Thanks, Brenda [msdn/isv] ...Show All

• thelonesoldier What version of Team System do EmpowerISV members get?

  Current MSDN Universal subscribers get a free upgrade to their choice of one of the Team editions of Visual Studio 2005 when its released.  What about current EmpowerISV members   And what will future members get   I'm planning on joining the program, but I want to be sure I know what my team will be  getting long-term, especially as it relates to Visual Studio Team System. It'd be great to ...Show All

• Marc Derksen Return value from running a sql statement

  I have a SQL statement and a stored procedure that I want to throw a message depending on the success of it. What is the syntax I thought it was the following: Dim result as Boolean result = docmd.runsql " [SQL Statement/Stored procedure]" If result Then Msgbox ("success") Else MsgBox Err.Description & " " & Err.Number End If Please help jog my memory. ...Show All

• amit lohia 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 I dont see what this has got to do with writing a VBA MACRO AMD Athalon Windows xp SERVICE PACK 2 avg virus software All I need help with is to getr data out using a macro ...Show All

• roypython Problems when accessing a text file using ADO

  Hello, I am having trouble with some code and I was hoping someone could help me out. I am writing an excel macro that uses ADO to connect to a comma delimited text file and retrive data. The following are the problems I am having: 1. I have no headers in my text file, but it is being treated as if it had a header row when I fill my record set ( it automatically starts on row 2) how do I get it to look at row1 first 2. I am using "Mo ...Show All

• Ljubica Open a Word Document

  Hello i need to find out how to open a word document from my access database any one know a good solution. i have an ole object and you can drag and drop the file onto it but i need a way to have it load up in Word so it can be read/written/printed via word 2003. You can use Word objects to open a word document Make sure that you include the Word 9.0 Object Library and then add the following code Dim oWd as Word.application ...Show All

• ehanders PowerPoint, WORD, and Macros

  So I've read all about how to format a WORD document with Headings so that it comes out right in powerpoint slides. However, I have a 91 page document already done in it's own format and needs to translate each page onto a slide in powerpoint. Send to and all those things suggested from importing word to powerpoint don't work. So I figure writing a macro would work. Problem is, I don't know where to begin with it. I'm thinking page breaks ...Show All