Microsoft ISV

Page 5




  • Topics
    Replies
    Last post
  • Compare records in 2 worksheets automatically for duplicate records
    by lezah
    0 Replies
    Last post by lezah
      • hihi, I wan to compare 2 sheets data in column a for duplicate ids and delete the duplicates. i have write the code to jus delete the duplicates for one sheet. how do i compare records from sheet 1 with sheet 2 for column a in codes belows are the codings for deleting the duplicates within one sheet. Public Sub DeleteDuplicateRows() Dim R As Long Dim N As Long Dim V As Variant D
  • measuring milliseconds on excel
    by huklin
    2 Replies
    Last post by huklin
      • If I want to time how long a small section of code takes to the accuracy of milliseconds, I would like to know what functions will give me that. Dim startTime = <getTime> section of code... Dim endTime = <getTime> Dim result = endTime - startTime Anyway, thanks a lot in advance.
  • Open PDF file
    by sweet-66
    5 Replies
    Last post by RhysDavies
      • Hi everybody, I'm creating a program in MS. Access but I just want to ask:, how to open *.pdf(extension) file in visual basic access (vba) thanks in advance. :-)
  • Excel Solver VBA Problem
    by cgufl
    10 Replies
    Last post by Redskin9
      • I have a problem with programming Excel solver using vba. I have the following micro in a workbook named "Book2.xls": Sub Macro1() ' ' Macro1 Macro ' Macro recorded 11/8/2005'     SolverOk SetCell:="$H$10", MaxMinVal:=2, ValueOf:="0", ByChange:="$G$10"     SolverAdd CellRef:="$G$10", Relation:=3, FormulaText:="$G$11"     SolverOk SetCell:="$H$10", MaxMi
  • More parameters than 30 to send to a userdefined function
    by Bertdolfo
    1 Replies
    Last post by yoshikatsu
      • In coding a usercreated function in a module the maximal numbers of parameters ( or arguments) than can be sent to a function is only 30. How can I increase to, lets say 45
  • How to activate a listbox selection using Excel VBA?
    by Kven
    14 Replies
    Last post by Andy Pope
      • Hi, I am very new to VBA Progamming. I have created a tool which checks for error in excel file. The below is my problem. First i will select a file using Openfile method. Then the combobox will display all the sheets which are present in the selected excel file. Here i will select a excel sheet and run a code to check errors. The procedure will check the errors and shows how many errors
  • Cannot sign in to communications service error on Vista (credentials prompting)??
    by markm75c
    3 Replies
    Last post by markm75c
      • 'You may have entered your sign-in name, username, or password incorrectly' This error suddenly occurs on my Vista x64 machine.. I've seen articles pertaining to XP and a dll to fix, but this doesnt apply in Vista. Has anyone run into this I suspect a log off or reboot may fix it; Its rather aggrivating though, if you try to enter credentials manually it still occurs. I can sign into Com
  • Disabling the X (close) button on a UserForm
    by rabbitoh
    5 Replies
    Last post by rabbitoh
      • Does anyone know how to disable the X on the top right corner of a UserForm so that when a user clicks on it to close the form, they get a message saying "Please use the Exit button" (which is a macro button on the form itself)
  • Excel: Can a UDF tell what cell it was invoked from?
    by My_Head_Hurts
    3 Replies
    Last post by My_Head_Hurts
      • I have a need to check other values in the same row, and/or same column as the cell being processed. My User Defined Function therefore needs to know what cell is invoking it. It is certainly not ActiveCell. My function works if I pass it a string (e.g. "H12") to tell the UDF what cell it is, but that's too messy to populate through hundreds of cells. Does anyone know how this can be don
  • VBA doesn't listen to my Format command...
    by Guustaaf
    2 Replies
    Last post by Guustaaf
      • Hi all, I'm having a problem with formatting text in a userform. my code: Private Sub txtUurloon_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean) Dim txtTmp As String txtTmp = txtUurloon.Text txtUurloon.Text = Format(txtTmp, "€ ###0,00") End Sub When i put in for example 1 then my textbox updates and shows € 001... While it should be: € 1,00! Does anybody know wh
  • How to stop Popup
    by Bajrang
    0 Replies
    Last post by Bajrang
      • Hi, All I m creating an Addin to check whether user has not filled any recipient of the Mail. In this case (if user has left all of its recipients blank), I want to send my mails to a specefied email address. I have written the code for it in myOLApp_ItemSend but problem is that when I leave blank all its recipient then a message comes . "There must be at least one name or distribution list i
  • AdvancedSearchComplete fires before search is actually finished
    by IanMF
    0 Replies
    Last post by IanMF
      • Hi! I'm using Excel 2003 to search the Inbox of Outlook 2003 for a string retrieved from a MsgBox. I'm using single words, no spaces or non-alpha characters. This is a test prior to enhancing the functionality. The search does work if I add MsgBox lines in the code module to delay the running of the after-search code, but using the AdvancedSearchComplete code in the class module (as documented on
  • How can I write a VBA code for clicking a command button?
    by lyp_sj
    2 Replies
    Last post by mp2022
      • Hello: How can I write a VBA code for clicking a command button Basically, I want to write a if sence that if clicking the "YES" command button, it will run a maroc. While I do not know how to write the code. Thanks for help! B.regards/Yaping
  • Using Vba to count occurences in excel
    by ageary
    2 Replies
    Last post by ageary
      • Hello, I am working on a little project that makes a list of files in a specific folder on every machine in a network. I have been sucessful so far, and I can get a list of files on every machine. I use excel to store this information. This leaves me with a list of every file on the network in this folder, like this. A.txt A.txt b.txt c.txt c.txt c.txt what I would
  • Excel Solver VBA Problem
    by cgufl
    10 Replies
    Last post by Redskin9
      • I have a problem with programming Excel solver using vba. I have the following micro in a workbook named "Book2.xls": Sub Macro1() ' ' Macro1 Macro ' Macro recorded 11/8/2005'     SolverOk SetCell:="$H$10", MaxMinVal:=2, ValueOf:="0", ByChange:="$G$10"     SolverAdd CellRef:="$G$10", Relation:=3, FormulaText:="$G$11"     SolverOk SetCell:="$H$10", MaxMi
  • check if file is already open
    by carrie09
    2 Replies
    Last post by Martin Xie - MSFT
      • Hi, I wrote a VB code to generate a xls file in my Access database. Users are able to run it fine but if they have another file with same name already open, then it just crashes excel. So I want to include a code that checks if file "file.xls" is open on user's machine. If file is open, then message "file "File.xls" is already open. Generating File_1.xls"
  • How do I open CSV using Excel without deleting leading zeros?
    by magicalclick
    8 Replies
    Last post by OmegaMan
      • Hello, Whenever I open up a CSV file or a Text file, Excel treats string like 05710 as a number and turn it into 5710. How do I open up a CSV file and still keep the leading zeros Thank you very much.
  • iexplore.exe - Application Error
    by bennett1016
    14 Replies
    Last post by rreynard
      • I get the following error message when I close my internet explorer. The instruction at "0x62304320" referenced memory at "0x62304320", The memory could not be "read". Click on OK to terminate that program. Any ideas what is causing this
  • Action Pack Question
    by Tone Southerland
    12 Replies
    Last post by Mark.Rowe
      • I am interested in the Action Pack. I understand that it comes with the Vista upgrade, not the full edition. I do not have 10 licensed copies of XP Pro to upgrade from. So does that mean I will need to purchase a licensed copy of XP Pro for each machine that I want to put the Action Pack upgrade version of Vista on
  • How do I 'click' inside a List Box!!
    by Quarry
    2 Replies
    Last post by Quarry
      • Hi, when a user clicks a command button I want it to automatically click (enter) a list box. I have tried using the set focus event but i need my code to actually click inside the list box.
  • Writing OPC client in C#, DataChanged eventhandler error
    by Alain.s
    1 Replies
    Last post by Peter Ritchie
      • Hi All, I'm trying to write and console applications which connects to a remote server using OPC-DA. I'm able to connect to the server using the softing OPC toolbox. But when I try to create new OPC subscriptions, and add eventhandlers to it I recieve the following error : The remote procedure call failed and did not execute. (Exception from HRESULT: 0x800706BF) Here a piece of the code : publi
  • Excel::NetDDE and DDEShare
    by saleem145
    3 Replies
    Last post by arpenteur81
      • Has anyone tried to link two workbooks running on different machines I found an interesting article on how this can be done -- http://support.microsoft.com/default.aspx scid=kb;en-us;128491 This is exactly what I want to do -- only problem I can't get it to work!! I am using Windows XP and Excel 2003. I have two seperate machines and I have enabled NetDDE on both of them. Also I know that N
  • How to copy combobox value to active cell in excel worksheet Automaticaly vba
    by abkarino
    5 Replies
    Last post by abkarino
      • Thanks for help . I Make a userform with combobox and make the row source but How do I get the highlight value from my combobox to active cell in excel worksheet automatically. Using Excel 2003. Pls.help me thanks
  • how to set a valid reference range for a pivottable
    by lyp_sj
    1 Replies
    Last post by Andy Pope
      • Hello, When I create a pivot table, there is always an error said " reference is not valid". I set my reference database as blew, and I do not know what's wrong with this Thanks so much for your help! B.regards/Yaping lastrow1 = worksheets("MMS_RSP_GSV").cells(Rows.Count, lastcolumn1).End(xlUp).row 'get last row of data in last column workshee
  • Move cursor to the end of cell for data entry
    by potain
    4 Replies
    Last post by potain
      • Hi I would greatly appreciate your help please. I use an Excel spreadsheet to keep a record of conversations for telemarketing. I have a formula : =TEXT(NOW(),"ddd dd mmm yy h:mm ") in B1 which reflects the current date & time. I run a simple macro which fills the date value into the active cell : ActiveCell.Value = Range("B1").Value & " - " to record the dat