Microsoft ISV

Page 7




  • Topics
    Replies
    Last post
  • Can you use VBA to access a spread sheet embedded in a word doc?
    by Trisped
    13 Replies
    Last post by Trisped
      • I am trying to use VBA code written in MSWord to access an embedded spread sheet. I can't find any documentation on how this is suppose to work. Does word access the sheet through an instance of excel Is the sheet part of the document so I can find it in the "ThisDocument " I have tried everything I can think of, so any help would be appreciated.
  • Excel Macro to insert characters
    by GB Allan
    2 Replies
    Last post by GB Allan
      • Hi, I would like to write a macro that would do the following: Go straight down a column of numbers. Each cell in this column would only contain either a 4 character number or a 6 character number. If 4 characters, I want to insert "-00" at the end of the string (e.g., 4421 becomes 4421-00) If 6 characters, I want to insert a dash between the 4th and 5th characte
  • INSERT INTO string Object into Access table
    by Andy576879
    2 Replies
    Last post by Andy
      • Hello After running script I 've got error "Too few parameters Expected" for test I try to put only one string in table "StudyTrack" with one column "Status" if I use instead string object "strStatus" ('abc') it is working fine ,but SQL don't see string Object. I suppose it syntaxes error, but I can not find the right one. I would really
  • Exporting files to Sharepoint
    by SkiGeek
    4 Replies
    Last post by SkiGeek
      • I am working in visio and have a number of sheets. Each of these sheets apear in a number of document. My documents link to Exported jpeg's of these sheets. I want to create a Macro that Exports all work sheets to jpeg's in one step. I have it working locally but Normally the document is saved to and edited on the sharepoint. I recieve an error when running the macro when the document is s
  • 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
  • Is there a today() function in VBA?
    by Derek at Potters Clay
    3 Replies
    Last post by Shlizar Axis
      • I've been trying to get the current date a few ways in VBA. I tried using the today() function in a spreadsheet and getting the data from that cell and also calling it explicitly in a vba script and have had no success. any help will be appreciated.
  • Run-Time Error 1004 : The Text you have entered is not a Valid reference or defined name
    by Christopher Zinger
    1 Replies
    Last post by Christopher Zinger
      • Alrighty So this seams like a really simple line of Code... I am using Excel 2007 I have narrowed my error down to this silly line of code. The Error i am getting is 1004: The text you have entered is not a valid reference or defined name... Sheets("Items").Range("ItemNumberHeader").CurrentRegion.AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= (
  • 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
  • Obtain Unique Work Units via SQL
    by AlDeb
    14 Replies
    Last post by AlDeb
      • Below is the SQL I have for a Query. The results of my query are below the code. Everything works great except for the WorkUnit totals. I am getting the total Records for the date range and I really need the Unique workUnits for the date range. For this particular daterange I have a total of 197 WorkUnits but in reality there really are only 89 Unique WorkUnits. In the example below on on
  • Exporting files to Sharepoint
    by SkiGeek
    4 Replies
    Last post by SkiGeek
      • I am working in visio and have a number of sheets. Each of these sheets apear in a number of document. My documents link to Exported jpeg's of these sheets. I want to create a Macro that Exports all work sheets to jpeg's in one step. I have it working locally but Normally the document is saved to and edited on the sharepoint. I recieve an error when running the macro when the document is s
  • Updating links in Powerpoint with VBA
    by dh273
    2 Replies
    Last post by dh273
      • I'm having problems with Powerpoint VBA. I have pasted blocks of cells from Excel into Powerpoint using Paste Special -> Paste Links-> Microsoft Excel Worksheet Object, and set the updating to manual. I'm trying to get some VBA code that will update all the links in my presentation. Essentually, the code that would do the same as me going to Edit-> Links, selecting all the links and click
  • A question on the ISV/Software Solutions competency customer reference requirements
    by DmytroL
    5 Replies
    Last post by MS ISV Buddy Team
      • 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
  • 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"
  • How to configure CER with no dialog?
    by John Brown
    14 Replies
    Last post by Claus Brod
      • I just tried to configure my XP SP2 workstation to send crash reports to a CER file share such that no dialog box would be presented. It didn't work as expected. ReportFault returned frrvErrNoDW and no crash report showed up in the file share. I have the 'Configure Error Reporting' policy enabled and a corporate file path entered. This works fine when I elect to 'send report' through the dialog bo
  • excel chart
    by paxa
    2 Replies
    Last post by paxa
      • hi. i'm a little newb in vba and excel can anyone help me get this problem figured out i have some charts in an excel worksheet, and what i would like is to select a chart, assign the the series values for it that are in another sheet and then select another chart and do the same again any help would be appreciatted thanks in advance
  • Does Winqual accept WER reports from Vista systems?
    by Claus Brod
    14 Replies
    Last post by Jason Hardester - MSFT
      • Hi all, we recently registered for the Winqual site. Reports are coming in about crashes in our application which occur on Windows XP systems, so it seems like the whole registration process worked as expected. However, we also ran our application (same version as on XP) on Vista, and provoked several crashes (same type of crashes as the ones on XP) there - but don't see *any* reports on the Winqu
  • Gantt in Acess
    by Toblerone
    7 Replies
    Last post by LCarato
      • Hi all, I have an app in which I need to create forms and controls on the fly (A form that designs itself from table data). That part i have solved and it works perfectly. The problem i'm faced with is not being able to create forms once the db is compiled and converted to .mde I have been reading about workspaces. My idea is to create a workspace and generate the forms in that. None of the forms
  • 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.
  • hung app help for web developer
    by ftriantos
    4 Replies
    Last post by Johnny20
      • This is not a spyware or temporary internet files problem, I am a developer at a large website and the few clients who receive this error get it on every IE browser they encounter (we have logged in as them in a lot of places). I figured I would get that clear from the start. The problem is probably related to iframes and some DHTML, but it works well in Mozilla Firefox for all. When IE (6)&nbs
  • Copying and Deleting the duplicate records in an excel sheet and Copying the same Deleted records into another sheet
    by bharat baradia
    4 Replies
    Last post by magicalclick
      • hi, i want to delete the duplicate rows in the excel sheet and copy the same deleted records into another excel sheet by using Macro's . This should be possible even when i am selecting two columns for checking duplicates and even if one of the column is repeated ( is duplicate) it should be considered as a duplicate.
  • Macro called twice on single button click
    by Don0531
    4 Replies
    Last post by perkinscraig
      • Hi, The macro attached to the excel button is called twice on a single button click. This happens for the first time, when I click the button after opening the workbook. When I try to debug, it calls the macro only once. Its quiet strange. Could any of you help me on this regards. Thanks Ron
  • How can I see the stack trace from the .mdmp file?
    by Vedratna
    14 Replies
    Last post by Vedratna
      • hi, everbody we have recently created account in winqual and also successfully mapped our product over there. We also receive some error reports(buckets) in it. We have downloaded some of them in form of cabinet file. After extracting it we get the file having extension of .mdmp. I have opened it in windbg through open crash dump option. It opens it successfully but I can't see any stacktrace i
  • Closing desktop opened word wants to close embedded word object
    by Rick_in_Alpharetta
    1 Replies
    Last post by Rick_in_Alpharetta
      • I have an Access program that I am using to build Word documents. If while the document is being built (which can be lengthy) I open Word on the desktop and then close it, Word asks me if I want to save the doc that is being built by the program. Of course if I say yes/no then the program gets the rug pulled out form underneath it. I can say cancel and things will go on their merry way but then th
  • Creating my own object in VBA
    by Douglas Penna
    3 Replies
    Last post by Douglas Penna
      • I've searched the forums, but I haven't found an answer or example in VBA. I'm trying to create an object, so I can wrote the program easily. In my object, there are variables, subs, functions and another objects as well. My problem is how to define the functions and subs. Here's my object: Private Type T_Vertice 'My secondary object      Moneyness As Double ' data &nbs
  • .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