Microsoft ISV

Page 27




  • Topics
    Replies
    Last post
  • Macro to send information when modified
    by sree
    3 Replies
    Last post by ADG
      • Dear all, I would like to know if we could create a macro, which will send information to a list of email ids, when a particular excel file is modified manually or updated using other macros in it. This way i wish to save an excel file in a shared folder where authorised people can access - read/write and when they modify, a list of people who would actually be using the information
  • How do I call for all installed printers....
    by MyLady
    5 Replies
    Last post by magicalclick
      • Hey, How do I, with vba code, call for all installed printers in my computer and then display them in a ListBox Best Regards Cathrine
  • Need to link two word documents together.
    by Lunar Beam
    3 Replies
    Last post by Shasur
      • Hi, I have two documents which have roughly similar tables that need to be filled in Microsoft Word. I would like to have a macro that updates a cell in a 5-by-5 table in B.doc when a cell in a 5-by-5 table in A.doc is updated. 1) A.doc is updated. 2) B.doc is opened, then updated. 3) Both documents save themselves. It would be best if steps 1-3 are completed with
  • .mdmp files not being created
    by David Ching
    28 Replies
    Last post by David Ching
      • Hello, Under what conditions is the .mdmp file created or not I have written an app that (deliberately) dereferences a NULL pointer, but the generated error report does not have the "Files that help describe the problem" section when listing the report from the Control Panel "Problem Reports and Solutions". Viewing other reports that had been put there, some of them have the f
  • How to make this pastespecial happen?
    by lyp_sj
    2 Replies
    Last post by magicalclick
      • Hello, When I try to copy and paste with a multiply function by using below code, it does not work. I guess something I did wrong when I select the range:Range(cells(r, 7), cells(r, lastcolumnCapacity)), while I do not know what's wrong with this Thanks so much for help! B.regards/Yaping worksheets("Capacity").Range("B1001").Select Selection.Copy
  • programming "yes-to-all" functionality
    by pacificwaters
    4 Replies
    Last post by pacificwaters
      • I'm using VB 6.3, and I'm trying to program a Yes-to-All (and No-to-All) button, which doesn't exist in the MsgBox functionality. Currently trying to use the .doalert method: With Application.Assistant Select Case .DoAlert( _ "Invalid Member", _ message, _ msoAlertButtonYesAllNoCancel, _ msoAlertIconQuery, _ msoAlertDefaultFirst, _ m
  • ListView in VBA
    by Cody Code
    2 Replies
    Last post by Cody Code
      • Hallo I Just Have One Question in Regards to the Listview Control in VBA. I am trying to fill each column in my listview with data that is from a recordset. i.e rem lstviewItems in the listview control on the form Set list = Me.lstviewItems.Object With list .ListItems.Add , , rec("Desc") .ListItems.Add.SubItems(1) = rec("RetailCost") .ListItems.Add.SubItems(2) = txtQty.Value
  • Excel VBA - Copying Recordset to Array
    by HMote
    1 Replies
    Last post by Luiz Claudio - MVP
      • I for the life of me cannot figure out how to do, what I figure, should be a simple task; I need help on how to copy the contents of a recordset to an array in VBA. I have my recordset ready to go, but I have no clue on how to copy it's contents to an array. In my routine, I want to access this array to find out if a date already exists in the db before inserting the new data, so I only ha
  • Why is my Web Query Refreshing Inconsistently?
    by bob135
    4 Replies
    Last post by bob135
      • I have asked on several other forums (In Mr. Excel, a popular excel forum, my post got bumped to the bottom, I'll try posting it again but yeah...I'm looking everywhere now). Here's the issue: This is the code for my query: WEB 1 http://finance.google.com/finance fstype=ii&q=["Ticker"] Selection=EntirePage Formatting=None PreFormattedTextToColumns=True ConsecutiveDelimitersAsOne=True
  • Microsoft Platform Test for ISV Solutions required deliverables
    by NRZ
    3 Replies
    Last post by KevinKhelawan
      • What required deliverables I must send to ISV for Platform Test. Are "Setup package" and "User Document" Enough
  • VBA:how to set comment object's author in Excel 2003
    by Daniel Yang
    2 Replies
    Last post by Andy Pope
      • Hi all, How should I set or change the comment author of a cell in Excel 2003 I have looked up in MSDN. It only provides the sample codes of how to get the author value. I use the following codes: Sub setcomment() Dim a As Comment For Each a In ActiveSheet.Comments a.Author = "daniel" Next End Sub The error message is wrong number of augm
  • Script to configure Microsoft Office Document Imaging Printer
    by DGB1
    1 Replies
    Last post by Cringing Dragon
      • I have an application that uses the MODI Printer. I would like to set the properties to Tif and change the print destination folder. When my program installs I would like to build the script and execute it. I've seen scripts to install/remove printers, is there anything that can set the MODI printer's advanced properties
  • Converting access to VB.NET or C#
    by fweeee
    4 Replies
    Last post by fweeee
      • Hello, A friend and I are currently in the process of converting an access database to something a little more powerful. At the moment, we are converting the backend to MSSQL (using a tool we bought from somewhere on the internet - the upsizing tool was only working for 20% or so of it). After this is complete, we will then need to get the frontend into something a little more appropriate - either
  • Help! Please! dll
    by morozx
    3 Replies
    Last post by ke wenzel
      • I have windows vista and a long time ago I accidently opned a dll file with notepad and now i dont know what to do. A lot of my programs wont run, and i cant find a application to open it with. So i need to restart my computer but how ! !
  • How to get a control by its name (not in a form)
    by Duy Cuong
    2 Replies
    Last post by Duy Cuong
      • In my presentation I have some controls, which I know their names. The question is how to use their name to change their proper ties... somehow like Dim myControl As control Set myControl = Controls("CheckBox1") myControl.Visible = False End Sub please help !!!
  • Using VBA macro to locate next free column on worksheet
    by rabbitoh
    14 Replies
    Last post by magicalclick
      • I need a macro that locates the next free column (i.e. has no data in cells) and then places the cursor in a cell on a designated row. Would like search to start from column B and to place the cursor on row 4 on the free column. <> My VBA code thus far: Function NewColNumber(Range1 As Range) As Integer Dim j As Integer For j = 1 To Range1.Columns.
  • Unable to infopath form in browser
    by RagsIyer
    3 Replies
    Last post by Sergio otoya
      • ERROR: The form cannot be displayed in the browser because the use of session cookies has been disabled in the current browser settings. In order to load the form, session cookies must be allowed. Any pointers would be appreciated
  • VBA EXCEL: How do I subtract two cell values
    by UH60
    2 Replies
    Last post by magicalclick
      • I want to subtract value in A1 from A2 in VBA. This is what I thought, but it doesn't work Val (Range("A1").Value) - Val(Range("A2").Value) I hope someone can help Thanks
  • Office 10 \ winword.exe runtime error
    by Kdean6869
    14 Replies
    Last post by Jyh-Cheng Chen
      • 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.
  • Toggle buttons
    by une
    4 Replies
    Last post by une
      • I need some help programming toggle buttons. I assume a toggle button can have 1 of 2 states and the state alternates when the button is clicked. Is this correct I am thinking about some code as follows; Private Sub ToggleButton1_Click() ToggleButton4(changeState) If ToggleButton1.state = false Then ToggleButton1.caption = "NO" Else ToggleButton1.caption = "YES
  • Help please
    by jovert
    3 Replies
    Last post by envi_ria
      • can i control any application or software using only VB program or how can i control any application using VB for example, i want to control the internet explorer then by using vb i can direct the website i want to go or write the address without manipulating,only the vb program to be used! Thanks a lot for the help!
  • Future of VBA (and VBScript)?
    by fiatlux
    28 Replies
    Last post by fiatlux
      • We developped a number of tools in VBA or VBScript, sometimes using COM objects, and the large compatibility of VB, VBA and VBScript was certainly nice. We would no mind moving to .NET (the framework API being quite interesting), but it is not clear what is going to be the future for VBA and VBScript. Can we expect a VB.NET"A" and a VB.NET"Script"
  • Select/cut/insert
    by Bluzdude
    4 Replies
    Last post by Bluzdude
      • I need to select all rows in an Excel worksheet in which the value in cell "F" is not blank, cut each of those entire rows and insert them in another worksheet at row "4".
  • How do I deal with files of more than 65k rows?
    by chilehed
    8 Replies
    Last post by chilehed
      • I need my code to be able to deal with .csv files of well over 65k rows, but haven't the slightest idea how to do it. I've heard of a technique called "paging", which distributes the data over more than one sheet but processes it as if it's on one. How is this done Thanks.
  • Assign an array to .values and .Xvalues in an excel chart
    by Jonas.S
    6 Replies
    Last post by Jonas.S
      • Hi, I'm having trouble with assigning arrays to a chart. Below is how I done. Anyone nowing how to make this work     Set MyDispl = Application.InputBox(Prompt:="Select displ.", Type:=8)     Set MyForce = Application.InputBox(Prompt:="Select force.", Type:=8)     Do '''Collects Displ data