Microsoft ISV

Page 47




  • Topics
    Replies
    Last post
  • D&D
    by YaelS
    0 Replies
    Last post by YaelS
      • Hi, I need something like this: http://www.codeproject.com/csharp/testemaildragdrop.asp in vba + access.. any idies
  • BUNDLING MS MONEY 07 TRIAL
    by Steven777
    1 Replies
    Last post by MS ISV Buddy Team
      • I'm interrested in bundling Microsoft Money 07 on our Welcome disk as a value added benifit to our business members. What is required to do so
  • opc
    by ksona
    14 Replies
    Last post by MartinBrasil
      • I am trying to develop an opc - da client using .net technology. Have gone through the documents on opc and opc client and all, but am still not sure how to implement it, can someone give me a direction on how to start with it
  • randomizing the contents of Excel cells
    by Josh Ord-Hume
    6 Replies
    Last post by PYA_Ferro
      • I am trying to create an Excel macro that will look at the contents of cells A1, B1 and C1 and 'randomize' their order. So, if the contents of A1, B1 and C1 are "1", "2" and "3" respectively, they might end up as " 2 ", " 3 ", " 1 " or " 1 ", " 3 ", " 2 " once the macro has been run. Any ideas gratefully rece
  • TextBox height
    by suznal
    8 Replies
    Last post by suznal
      • Excel 2003 - TextBox What would the code look like to have a text box maintain a specific width and a minimum height but increase in height as data is entered
  • Can we turn off the smileys?
    by Jon Peltier
    4 Replies
    Last post by Jon Peltier
      • If someone posts an Excel range, like $a$1 : $b$2 without the spaces around the colon, the colon plus $ combination draws a stupid smiley, as in $a$1 b$2. This interferes with the message and looks so unprofessional. Is there any way to turn off smileys in this forum, as there are in other forums - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical S
  • Suppress Linked View Unique Record Popup
    by Babbage
    14 Replies
    Last post by Babbage
      • Hi there im linking a view on an ms sql server to my access database using VBA using DoCmd.TransferDatabase acLink, etc.etc. How ever, I can NOT get the `Select Unique record Identifier` pop up to stop coming up when the link is being made. I dont care about needing a unique identifier, its a read only record source. The only way ive found is using sendkeys command to cancel the popup - however th
  • VBA Powerpoint - identifying textboxes by type
    by Peter Caisse
    3 Replies
    Last post by Peter Caisse
      • Hi everyone, I'm writing an add-in for Powerpoint 2003. I'd like to know how I can identify textboxes by type if such a thing exists. For example, when reading a TextFrame, how do I know if I'm reading the title textbox, the subtitle, or a the big textbox with bulleted points depending on the slide model I've found the Shapes.Title property, but that only gives me the title if it exists, not the v
  • Counting words
    by une
    10 Replies
    Last post by une
      • Does there exist a predefined function that counts the number of words in a string
  • Delayed execution?
    by TKeune
    1 Replies
    Last post by TKeune
      • I have a VBA application on an Excel workbook. I'm adding a new line to the spreadsheet by doing data entry through a form. In my initiating macro I initialize the form and connect the data fields of the form to their various positions in the current spreadsheet row. While doing that, I initialize two fields with default values, the first a Par #, the second with today's date. What I'm seeing is t
  • Excel-Capture the sum of Highlighted Range
    by Neil Tenbrook
    3 Replies
    Last post by Andy Pope
      • I'm trying to capture the sum of a highlighted range in an Excel Marco without using a loop. After selecting a range, I can capture the cell count with the following command: X = Range(Selection, Selection.End(xlDown)).Count Wondering if there is way to the sum as well. Excel can show the sum highlighted range, so it seems I should be able to replecate in VB. Thanks, Ne
  • Aproval of responses
    by Togo162166
    4 Replies
    Last post by Jason Hardester - MSFT
      • Hello, I registered four responses to crash events on September 26th. They're status remains "In Progress" (the tooltip says "Response is awaiting aproval") ever since. When can I expect the responses to be treated - T
  • How can I disable a command button under certain condition?
    by lyp_sj
    3 Replies
    Last post by lyp_sj
      • Hello: How can I disable a command button under some preliminary conditions, for example, if I want to click button 1, I have to observe the result from clicking button 2 Thanks so much! B.regards/Yaping
  • Extracting data from an Access 97 MDE file
    by John Loo
    0 Replies
    Last post by John Loo
      • Sorry if this is too basic, but I'm trying to find out if there is a way to extract the tables and data from an Access 97 MDE file. I don't need the VBA code or forms, just the data. I have all of the passwords and ID strings for the users. TIA
  • SAP
    by envi_ria
    11 Replies
    Last post by envi_ria
      • HI Does any one know what is the procedure and purpose of doing SAP. What are the requiments, and how can I go about doing the training. What are the courses available for the same. I am an IT trainer for the last 2 years would like to do SAP. Supriya
  • CreateWorkspace() call fails after installing Office(Excel) 2007 - using ODBC
    by HedleySohn
    3 Replies
    Last post by HedleySohn
      • We have a VBA component that we've used for a long time. Our users have recently begun to report that the component no longer runs once they install Office 2007. We have always created an ODBC workspace as in the following: DIM workODBC As DAO.Workspace Set workODBC = CreateWorkspace("ODBCWorkspace", "Admin", "", dbUseODBC) This call
  • Need VBA code to find first positive data point & determine standard deviation of data set
    by traj
    0 Replies
    Last post by traj
      • Let me preface this by saying I am an absolute beginner at VBA..... Basically, I have an Access table with 3 fields. The fields are: Item_Number, Date, Units_Sold. For each item, there are 24 months worth of data. The table is structured as follows: Item # Date Units_Sold 01 2006-10 0 01 2006-11 0
  • 2 Small Macro problems.
    by GB Allan
    6 Replies
    Last post by GB Allan
      • Hi all, Problem 1: I am trying to delete a sheet within a workbook, as part of macro. Here's the code: Sub DeleteInstructions() ' ' DeleteInstructions Macro ' Macro recorded 3/13/2007 by Gary Beckwith ' ' Sheets("INSTRUCTIONS").Select ActiveWindow.SelectedSheets.Delete Sheets("DATA").Select End Sub When I run it, I get the prompt "Data may exist in the
  • Strange recoeded code for pasting device independent bitmap
    by Yaron Kohavi
    3 Replies
    Last post by Jon Peltier
      • Hi, When I record a macro which emulates the following menu selection: Edit, Paste Special, Device independent bitmap, I get the following code: Sub Macro2() ' ' Macro2 Macro ' Macro recorded t12/03/2007 by yaronk ' Selection.PasteAndFormat (wdPasteDefault) End Sub Sub PasteInde Where in fact, it seems as if the code should hav
  • Some questions about WER
    by Nikolai Bochkarev
    5 Replies
    Last post by Jason Hardester - MSFT
      • Hi! I'm integrated WER support in my Delphi 7 Application and now get some results 1) I'm register winqual account 2) Integrate WERAPI support in my application (Delphi program has own exception processing) 3) Map my .exe and upload xml file procedure TForm1.ApplicationEvents1Exception(Sender: TObject;E: Exception); var eventType : PWideChar; begin if
  • I've received empower, but where are serial numbers???
    by Ihor Bobak
    6 Replies
    Last post by orcmid
      • Last year I ordered Action Pack - I received disks and serial numbers sticked on disk folders. This year I ordered Empower. I received many disks, many papers (license agreement and advertisement materials), but where are serial numbers I don't see them neither sticked on disk folders, nor among all papers. I cannot install Windows Vista... Can anyone give me a hint - where can I get my serial nu
  • VBA String manipulation problem.
    by OM
    2 Replies
    Last post by Andy Pope
      • (i orignially posted this message in the vb forum... but was told to post in here instead.) I'm trying to code for an Excel spreadsheet. Very new to VBA. I want to replace all comma characters with a newline character. And then get rid of all whitespaces. So far, I've got this: Worksheets("Summary").Cells(i - 4, 1).Value = Trim(Replace(StrConv(Worksheets(&
  • Make a New Hyperlink by the User
    by Clarence j
    2 Replies
    Last post by Clarence j
      • Yes I am Currently trying to make a Macro from a Button or a Cell for users to click on for them to make their on Hyperlink and Not go to the hyperlinked destination but rather put the Hyperlinked Destination Name in a Certian Cell I will Give an Example Making a Database of Students and Trying to allow users to upload Resumes to attach to each worksheet The Resumes will Be Wo
  • Excel Macro to Capture Live Webcam Image?
    by Denis Ott
    8 Replies
    Last post by jo_turner
      • I am attempting to write a macro which will access my USB connected camera, grab a picture, and paste it into an active cell. I am able to do this manually by simply locating the cursor at a cell location, selecting "Insert - Picture - From Scanner or Camera", Selecting the Twain resource for my camera, Selecting Custom Insert, Selecting Take Picture... and viola, the active view from
  • User-defined function appears to be preventing Worksheet_Change trigger?
    by svaiskau
    6 Replies
    Last post by RonZ2
      • I have the following user-defined function, which works independently (that is, it does what it is supposed to): Function ActivityIndex(currentDate As Date, projectName As String _ , firstRow As Integer, lastRow As Integer) Dim dateColumn As Integer dateColumn = (currentDate + 1) / 7 - 5575 Dim count As Integer count = 0 Dim i As Integer i = firstRow Do While i <= lastRow If