Answer Questions

• Henrik Viklund Copy and Paste Values

  I cannot figure out how to copy and paste as values using VBA without acually selecting the cells when I paste and using the same code the macro recorder generates when I record a copy and paste as values. What would be the code for copying cells a1:a10 and pasting as values in cells b1:b10 without selecting the cells range("a1:a10).copy Then what Hi Joe, Here's some info from our support engineer: ...Show All

• Brent Neufeld 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

• walking fish Reading text file and accessing specific columns in VBA

  I am new to VBA and I have some code that I put together that reads a text file. Now, I am trying to access the columns in the line I just read. I have scoured the web and cannot find column manipulation with the way I have set up the I/O. Should I be using another way to read the file I would rather use this code but if there is a better way I would love to know. Any help is greatly appreciated. here is the code Sub balance() Const FI ...Show All

• John and Jack Selecting Data By....

  the color of a cells Is this possible Tiger Thank you very much for the replies. They were very helpful. =) Tiger ASAP Utilities ( http://www.asap-utilities.com/ ) is a free Excel add-in loaded with lots of useful tricks. One of them is the ability to select cells based on color. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. ht ...Show All

• David Robinson How to become an ISV

  How to become an ISV what are the advantages of being an ISV and purchasing a MSDN Subscription what are the licensing Issues Having a MSDN Subscription and being an ISV can I deploy the developed applications to my clients How much should I pay to be an ISV and have a MSDN Universal Subscription (in Indian Rupees) Can an Freelancer be a ISV Can the Freelancer be a ISV and Work for a Company who is a MS Partner Please answer these questions in ...Show All

• Kyong Kwak Microsoft Platform Test for ISV Solutions & FxCop

  Hi, the Microsoft Platform Test for ISV Solutions site ( https://partner.microsoft.com/global/40010438 ) states that to pass the managed code component "All Application Assemblies pass analysis by FxCop without errors or warnings" does this mean: 1) all assemblies must pass with the default FxCop rules (not even microsoft application blocks manage this) 2) the FxCop rules file used for the test must be supplied so any customisations can be seen ...Show All

• AnotherRick Wildcards In Access

  1x1 1x1x1 22x11 22x11x33 In Access does anyone know how to filter just for records with just one "x". Like "*[x]*" -- returns all records. Like " [x] " -- returns only 1x1. Hi JooK, Good question I don't think you'll be able to do it by filtering directly on the value because it's not the value your filtering on, it's the number of times a character ...Show All

• Mark Warner Hyper link Macro

  I am new to this stuff. I want to add hyper links to a series of numbers.eg 100 101 102 103 etc There is a number folder for each hyperlink in excel. So the 100 hpyerlink will open the 100 folder and so on. I can do i Macro to do one folder. How to i get it to do hundreds without repeating myself. Thanks for you help, cheers Hi, thanks for the information, worked fine. However i dont think you h ...Show All

• Jdubya Empower program support for ISVs

  Is there any real support provided for ISV's in the Empower program Visual Studio 2005 introduced breaking changes in our application (integrated in Visual Studio) and we have not been able to get anyone to investigate thoroughly. We cannot even determine which developer group is responsible for the breaking changes. For one problem, we were asked to submit the problem to the support team for Windows Forms. Is there any support for Empower pr ...Show All

• Marek Istvanek Is an Excel bug that set PivotItem.Visible to true will generate 1004 Macro Error?

  In a Excel PivotTable, I want to programically hide or show some PivotItems of a PivotField.  To hide, it works fine (just set mPivotField.PivotItems("xxx").visible = False).  However, to show, it does not work: mPivotField.PivotItems("xxx").visible = True.  Program breaks with an error 1004, macro error. When try to record a macro for setting a non-visible PivotItem to visible, macros recorded is to use ...PivotItem("xxx").visi ...Show All

• Galen Murdock close excel when finish

  hi, i am importing files from excel to access. the problem is that when i finish importing the excel process (in task manager) is still running. is there any way to terminate the process from VBA i tried "close" and "quit" mothods and it's not working. this is my code: Public Function ImportFile(xlFile As String, tbl As String) As Boolean On Error GoTo errorHandler Dim ObjXL As New Excel.Application Dim ObjXLBook ...Show All

• Luke Liu 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

• RajKS 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

• Sebastiang showing userforms in html format

  Hi everyone, I am currently using VBA in excel and I want to display my userforms in a html format, so users can use it. Can anyone help me please Also, is it possible to open my macro without having to open excel and then go to the visual basic editor Please help me!!!!! G.Holmes Hi, Sounds like you need to create a web page. Displaying VBA forms as HTML is a bit impossible. You an run macros without having ...Show All

• Pierre Berkaloff 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