Answer Questions

• Tomas Vybihal Microsoft Ecosystem

  Can someone explain the theory behind Microsofts ecosystem and how it benefits Microsoft and its Partners. Thanks I started to type an answer to this, but I realized that one of my colleagues addressed this issue quite exhaustively in his blog recently. (Sorry to plug a blog here, but it's really a long answer and this is easier): Part 1 Part 2 Some background: we're an ISV, and we've invested heavily in the Microsoft partner ecosystem. It helps us to gain VERY valuable contacts within Microsoft, and also helps us to meet other Microsoft-oriented ISVs, AppDevs, and SIs who may be potential partners. How does it benefit Microsoft Well, Microsoft has succeeded largely because people write sof ...Show All

• 13one Excel VBA - MS Query SQL

  I need to automate a procedure that changes an Excel 2000 query 125 times. Excel uses the first Query to get data from an Accsss 2000 database for statistical analysis and then creates a new SQL statement based on the results of that analysis - and so on. My question is so simple I hesitate to ask. I actually went through all 84 pages looking for the answer. It is: How do I copy the new SQL statement into MS Query using Excel VBA Edit Question 1/25/07 - After sleeping on it, I think the question should be: How do I open MS Query in SQL view With Excel VBA I am not an expert on VBA or SQL - I just sort of muddle through both. Cordially, John Harper   ...Show All

• mszlazak VBA w/ Word 2000 - keep form on top of all applications

  Does anyone know of a way to make a form stay on top of all applications or even on top of all open Word documents I want a form that stays on top even if I minimize its parent Window (the document from which it was launched). I want it to stay on top even if I click on another Word document. Is it possible I've used the SetWindowPos function, but as soon as I minimize the form's parent, the form minimizes as well. I've tried using the SetParent function and the GetDesktopWindow function to make the desktop the forms parent, but for some reason the GetDesktopWindow seemed to return the same handle as the form's parent Word document. Any help would be greatly appreciated. Hey Derek - Thanks for ...Show All

• IamHuM How to write a 'Find function' code in VBA for Excel

  Hi, I wrote this code in hope that it would look for the text string 'c6' which is found in one of the cells in range A1:C6. In the end I want it to assign the cell's address to a variable but one thing first. Function finn(x) 'x = Range(A1:C6) Dim y, q y = x q = Application.WorksheetFunction.Find(c6, y) MsgBox q End Function But it won't work! Anyone that knows how to write this properly Grateful for help on this \Jonas Thanks for the replay. Your start combined with some additional studie of the help solved my problem. You could use a foreach construct eg dim cel as Range foreach cel in Range(A1:C6) if x = "c6" then do whatever end if next cel that should find it for you ***The syntax i ...Show All

• Bryant Likes How to copy pivot table RESULT from Access to Excel

  I need to produce a highly formated pivot table report in Access and can only achieve so much. However, if I could programatically select the pivot table (equivalent of keys [Ctrl]+ ) then copy and paste into Excel, I can use VBA to format the report in Excel. My problem is that I cannot find a way to programatically select the pivot table in Access. I have tried Sendkeys "^A" as a last resort but this doesn't work. Exporting to Excel doesn't work either as it exports the pivot table, not the result . I'm having a similar problem with a large dataset. I can export smaller result sets, but the query I'm using has over 150,000 rows: too many for Excel. However, the actual pivot table result ...Show All

• sridhar kumar.j How Do I Set RecordSource in VBA to a Predefined Query?

  How Do I Set RecordSource in VBA to a Predefined Query For example... Me.RecordSource = qryAllUsers Does not work. Thanks, Dave Hey Dave, Do this instead... Me.RecordSource = "SELECT * FROM [qryAllUsers]" That was it, I knew I was missing something really easy. Thanks! Dave Is qryAllUsers a String containing the SQL select query text, or is it a QueryDef object RecordSource expects to be passed a String, not a QueryDef. If you're trying to pass the latter, it ought to be snagged as a compile-time error. Can you give any more information about how it "doesn't work" ...Show All

• SP534 NUMBER GENERATOR HELP NEEDED

  Hi, I'm looking for a letters generator from a to g. Or a numbers generator. 1 to 9. I have a scoring system for a horseshoe game I created in excel 2007 beta. I need the letters in column d3 to d13 to update once a round is completed. Which happens ok. But once a team is eliminated. I dont want a letter assined to the cell. If anyone could take a look will understand my issue. I will email you the workbook if you think you can help me out with this. I don't no vba yet but am trying to understand it. my email is trobert672@comcast.net Hi Derek, I try it out but I dont no what i'm really doing. I could send you the file to look at if needed Thanks again for your response Tom ...Show All

• Raphael Chan Digital Certificate Error

  I am trying to create a digital certificate. When I run Selfcert.exe I type in the name of the certificate. I get the error "An error occurred during certificate creation. Selfcert was unable to create your certificate". I am running XP pro and Office 2003. Any suggestions on how to fix Thanks. I have the same problem. Can somebody answer this. I've had the same problems with SelfCert. It appears to be broken. Follow the instructions on here instead: http://www.source-code.biz/snippets/vbasic/3.htm It worked for me. Adrian I spoke too soon. The certificate I created worked fine on my PC, but when one of my users tried t ...Show All

• Chyna440156 Search string

  Hello! I try to search a string for a certain combination of charachters. I have a column that contains the ID for different bonds. The ID contains the same info for all types of bond but with a some differences. Let me try to explain the syntax for the ID by giving some examples: ACGB 7.5 0705 T 4.25 0813 CAN 5.75 0629 CAN 2.75 1207 As you might see the sytax is like this: Name Yield Maturity. These three fields are ALWAYS separated by "Space". However as you can see the name and the yield can have a varying number of charachters. I want to single out the maturity (Always four digits, MMYY). My code now is: strMaturityDate = Mid(strSecID, 5, 2) but that does not work at all. Please help me! Thanks very much ...Show All

• Parvaneh ERROR RUNNING MARCO

  hi can anyone help me with this problem Hi can anyone help me with this problem I have this dos script to pass down a parameter upon opening the excel @echo off start excel "\\136.121.2.1\its helpdesk\ConRisk\RSP Concentration Risk Calculation.xls" /e/8212305557 Is there any code to capture the parameter "8212305557" on the excel macro upon opening here is my code Option Base 1 Private Declare Function GetCommandLineA Lib "Kernel32" () As String Dim CmdLine As String 'command-line string Dim Args As Variant Dim ArgCount As Integer 'number of parameters Dim Pos1 As Integer, Pos2 As Integer Dim sMsg As String Dim Customercode As String CmdLine = GetCommandLineA 'get the cmd-line string Cm ...Show All

• Charles Tam Change a formula in vba code, How do you

  Hi, I have a spreadsheet that adds each days purchases and each days sales et sums them, until the inventory is posted. The formula in each cell going down the sheet is like:=bi9+bf10, with bi9 having the current sum and bf10 having the current days sales or purchases. Lets say the next days formula is in cell bf11. I need to change the formula in bf11 to =bi11. Note: the store can post the inventory every day if they wanted to, so I have no way of knowing what line the current inventory is posted on, nor what day of the month it corresponds to. Below is the code for the Deli department inventory sheet with the lines in yellow that need to change the formula. All these lines of code do at the moment is erase the formula becaus ...Show All

• Sol of Solitude VBA sheet using registered dll functions across a network

  Hi, I've developed a VBA project, using functions in a user-defined dll that I developed in C++, and would like to make the project available to other users in my work network. The VBA project calls the dll via a line like: Public Declare Function MyFunction Lib "P:\MyDLL.dll" (ByVal MyArg1 As Double, ...) As Double where P is my personal drive on the network, same drive that the VBA project is sitting in, and this works fine. What I'd like to do is to save both the VBA project and the dll in the same publicly accessible drive so that all users can use it. The trouble is that users will have different path names for the same drive - different drive letters, different roots etc, so I can't specify a fixed path in th ...Show All

• MarcBeuret Summing up hours on form based on parameter query

  Hi there - im finalising my new activity system but i have one issue. on an activity form i have certain fields for information purposes that are non editable - they are 'hours worked with client' , 'hours worked this month' and 'hours worked for the day'. The first 2 fields are populated automatically by opening recordsets on form load or companyname exit and summing up the hours based on the relevant query where the criteria ensures that the query is already populated. However for the 'hours worked for the day' field the query is a parameter query (qrytodayhours) where activitydate = Forms![frmactivity]![activitydate] and i was then hoping to enter the following code to sum up the hours using a recordset on the on exit of the acti ...Show All

• rogupta Combo Box add items from excel column and add to excel column

  I have a program that calls for the user to add names to a Combo box and then it should take the new name and add it to a list, then the next time they open the program, it should pull the names from the list and have them pre-loaded to the drop down box to select from, how do I get the program to do this Thanks. Hello Nick, This is a very crude example but it should give you the basics. In your Excel sheet name a range called "Names" and add at least one name to it (You can the coding slightly to run even if the list has no names present. Any problem, please write to me at charleschand@aol.com Cheers Chas Code Sample: Private Sub CommandButton1_Click() ComboBox1.AddItem ComboBox1.Text ComboBox1.Te ...Show All

• Davy007 Autofill

  Hello, below is a part of the code im using. I want this code to be flexible enough so that any range of data will work with it. Thus I want the autofill part to not be limited to N2:n1860. I may have data thats only N2:n100 or n2:n3000. Selection.AutoFill Destination:=Range("N2:N1860") Range("N2:N1860").Select Range("O2").Select Selection.AutoFill Destination:=Range("O2:O1860") Range("O2:O1860").Select Columns("O:O").Select Selection.Style = "Percent" Columns("N:N").Select Selection.NumberFormat = "$#,##0.00_);[Red]($#,##0.00)" Columns("N:N").EntireColumn.AutoFit Range("M:M,K:K,J:J,F:F").Select What code would I use to pop ...Show All