Microsoft ISV

Page 110




  • Topics
    Replies
    Last post
  • Highlighting cells within a worksheet
    by pfunkmasterflex
    3 Replies
    Last post by Andy Pope
      • Several of us in our office have a fantasy golf league and we administrate it off-line using an excel spreadsheet (we haven't found a free website that lets us tailor the rules to the way we like it.) Anyway, it is a salary cap format, meaning that only one golfer can be on one team at a time. To keep track of this, one of our worksheets has a list of all the golfers. That same worksheet also has
  • ISV Software Requirements
    by jk_0321
    2 Replies
    Last post by cUtEpInKbUnNiEs
      • Hello all, Sorry I'm new here and was unable to find an answer to my questions using the search feature. Because Microsoft requires several MCPs to satisfy their non-ISV competancies, I need to take the ISV route to get Certified Partner status. If I was to go for the ISV Competancy, what kind of application are they expecting me to develop I read on the lionbridge site that games and of
  • 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
  • Replacing (changing) the pictures in PowerPoint presentation
    by Hani Simo
    2 Replies
    Last post by Hani Simo
      • I am trying to write a small program to replace pictures in PowerPoint presentation... To find the pictures, I check Shape Type (Shape.Type = msoPicture)... But the problem is: how can I change the picture after this step What is the method I should use to load the new picture from file to the Shape Best regards and have a nice day, Hani
  • Using Inputbox to detect a worksheet
    by Jonas.S
    1 Replies
    Last post by Andy Pope
      • Never mind I solved it, see red marked for solution   Hello, I want to let the user add a serie to a chart. While doing so the usr will collect data using Inpubox from a different worksheet. He will need to go there three times to collect all data. I would therefore want the code to recognize on which worksheet the usr collected the first data set on and then when the usr has co
  • Excel Macro running slower in 2003 vs. 2002
    by Tim M.
    0 Replies
    Last post by Tim M.
      • I am trying to figure out why a macro runs slower in Excel 2003 vs. 2002 and narrowed it down to a function that deletes rows. This function is used numerous times and before this function is called a varying row is selected, then is processed in this function. I think the Selection.Delete command is causing the slowed performance but not sure why it is. Does anyone have a suggestion Up to 100 ro
  • ReportFault() vs. WerReportCreate/WerReportSubmit() on Vista
    by Claus Brod
    12 Replies
    Last post by Jason Hardester - MSFT
      • Hi all, I'm experimenting with the available APIs for error reporting. On XP systems, I'm using ReportFault(), which seems to work as expected- it displays the WER dialogs, sends data to the Winqual site (including minidump data), launches a debugger when asked for by the user etc. Is this the right place to ask questions about those APIs If not, please ignore the following. (But if you know where
  • height of a field in word
    by vsyam
    6 Replies
    Last post by Shasur
      • Hi, Any idea as to how we can get the height of a field in word in vba Thank you.
  • Problen reading Cell
    by zeroton
    2 Replies
    Last post by zeroton
      • Im from Brazil, and my regional seeting are "," to separete decimal places But when i use VBA to read a cell value, if it is 0,93 he only reads 0, but if it is 0.93, he reads correctly this is a sample of the code that i'm using Code Snippet Dim Proj(500, 500) As Double Proj(3, L) = Val(Cells(21 + L, "N").Value) My regional settings are ok
  • Bloomberg + Execel = True?
    by AndersBank
    4 Replies
    Last post by eric888
      • Ok my situation is like this: I have a computer that runs Windows XP Professional. On the computer I have a Bloomberg subscription i.e. I have an ordinary monitor, but a Bloomberg keyboard and it is "true" Bloomberg subscription (it is not the Bloomberg website I am referring to). I have an Excel spreadsheet that is connected to Bloomberg and updated once every day using a DDE connection
  • ApplyCustomType question
    by NeitherMightier
    0 Replies
    Last post by NeitherMightier
      • I'm running Office XP with current updates, and I'm observing some peculiar behavior when I try to use ActiveChart.ApplyCustomType in Visual Basic. The FIRST time I run my Macro after opening Excel, none of the code after: ActiveChart.ApplyCustomType xlUserDefined, "name" executes. After the first time I run the macro, the VBA Project (XLUSRGAL.XLS) appears in the "Project" wi
  • 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
  • Issue with Selection.TypeText and Chinese Characters.
    by McLovin
    1 Replies
    Last post by McLovin
      • Hello Everyone, I'm having trouble getting chinese characters to work with TypeText. When I use English, everything works great. For example, the following statement shows up as " " in my word document. exec sp_OAMethod @objword, 'Selection.TypeText("ÃÀ‡ø¿‚½y")' While I'm using T-SQL and not VBA, I figured that the people here would probably know th
  • DoCmd.OpenReport passinh param to underlying query in MSAccess
    by acki4711
    3 Replies
    Last post by Bazz07
      • Hi all, - I have in Access (2003) a report who's datasource is a saved query. - This query needs a param How can pass the param to the query using the DoCmd.OpenReport method Any help is highly appreciated. TIA Dan
  • "Cabs requested" icon
    by Claus Brod
    1 Replies
    Last post by Jason Hardester - MSFT
      • Hi, a number of the crash reports we're seeing is marked with the "Cabs requested" icon (cab icon with a little clock in it). The documentation says that this icon means that ".cab data has been requested and is not yet ready for download". I'm not quite sure how I should read this. My current interpretation is as follows: For some crash reports, the .cab file is not tran
  • Save As event not firing in Office 2007
    by kvreddy
    0 Replies
    Last post by kvreddy
      • I wrote an event for Save As menu , it works fine for Office 2003, but its not working for Office 2007 (1 line of code below) If evtFileSaveAs Is Nothing Then Set evtFileSaveAs = 'Application.CommandBars("Menu Bar").FindControl(, 748, , True, True) I am expecting doubt like Save As Menu Id is not 748. Is there any solution for this Thanks in advance and help
  • Exporting the access resultset to excel programmatically
    by Alex Kurama
    1 Replies
    Last post by Shasur
      • Dear all, I would know how can I export the access resultset to excel. Can I get the query from Access which I have done and saved in access directly, so that I do not need to rewrite the SQL statement in the VB, if yet, then how I think I need to use something like Set rs = db.OpenRecordset("Query name") or such but I don't know how. Can anyone of you can he
  • Excel 'Freeze panes' from Access VBA (Off2000)
    by Jasperz01
    1 Replies
    Last post by Jasperz01
      • Hi, I'm searching for a way to freeze the upper part of my Excel sheet (with headers and such, like the 'freeze panes' menu option in Excel), from my Access VBA code. I've been searching for a while but didn't come up with something usefull. Anyone any suggestions Thanks in advance, I'd be really glad if someone knows this!
  • Message for display during macro execution
    by une
    3 Replies
    Last post by une
      • I have a macro that takes a long time to execute. While it is running I would like to put an object on screen to inform the user that the macro is running and they should just wait. Otherwise they may think something is wrong. It would also be good if this object had a button on it the user could click to end the macro if they run out of patience. I thought about a message box, but when it is disp
  • Upgrade problem Access 97 and Access 2003 on same machine
    by ADG
    0 Replies
    Last post by ADG
      • Hi We have finally started to upgrade to Office 2003, I still have a copy of Access 97 on my machine to maintain databases which cannot be upgraded until the roll out is finished. However, when I run my code now I am getting a problem. Access 97 now will not use the Trim$ function is an SQL statement, I get a message that the function is not available. Trim$ will work outside of an SQL state
  • How to check if a date exists
    by HMote
    10 Replies
    Last post by HMote
      • Could anyone point me in the right direction I just need a way to see if a date exists...example: "6/31/07" doesn't exist, whereas "6/30/07" does exist. Thanks!
  • Clearing a manually created indent for a paragraph
    by kkrishna
    3 Replies
    Last post by Andy Pope
      • I am testing the process of removing indents from headings. I created a manual tab indent (pressed Tab and created an indent for the heading text). Now I want to remove this indent by code. I tried the following: oPara.Outdent oPara.TabIndent(-1) oPara.TabStops.ClearAll The above codes were tried individually and collectively. I was not able to clear the indent created. Ho
  • BSM 2005 Server Installation Failed
    by Jayaprakash Lingamaneni
    1 Replies
    Last post by MS ISV Buddy Team
      • Hi All We are trying to install Business Scorecard Manager 2005 Single Server Installation. We are getting error "Failed Microsoft Sharepoint Extended Site". We can able to create a new website and extend another web site from Central Administration. Please help me how to fix this error
  • Internet Explorer 7 jpeg and gif blurry after tools/internet options/advance/reset
    by remitdlo1944
    5 Replies
    Last post by bbenz3
      • I was working on another problem and reset my advanced options. After all my jpeg and gifs now are fuzzy when displaying in only internet explorer 7.0.5730.11 all other programs display normal.
  • API and OpenGL in VBA for Excel
    by Spinor
    7 Replies
    Last post by @sanya
      • How to use in VBA for Excel such API functions like, SetPixel, GetPixel, LineTo, PolyLine or ArcTo acting on the new created standard UserForm or in the special new window opened by appropriate API function. I know that it is trivial within VB applications, whereas VBA makes troubles (handle address of UserForm). I would be grateful for some simple examples (which have been tested and work well).