Microsoft ISV

Page 155




  • Topics
    Replies
    Last post
  • VBA for MS Word 03 - Open Unicode data file and assigning text in Chinese to a variable to display in Word
    by mjasj
    1 Replies
    Last post by John Oliver (UK)MSP, VSIP
      • Several years again (actually, over ten, now) I developed a rather elaborate macro in WordBasic for reading Chinese characters from a text file, followed by their English meaning and some other particulars. This data was read and displayed as text in a Word document. At the time, one Chinese character was specified by means of two ANSI character codes, and various combinations of software and Chin
  • Excel Command Button - Hide multiple sheets based on IF statement
    by suznal
    9 Replies
    Last post by suznal
      • I have a sheet in a workbook that acts as a sort of table of contents. All of the sheets in the workbook are listed in a column and the column to the left of each worksheet name is either blank or contains an ¡®X¡¯ depending on whether the sheet was used on a particular occasion. I have a command button on the page that will hide a sheet if a particular cell is empty. Currently this only wor
  • Newline in TextBox
    by une
    3 Replies
    Last post by Andy Pope
      • I tried to put some text in a TextBox as follows; TextBox1.Text = "Text = " & vbNewLine & testtext However when executed this code diplays the symbol for a newLine character (reversed bold "P" like symbol) between the two strings rather than actually placing the second string on a new line. This method of adding new lines works in a MsgBox, why not in a Te
  • A question from a beginner...
    by meisaka
    6 Replies
    Last post by meisaka
      • Hi all: I am new to the programming world, and I am interested in learning VBA. So, please provide some tips where should I start Thanks in advance.
  • How to allow cookies for Windows Live ID
    by Ralph Burns
    6 Replies
    Last post by Coqui88
      • Help me!
  • Office Communicator 2005 sign-in name, auto populate after install somehow?
    by markm75c
    14 Replies
    Last post by Mike@ALS
      • Does anyone know of a way to have the sign in name in communicator, auto filled in after an install or doing the install.. Basically every user has the same format.. first.lastname@domain for the login. I'd prefer to find a way to have this info auto entered after the install when it first tries to open. I'll be using communicator as a "broadcast" method.. and alot of users prob
  • Excel TextBox - Limiting amount of data entered including spaces, tabs and enter key
    by suznal
    1 Replies
    Last post by bi-lya
      • Sorry, another TextBox question... I inserted a text box on an Excel worksheet, and I want to limit the amount of data that can be entered. I have the following properties set to ¡®True¡¯¡­ EnterKeyBehavior, MultiLine, Wordwrap and TabKeyBehavior. I have MaxLength set to 760 as the textbox can accommodate a total of 760 characters, (95 characters per line and a total of eight lines)
  • Round a Value to Specified Number
    by Tantani
    2 Replies
    Last post by Tantani
      • Hello Guys, I am working in Access VBA 2003. And now I am working on Recordsets. I have a table named "Book" and within this table I have the attribute named "Quantity". The quantities of the books are defined in fraction numbers and I would to convert them to integer. I would like to defind a method to check and do the following thing: If i = 0.01 To 0.99 Then i = 0 OR If
  • How to show dates in forms by the order of time?
    by QianChen
    8 Replies
    Last post by QianChen
      • Hello, all, I have a little database which deals with patients paper work. I have two tables. One is patients' basic information like name, race, age, and so on. The other is the patient's paper work including the date when the patient finishes the paper work. So I have two forms. One if for the patients' basic information, the other form is a subform of it to show the paper work information
  • Problem with converting numbers stored as text in excel.
    by Mr T
    6 Replies
    Last post by MyLady
      • Hi, I'm trying to make a macro that converts numbers that are stored in textformat for example "1.987,00 kr" to normal numbers so I can process them further. To accomplish this I am trying to replace the . with nothing. When doing this manually in excel it all works fine but when I let the macro do it for me I a get really wierd outcome. when doing it manually the above example tur
  • export from access to csv with parameters
    by cristi84ro
    1 Replies
    Last post by Toblerone
      • i want to export a table from ms access to CSV file, but not in the standard format [comma delimited]. i would like to export fields delimited by * and I would also like the strings to be exported without the quotation marks (" ") so instead of: 1,"sample text",0,0 i would like to have: 1*sample text*0*0 thanks
  • How can I see the stack trace from the .mdmp file? [CLR version]
    by Vedratna
    2 Replies
    Last post by Vedratna
      • Hi can any one tell me what to do I have also tried it from the very begining as described earlier in this post. After getting another fresh crashdump from WER I have opened it in windbg; gives me following verbose output: Microsoft (R) Windows Debugger Version 6.6.0007.5 Copyright (c) Microsoft Corporation. All rights reserved. Extracted D:\Users\proseon\AppData\Local\Temp\00000f680_min
  • Convert decimal string to Chr$()
    by Jade_Emeperor
    8 Replies
    Last post by Jade_Emeperor
      • Hi. I'm currently writing a program for RFID using Visual Basic 6.0 But however I'm not sure how I can convert my decimal string to Chr$(). Because I currently wrote the code like this: Code Snippet decimal_string = CInt("&H" & hex_string) Char_String = Chr$(decimal_string) And an error pop up telling me that is an invalid procedure
  • 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.
  • 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
  • Opening CSV File produces date errors
    by Peter Mo.
    2 Replies
    Last post by Peter Mo.
      • Hi I get this problem with VBA under both Excel 2000 and XP. I'm running on a system with UK date format. When I open a CSV file containing dates from the normal Excel menus I don't get any problems. However, if I record the commands and use this to open the same CSV file I get the errors. Dates are in the format dd/mm/yyyy. if dd<=12 then I get mm/dd/yyyy i.e. it
  • Validation with List drop down?
    by Scott Boyd
    8 Replies
    Last post by Handyman_994
      • Hi I want to add some simple validation to my Excel sheet but can not for the life of me remember how to do it! Basically i have a drop down list as in the image below and want so that when 'No' is selected, the user is forced to enter the reason in the next cell http://i102.photobucket.com/albums/m82/sc0ttb_2006/excel_list.jpg I can remember doing this before and used some VBA code but c
  • Macro to copy Track Change commnets into an excel sheet
    by Vidya Vrat Agarwal
    1 Replies
    Last post by Shasur
      • Hello, I need help on to create a macro which will copy the para/line and its associated commnet from MS-word 2003 into excel 2003 sheet. Into two columns 1- para 2 -commnets Thanks
  • 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
  • VBA excel outlook / A program is trying to send mail using Item.Send
    by rhXX
    7 Replies
    Last post by LuisEG
      • hi, i am trying to send an automatic mail from excel VBA to the outlook outbox, when i send the mail i obtain this security warning: A progam is trying to automatically send e-mail on your behalf. the help buttom says: A program is trying to send mail using Item.Send A program is trying to automatically send e-mail using a Microsoft Outlook Visual Basic Application command, Item.Send. If you want
  • Delete Unwanted rows based on value in cell
    by Donaghy
    7 Replies
    Last post by magicalclick
      • Hi all, I have to loop through a range of rows with an excel sheet and delete unwanted data. To identify the rows to be deleted I have to do the following: Firstly I must start at A1 and check if it contains the value "Product", if not i go to the next row but if it does i must then delete this row and go to the next. I must then check that the next cell contains the value "
  • Excel VBA: Copying from file to file
    by rodcon
    3 Replies
    Last post by Peter Mo.
      • Thank you Mr. Dawson for your help with copying formats using Excel VBA. But I still cannot copy from a workbook that is part of a separate .xls file. The code works between worksheets of a workbook in one .xls file. If I try to copy from one file to another I get an "Error '9': Subscript out of range". This occurs even if I specify the path. Anyone have any thoughts 'refe
  • Microsoft CRM 3.0 rollup2 problem
    by cycloneV
    5 Replies
    Last post by dash999o
      • I am running outlook 2007 on a pc. I am trying to install CRM with the latest and greatest compatiability hotfixes. I am recieving the following error: Action Microsoft.Crm.Setup.Client.InstallPstAction failed. LaunchOutlookInstallerProcess failed Any help
  • Sharepoint Web Parts for Subsites
    by Peter O&amp;#39;Brien
    4 Replies
    Last post by AlexArun
      • This seems like a simple question but I've trawled the net and not found a simple answer. If I have a site on Sharepoint Server 2007 (Enterprise edition), and I create a few new subsites and workspaces, is there a web part that will show all subsites Or do I have to add individual links manually for each of the subsites to a list and then display the list through a webpart
  • Append Query Question
    by akn112
    3 Replies
    Last post by Luiz Claudio - MVP
      • My table has columns labelled  1) Item 2)Property 3) Quantity ie: Item        Property   Quantity Sugar      size        1 inch cubed Sugar      weight    10 grams Sugar     Append   Yes Salt