Microsoft ISV

Page 26




  • Topics
    Replies
    Last post
  • Access Mail Merged fields ( Values) in side the Macro as a variable.
    by doshivinod
    0 Replies
    Last post by doshivinod
      • Hi, I want to utilize the partial printing functionality of the word document. e.g. There is 40 page document out of these user may want to print only 10-20 pages. This page range info will be passed to document through mail merge data. ( Data Source is from SAP-ABAP). Depending upon values in this data I want to execute a 'Print1' macro with the variables.
  • VBA Merge question
    by Janfry
    3 Replies
    Last post by Peter Mo.
      • Hi (my English is not very good but i'll try it). When I link the datasource to the document, appears a dialog to select the text encoding. The Document.Open method has a parameter to specify the Encoding, but MailMerge.OpenDataSource does not include it. Is there any way to not appear that dialog Thanks, Janfry
  • 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
  • New lines in MS WORD
    by LeVraiNinjaneer
    2 Replies
    Last post by Shasur
      • Hi! I need to insert a "new line" into Word. (i.e. an <enter> ) I have two strings, say sen1 = "This is the first line." sen2 = "This is the second line." I know how to get "This is the first line. This is the second line." into Word, but I need "This is the first line. This is the second line." Please help!
  • 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(&
  • Where can I find information for "SignedVbScript Class "?
    by Jayaram Krishnaswamy
    0 Replies
    Last post by Jayaram Krishnaswamy
      • Signed VBscript Class and SignedJavascript class appear as drop-down choices for scripting languages supported in the ActiveX Script Task of the SSIS. Where can I find some reference to this class and class members Google search did not yeild any results nor did a search on MSDN.
  • Are these valid bucket ids ?
    by DHON
    14 Replies
    Last post by Claus Brod
      • Hi Jason, Saar, The reports at my end is having following bucket id : 456012092, 455976259, 455999458, 49984945. But these reports are not available in Winqual - atleast I can't see when I log in to Winqual. One of them is as old as 6 days. Others are one day. Could you please, confirm whether these are all valid bucket id If not then reason. Thanks, DHON
  • Cannot Find Library
    by HowDoIComeUpWithAUniqueName50
    8 Replies
    Last post by HowDoIComeUpWithAUniqueName50
      • I developed an application in VBA for office 2003. I tested and sent it to a client. Works fine on my machine but compiling or running it on their machine give the error "Cannot Find Library". It then highlights the function LCase$. I tried using LCase$ in the immediate window and it gives me the same error. I open the object browser (F2) and browse VBA. The String library shows as does
  • Update an MS Access Table Field using VBA
    by Mike S. Avelar
    1 Replies
    Last post by Luiz Claudio - MVP
      • Hi everyone! So, I have this tool I created for my team at work. I need to be able to update a numeric field in a table I have when the VBA code is excuted. I tried searching through the online help and a few forums, but I'm not exactly what I'm looking for so it may take me more time than just asking. So, the function that I want to create is to check and see if an action has happen
  • Directss Install
    by Edday
    4 Replies
    Last post by AzmathMoosa
      • hey i have written a program in Excel using VBA and it used a module called DirectSS which is like the application.speak but is much more customisable (speed, tone, visual) which is why i used it. When i got home, i went to work on it and DirectSS isn't installed on my computer. I have googled quiet abit and found next to nothing on DirectSS. Does anyone here know how to install it or where to get
  • Outlook 9.0 Object Library
    by KJ777
    1 Replies
    Last post by Andy Pope
      • I have an interesting problem with an Excel Spreedsheet that was created in Office 2000. The References used the Outlook 9.0 Object Library. I am able to run in fine moving from Office 2000 to Office 2003. When I move from a computer that has Office 2003, the spreadsheet is updated automatically to where the References use the Outlook 11.0 Object Library. The problem is when I need to use that spr
  • trying to highlight selection in a combobox on a userform
    by yoshikatsu
    3 Replies
    Last post by yoshikatsu
      • Hi, I have a combobox embedded in a frame in a userform. I populate the combobox and make its initial selection in the userform_initialize() event and then set the focus to that combobox. What I would like to do is for the current selection in the combobox to be highlighted (ie text and background inverted, like when you double-click on a word in text, so that the user knows that the first t
  • WoksheetFunction Doesn't Work With Currency Range
    by Qingping Cheng
    2 Replies
    Last post by Qingping Cheng
      • Hi All, I got a probelm with Excel VBA. I have a range named as "MyRange" with currency data. I would like to add up all currency numbers in the range. I used the following codes: Dim MyRange Dim MyCurrency MyRange=Range("A1:A3") MyCurrency=Application.WorksheetFunction.Sum(MyRange) MyCurrency returns only 0 whatever currency values in MyRange.
  • Imprting text file with no delimiters into excel file
    by Peck Chun Hua
    8 Replies
    Last post by Mezhick
      • hi anyone, i have a problem in creating a macros that will import an txt file into an excel file, the text file has no delimiters but every single different characters will have to be in a specific cell. For example in the first line, first 2 character belongs to excel cell A!, then next 10 characters is B1, then next 8 Character C1 and last 3 character is D1. Regards P.Chun
  • MOOS 2007
    by n_thobois
    0 Replies
    Last post by n_thobois
      • Windows SharePoint Services 3.0: Software Development Kit (SDK) and Windows SharePoint Services 3.0 Tools: Visual Studio 2005 Extensions: http://www.microsoft.com/downloads/details.aspx familyid=05e0dd12-8394-402b-8936-a07fe8afaffd&displaylang=en http://www.microsoft.com/downloads/details.aspx familyid=19F21E5E-B715-4F0C-B959-8C6DCBDC1057&displaylang=en I nee
  • Determining Access database format (2000 or 2002/2003)
    by Anonymous582637
    1 Replies
    Last post by Luiz Claudio - MVP
      • Does anyone know a way to tell in code if an Access database format is Access 2000 or Access 2002/2003 format
  • iexplore.exe - Application Error (EVERY TIME I CLOSE IE7) :(
    by sapphireoceans
    14 Replies
    Last post by Jillytodd
      • Hi, I am absolutely clueless as to why this keeps happening, but it is driving me insane!! The exact error message reads: 'The exception unknown software exception (0x0eedfade) occurred in the application at location 0x7c81eb33.' Could anyone shed some light on maybe what the cause is and/or how I can fix it Thank you in advance to anyone who reads and/or offers any information. Laura x
  • windiff.exe command line parameters LP, LU, LO, L
    by iamdacian
    0 Replies
    Last post by iamdacian
      • the windiff.exe / brings up a whole bunch of parameters that are very interesting and i would like to use, please see below. the problem is that i tried all kind of combination and i didn't manage to make windiff work from command line with perforce/source depot. any attempts to use parameters like LP, LU, LO, L it didn't responded correctly, most of the time silently opening the windiff UI. i eve
  • 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
  • New Certifications for VS 2008?
    by kbghost
    6 Replies
    Last post by Mahmoud Jameel
      • Will the new framework come with a new set of certifications Or are the 2.0 certs still going to be valid I ask this specifically about the Microsoft Certified Professional Developer. Should I wait for Oracas to be released to get certified Or just get it done with now
  • Reading CSV file into excel and using the data to get results
    by manu2008
    1 Replies
    Last post by Shasur
      • Hi I want to open a csv file with any no of rows and fixed no of colums from a loaction on the c drive ,i then need to search the rows for a particulat colum value and then if a value match is found,do certain manupulation with the colum values of tht particular row and display the results as a table in excel .I dont need to display the CSV file in excel...can anyone please help me ....i can op
  • Cell Equal To EXACT Value
    by Donaghy
    5 Replies
    Last post by Donaghy
      • Hi all, prob a very simple question for you guys. How do you check if a cell equals an exact value of "Product" I am currently using: Cells(i, 1).Text = "PRODUCT" though this is also picking up any cell which contains the word Product, such as cells which contain the word Production. So how do you check for an exact value
  • WSS 3.0 "This stock feature has been retired."
    by bafadam
    14 Replies
    Last post by cis365
      • What is this error No hits on google, nothing wrong with the page....nothing (that I know of) has changed recently. Anyone have any clue with this could possibly be referencing
  • Use excel to update records in a sql database or access
    by robace
    4 Replies
    Last post by Cringing Dragon
      • Can VBA code be written to modify records in a sql or access database I can write vba code to query a database very easily and pull out the data I need, but can I write back to that same source and modify/add records through vba
  • Getting The Content Of A Word Document?
    by KAMACI
    7 Replies
    Last post by KAMACI
      • How can i get my ActiveDocument's content