Microsoft ISV

Page 29




  • Topics
    Replies
    Last post
  • Remove Spacing
    by tclaus8
    2 Replies
    Last post by Duane in Japan
      • Ok, i need to check to see if there is a space at the end of a word like, "hello " instead of "hello". I know there is code to take off the spaces at the end if they exist. Can any1 help me out here
  • is it possible to write a function that returns a list of items?
    by Maximus
    2 Replies
    Last post by Maximus
      • I wonder if it's possible to do something like this: on cell A1 user writes =getList() and to get a list of numbers between 1..10 (on cells A2...A12, or A1..A10). In other words, the function returns some a list of numbers that are not in one particular cell. thank you!
  • CRM 3.0 Outlook Client
    by keithpsft
    9 Replies
    Last post by DavidJennaway
      • I have a question regarding the settings necessary for the CRM 3.0 Outlook client to be installed. I have the CRM and Exchange on seperate servers & networks, both running SBS 2003. I have the CRM server setup as localhost in my office, and Exchange is hosted off-site. Whenever I open outlook I am getting errors saying: "Your Web browser options are currently set to disable cookies. Mi
  • GroupBoard Workspace 2007
    by AnhVu
    1 Replies
    Last post by MS ISV Buddy Team
      • Hi I'm using GroupBoard 2007 and I feel it great application. But I can't modify some function if my customer require. In page Newform.aspx, I don't want "OK" button allow submit if time user choice coincide with time in free/busy board. Please help me! thanks
  • Need help writting a script similar to...
    by jdwilliams543
    5 Replies
    Last post by Derek Smyth
      • Sub CommandButton2_Click Me.Textbox7.Text = My.Computer.Filesystem.ReadAllText("C:\info.txt") End Sub I'm a newbie at VB all around, thought that the My namespace was part of the VBA build. I have no clue how to write this kind of script in VBA. Basicall, I have a file (C:\info.txt) that I need to copy all of the info in this file into a textbox (textbox7 to be exact) on the form when
  • 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
  • is it possible to write a function that returns a list of items?
    by Maximus
    2 Replies
    Last post by Maximus
      • I wonder if it's possible to do something like this: on cell A1 user writes =getList() and to get a list of numbers between 1..10 (on cells A2...A12, or A1..A10). In other words, the function returns some a list of numbers that are not in one particular cell. thank you!
  • How to change part of an array value in Excel
    by Gnanaprakash
    1 Replies
    Last post by MS ISV Buddy Team
      • Hi , Pls any body can tell me How to change part of an array value .If i try to change array value "Microsoft Excel" popups a dialog stating "You cannot change part of an array." Somebody have mention to use "Ctrl+Shift+Enter" but this will change entire array value.So I need a change a specific cell value. Code: Function parseArrayData(arrayData As String
  • Projects, objects & modules
    by une
    14 Replies
    Last post by une
      • I started learning VBA in MS Word yesterday. I have some programming experience in C++ and Java. I am trying to understand how the environment is structured and what Projects, Objects and Modules represent. For example I recorded a few macros using the macro recorder and then opened the VB Editor to see what was created. I notice that under "Project" are 3 folders. One is named
  • calling sub within function. works fine as sub, but not in function
    by pacificwaters
    11 Replies
    Last post by pacificwaters
      • Using VB 6.3. Trying to call a sub within a function, and when I call it in Excel via User-Defined-Function, it doesn't work. But when I do 'F8' to step into the code of the sub, it works fine: Public function functionEXE(...) call cellref end function Sub cellref() ' If I 'F8' and step into the code from here, it works fine. But when I execute the functionEXE on sheet.x
  • Macro to convert text to hyperlink
    by uma_unnikrishnan
    1 Replies
    Last post by Shasur
      • Hello All, I have some text that I export from a tool into Word..however this tool does not export hyperlinks as hyperlinks and hence I would have to convert the text in Word to hyperlinks.. I realize that this can possibly be done with macros..however am not in to macros and do not have much time to meddle with it.. so was just wondering if I can hold of a macro that I can use to search fo
  • calling sub within function. works fine as sub, but not in function
    by pacificwaters
    11 Replies
    Last post by pacificwaters
      • Using VB 6.3. Trying to call a sub within a function, and when I call it in Excel via User-Defined-Function, it doesn't work. But when I do 'F8' to step into the code of the sub, it works fine: Public function functionEXE(...) call cellref end function Sub cellref() ' If I 'F8' and step into the code from here, it works fine. But when I execute the functionEXE on sheet.x
  • Microsoft Office Document Imaging Printer Missing in Office 2007 (RFP) (86)
    by rjo2
    11 Replies
    Last post by andria72
      • Can anyone tell me how to install Microsoft Office Document Imaging Printer in Office 2007 (RFP). Although the Imaging program installs, the Printer does not, and the Microsoft Office 2007 Professional (86) Installer say that it is not an available feature.
  • Why my AddIns runs only once!?
    by Awsok
    3 Replies
    Last post by bi-lya
      • Hi All, I made 6 VBA Excel macro using Visual Basic Editor from within Excel, but after deploying the AddIns, my AddIns run only once and stop!! Here are the details: I made 6 macros and wanted to share them with my colleagues at work, in what I call it Add In library. I assigned shortcuts to the 6 Macros as follows Lnk2DB() (" Ctrl+Shift+a ") CHS
  • 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.
  • How can I activate worksheet when open a user form?
    by lyp_sj
    3 Replies
    Last post by Andy Pope
      • Hello, I used a user form to control several macro command. While after I poped out this user form, I could not activate any worksheets and modify my data. Do you know how I can activate worksheet when opening a user form Thanks so much! B.regards/Yaping
  • 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
  • Using DCount function in a Report group footer
    by LizF@RMIT
    6 Replies
    Last post by Cringing Dragon
      • Hi, I'm having trouble getting a DCount function to work on an MSAccess 2003 report. I'm using a text box in a group footer - I want it to show a count of the number of distinct records in the group. Here's what I'm using - which produces the result of '#Error' with no further help.: =DCount("Task ID","Tasks","TaskID IN (SELECT DISTINCT TaskID FROM
  • Macro running slowly when run from button
    by Gus the Snail
    4 Replies
    Last post by Gus the Snail
      • Hi there I have a curious situation. I have written a macro in VBA for excel 2003 which, from a master workbook scrolls through 46 other workbooks, opening each one in turn and copying/pasting a number of ranges. It then saves and closes the workbook and moves on to the next. When I execute this macro from within the VBA editor, it runs quite quickly (about 5 seconds per sheet, which is acc
  • Bucket ID 8, event type
    by Claus Brod
    14 Replies
    Last post by DHON
      • Hi all, on my Vista system, I generated a lot of crash reports using WER-aware code (i.e. code which explicitly uses WerReportCreate() and WerReportSubmit()). When I look at those crash reports in the Problem History window, I find that many of those crash reports have a bucket ID of 8. This doesn't look like a bucket ID as it would be assigned for a crash report which makes it to the Winqual site
  • MS Office document and image writer print driver
    by GTH
    14 Replies
    Last post by Mary3480
      • Besides removing this feature from Office during setup, is there a process to remove this virtual printer from 300 users with roaming profiles on an active directory network We are having an issue with this printer assuming the "default printer" selection for our users. As a work around we have changed their default printer, but after they reboot or log off / on it has defaulted back to
  • Setting properties
    by une
    4 Replies
    Last post by une
      • It seems that there are two ways to set a property. Using the example of a label on a userform, the property for it's initial caption and colour can be set by editing the appropriate fields in the properties window. That is easy, but these initial settings do not show up in any code on the userform. How could the initial settings for the caption and colour properties of the label be set via code i
  • Copy spreadsheet data to csv format
    by YYeung
    1 Replies
    Last post by Shasur
      • How can I want to export the spreadsheet data to the csv format by using vlookup function. For instance: When vlookup "AA", 1,2,3,4,5 in spreadsheet will be extracted to 1,2,3,4,5 in cvs.format. Thanks
  • Powerpoint VBA ¨C Animate Text ¨C Seconds delay between letters
    by NME1963
    0 Replies
    Last post by NME1963
      • IĦŻm trying to set up an interactive sequence item that displays characters one letter at a time. The code below works well to achieve this, but does anyone know how to set Ħ° seconds delay between lettersĦħ (or words - or % delay between letters if another msoAnimEffect is chosen). I seem to be able to set every timing/animation feature except this one!!! Any help would be very much apreciat
  • Word 2003 AutoOpen Macro doesn't run if Outlook 2003 is open.
    by aliank
    5 Replies
    Last post by bi-lya
      • Good day experts, I written a word template with AutoOpen macro in order to load an object that will update footnote of the word document when user save the document. It works well when outlook is not loaded. But once outlook is loaded, the AutoOpen macro did not run anymore. If I open the document without opening outlook first, then automacro is working fine. But if I open the Outlook and then o