Answer Questions
JonnyAJAX A question on the ISV/Software Solutions competency customer reference requirements
Could you please clarify the ISV/Software Solutions competency requirements for customer references The “Competency requirements” web page ( https://partner.microsoft.com/40012621 ) reads: “Submit at least three customer references for tested packaged software solutions. The solution must be a business application, deployed for a minimum of five users.” I have the following questions related to the quote above: Do the references have to be provided for the same software product that has undergone the ISV Testing Framework testing and received a Product ID from third party testing vendor If the answer to "1" is true, does this indeed limit the kind of software product to multi-user business applications If the answer to "1 ...Show All
gudel Creating an Array of Labels
I have an Excel 200 spreadsheet with a lot of labels on them. I want to create an array of these labels so I can do easy loops on all of them. If I do the following: dim lblArr() as variant lblArr(0) = sheet1.label1 then lblArr is set to the data in label1.caption. If I set it as label and not variant then the statement does not work at all. In VB6 I could use a labelarray or the index.. not so in vba. NM superb.. thanks alot... go that working NM You can use the Collection type to do this. Dim MyLabels As New Collection, vEachLabel As Variant With MyLabels .Add lbl1 .Add lbl2 <...> .Add lbl99 End With For Each vEachLabel In My ...Show All
bes7252 Cell Equal To EXACT Value
Hi all, prob a very simple question for you guys. How do you check if a cell equals an exact value of "Product" I am currently using: Cells(i, 1).Text = "PRODUCT" though this is also picking up any cell which contains the word Product, such as cells which contain the word Production. So how do you check for an exact value thanks for help guys, all is working 100% What formula are you using to test this equality - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ i'm using: if cells(i,1).text = "Product" then rest of code here End If ...Show All
mranzani Save changes to Word template file.
Whenever I save a document created from a template, it asks me if I want to save changes to that template. Can I disable that What's being changed in the template anyways Could you share your code that contains Documents.Open()/Add() If you have used the template file, it shouldn't ask for saving ...Show All
Espen Ruud Schultz Disable events in userform
Is there a way to disable Userform events within Userform code I am trying to dynamically set scrollbar.max without triggering the Scrollbar_Change event procedure. Hello Joe, I was a bit curious and tried the following: Private Sub CommandButton1_Click() MsgBox ("Command Click") UserForm1.ScrollBar1.Width = 20 UserForm1.ScrollBar1.Max = 100 End Sub Private Sub ScrollBar1_Change() MsgBox ("In Scroll Bar Change") End Sub Private Sub UserForm_Initialize() MsgBox ("In Initialise") UserForm1.ScrollBar1.Max = 15 End Sub The only time the ScrollBar_Change event is triggered is if I clicked on the scroll bar, or the up/down arrows of the scroll bar. The command butto ...Show All
peteyy worksheet_change and data validation
Hi there I have an Excel spreadsheet in which one column has data validation set. So the cells in this column have drop-down lists with the pre-set allowed values. Now I want the cell in the neighboring column to be set to some default value when the user selects an item from the drop-down list. This seemed like it would be easy, using the Worksheet_Change event handler. When a cell in the first column is changed, it initiates a function which sets the value in the neighboring column to some default value: Target.Offset(0,1).Value = "default". The problem is that it doesn't work when using the drop-down list. If the user types in the value manually, or if a cell in the first column is deleted, it DOES fil ...Show All
Ofir Epstein How to get the filename into the "Insert Picture" dialogue?
Our company written a marco that used in MS Words and it as same as the "insert -> picture -> from file" dialogue, but we want to enhance it to get the filename automatically when the dialogue box is opened to instead of blank. Hi, Looks like the built-in dialog does not take a initial filename argument. You can change the folder using, Options.DefaultFilePath(wdPicturesPath) = "C:\" Instead try the Filedialog object. Dim dlgFile As FileDialog Set dlgFile = Application.FileDialog(msoFileDialogFilePicker) With dlgFile .Filters.Add "Images", "*.bmp; *.gif; *.jpg; *.jpeg", 1 .InitialFileName = "c:\temp\happy" .InitialView = msoFileDialogViewTh ...Show All
Klaus Pr&#252;ckl [ADO Excel] How to use ADO retrieve Excel Worksheet name and some information
I want to retrieve Excel worksheet name and total count of sheets Hello, Well, I managed to solve it by using an ADODB object thanks to "Desertphile" in newsgroup 'comp.programming' He posted the code below. Just copy the program below in a VB6 project and place the missing objects on your form and then it will show itself. Regards, Henk Option Explicit Private Sub btnExample_Click() Dim cn As ADODB.Connection, c As Integer, d As Integer Dim rsT As ADODB.Recordset MousePointer = 11 DoEvents Set cn = New ADODB.Connection With cn .Provider = "Microsoft.Jet.OLEDB.4.0" .ConnectionString = "Data ...Show All
Anand Raman - MSFT MergeSort for Double Arrays
Hello There =) I made a MergeSort function for matrices with Double Data. I haven't found this on the web (one that works, that is), so I'm posting here, so ppl can watch, and maybe improve. To use with strings and other kinds of variables, you just have to change the compare statement, and the type (Double). The compare statements are bolded. Cya Public Function MergeSort(Doubles() As Double) As Double() Dim s As Long, i As Long, n() As Double, m() As Double Dim u As Long, l As Long, j As Long, x() As Double ' Only 1 element If (UBound(Doubles) - LBound(Doubles)) = 0 Then MergeSort = Doubles Exit Function ' Only 2 elements ElseIf (UBound(Doubles) - LBound(Doubles)) = 1 Then MergeSort = Ordena2 ...Show All
Eyvind Question about ADO and Access
Hi, I've been searching the net for the last 3 hours for a good example of querying access database from excel and then manipulating the recordset, this isn't as easy as I expected. Can anyone offer an idea (I'm not even sure how to open the database). Thank you all (and sorry for the silly question), Raphael The below is from the Office Help System, you don't need to worry about the Pivot Table bit. Once you have the recordset you can work with it from there. This example creates a new PivotTable cache using an ADO connection to Microsoft Jet, and then it creates a new PivotTable report based on the cache, at cell A3 on the active worksheet. Dim cnnConn As ADODB.Connection Dim ...Show All
Annihil8 Need help about combo boxes in Visio 2003
Hi, Is it possible to bind combo-box item with shape's custom properties in Visio 2003 If this is possible how If anyone have any ideas on how to make this happen, it will be greatly appreciated. Thanks. ...Show All
srlito Calling c# assembly - Works from Excel 2003, not from XP
Hello I have a c# assembly that Iam calling from Excel 2003 VBA. The assembly has 4 dependencies (located in the same folder). All have strong names. I use regasm etc etc. I can call the class/functions in the assembly from Excel 2003, but the code does not work from Excel/Office XP. The error message is : CDCOM.dll or one of its dependencies could be found. Any help is very much appreciated. thank you. va hi, I'm unsure if this will solve the problem but with try installing the assemblies in the GAC. ...Show All
Fata1Attack Automating PowerPoint
I have a vba procedure within a ppt presentation that creates a new presentation with a set of slides and saves it. This process is repeated until about 30 different presentations are created, but I would like to automatically execute it at a specific time so I don't have to run the code manually everyday. Can you please suggest how I can automically execute my vba code to run thank You! Jenise Powerpoint, unlike excel and word, does not have AutoOpen routine unless the file is an addin. See Shyam Pillai's page for more details. AutoEvents Add-in for PowerPoint 2000 and later http://skp.mvps.org/autoevents.htm As for having the file run at set times have a look at the help on Schedule ...Show All
stabbe Office 10 \ winword.exe runtime error
I have downloaded the service pack 3 but I'm still encountering the problem when I try to open MS Word. MS Excel, MS Outlook , MS Powerpoint & MS Viso all work fine. Any time I try to open MS word I receice a Box vissual c++ runtime library. This application has requested the runtime to terminate it in an unusaul way. Microsoft Office\Office 10\Winword.exe. I'm right there with you... except I first noticed the problem with Norton. Since then with Office. You described the situation very well. I can't even install all the windows security updates without this error. Help someone who may have the solution!! Per the support engineer: Would you please ask ...Show All
soconne MSDN Licensing for a Microsoft Gold ISV Partner
We are currently a Microsoft Gold ISV partner and I have a question as to how the licensing works for the disks that we get as part of our partnership. Specifically the difference between development licenses and internal use licenses. The partner program guide identifes the internal use licenses very well, but are there different licenses for development use or are the internal use licenses to total of what is allocated. The driving need behind the question is that in the MSDN packs we are sent we are given installs of all of the versions of for example SQL Server 2005. But in the partner guide is says we are allocated 2 SQL Server 2005 Enterprise edition licenses and 100 CALS. In this instance we do not need the software for internal ...Show All