help required related LCS(Live Communication Server).

ISV Open Discussions

Index ‹ Microsoft ISV

- Previous
  - 1
    - Comparing two word documents Try to use the property .Content of the object Document or .text of the Selection or the Range, but... Maybe if Code Snippet a = Documents("MyDoc1").Content a = Replace(a, Chr(13), "") 'remove the symbols of the paragraphs a = Replace(a, Chr(1), "") 'remove the symbols of the pictures b = Documents("MyDoc2").Content ''''''''''''''' If a = b then msgbox ":)" Tag: help required related LCS(Live Communication Server).
  - 2
    - adding controls to multipage at runtime Hi, Try this. The Extensibility library is not required for this. The MSForm library is but a reference is automatically created when you add a userform. Dim MyTextBox As msforms.Control Private Sub imgMap_Click() Set MyTextBox = MultiPage1.Pages(2).Controls.Add("Forms.TextBox.1", "MyTextBox", Visible) End Sub Tag: help required related LCS(Live Communication Server).
  - 3
    - Access forms - record change event Found it. On current event on the Form is the event I required along with the on cahnge event on the field Tag: help required related LCS(Live Communication Server).
  - 4
    - Reference to a String Global variable I don't support globals but they are handy on occasion. Adamus Tag: help required related LCS(Live Communication Server).
  - 5
    - LBound and UBound functions Hi, I believe those functions are in the Visual Basic for Applications library. Although not exposed via the object browser. Are you not able to use these functions Tag: help required related LCS(Live Communication Server).
  - 6
    - Convert Excel sheet to PDF using VB macro in Excel Move the thread from Visual Basic General. The question is mainly on VB macro development. There are more exports on Marco in Visual Basic for Applications forum. I believe you can get the satisfying answers in this forum. Thanks again for your question. Tag: help required related LCS(Live Communication Server).
  - 7
    - Problem: Macro not deleting columns I select Hi, Your code in an isolated test does exactly as expected. Selects columns C:F and deletes them. Have you used the debugger to step through the lines of code F8 will step you through line at a time so you can see exactly what is happening. You might also want to consider posting some more of your code. Tag: help required related LCS(Live Communication Server).
  - 8
    - Protecting formulas in cells Hi, Not that I know of without protecting the sheet. What does 'coding formulas' actually mean Tag: help required related LCS(Live Communication Server).
  - 9
    - Checking the status of autofilter Hi Here is some code mostly copied from the help text Dim rsp If Worksheets("Sheet1").AutoFilterMode = True Then rsp = MsgBox("Filter On", vbOKOnly) Else Worksheets("Sheet1").Range("A1").AutoFilter _ field:=1, _ Criteria1:="Otis" End If Tag: help required related LCS(Live Communication Server).
  - 10
    - vlookup for a range of cells Hi, If the names on sheet2 are in the same order as on Sheet1 then you could use the INDEX formula rather than VLOOKUP. Firstly set the LinkedCell property of the listbox control to a spare cell, for example sheet2!c1 The this formula can be entered into B1 and filled down 30 rows. B1: =INDEX(Sheet1!$B$1:$D$30,ROW(),Sheet2!$C$1) Tag: help required related LCS(Live Communication Server).
  - 11
    - Accessing a subform, error 2455 The error happened inside the Form_Current event. Moving the code to another place, not related to the current event, caused the error not happen again. I don't know the reason, but this is how it was thanks Tag: help required related LCS(Live Communication Server).
  - 12
    - Using arrows to select in drop down list in access Hi, To display the dropdown part use ALT+Down Tag: help required related LCS(Live Communication Server).
  - 13
    - activate a sheet containing a specific chrtobject Hi, You would need to activate the parent parent of the chartobject. aCH.Parent.Parent.Activate Tag: help required related LCS(Live Communication Server).
  - 14
    - Overflow (error 6) It may not be the obvious and nothing to do with the Double data type. It could be an error within the expression itself. For example, the date functions (Year, Month etc) return NULL if the time argument is NULL, which obviously can't happen if you're passing Now(), but it's got to be something along those lines. Perhaps have each component part of that expression write to the debug window so if the error happens again, you can see what the individual components are equating to. Tag: help required related LCS(Live Communication Server).
  - 15
    - Adding Outlook signature using OLE automation. I have the same problem and did not found a solution yet. Searching MSDN brought up nothing. About your second point: I don't use the mehtods GetNamespace and GetDefaulfolder: Create OLE-objects O_Outlook, O_MailItem and O_Attachment O_MailItem = O_Outlook.CreateItem O_MailItem.To = H_Recipient O_MailItem.HTMLBody = H_Text O_MailItem.Save Tag: help required related LCS(Live Communication Server).
  - 16
    - Once copied, can we export as a GIF file? I assume you're talking about simply taking a screenshot of the viewable range of the MS Excel document for insertion into a MS Word document. Do you need to do this programatically If not, just hit PrtScr on your keyboard, paste it into MS Paint, save it, and insert it into the Word document. If you need to do this in a program, you've got two obstacles to overcome as I see it: 1.) VBA doesn't provide a "native" method for taking screenshots (as far as I know). I believe you'll need to access the API to do this. If this does turn out to be the case, I can help you out with code. 2.) VBA has no support for converting bitmap images (which is the format your screenshot would be in) into .JPG or .GIF files. You'd need to use external libraries. If you can provide a bit more information on what you need to do and why, I can give you much more specific advice on how to solve the problem. Tag: help required related LCS(Live Communication Server).
- Next
  - 1
    - this problem is also troubling me now!! :( >> Is it possible to connect to a SharePoint site and retrieve a document from a machine where the SharePoint is not installed by using the SharePoint object model It looks like it's not possible. I need to do a similar thing (connect via OM on Sharepoint from a machine where Sharepoint is not installed) and after my researchs, it appears that it's not possible: you need to use the Web Services. HTH Bye Tag: help required related LCS(Live Communication Server).
  - 2
    - Internet Explorer 7 jpeg and gif blurry after tools/internet options/advance/reset You might try checking the zoom level you have set in the bottom right of the status bar of IE. See if setting to 100% fixes the issue. -brenda (ISV Buddy Team) Tag: help required related LCS(Live Communication Server).
  - 3
    - WMI.Net 2.0 As far as I know there's no beta program yet. There's a web cast on the technology available here: http://www.microsoft.com/events/webcasts/library/200606.mspx At the end of the session, the Program Manager announces that the plan (at time of the presentation) was: start a beta program after they are done with Vista (which was completed just a couple of weeks ago) ship WMI 2.0 as part of next version of .NET Framework (code named "Orcas" (watch this space for "Orcas" info and downloads: http://msdn2.microsoft.com/en-us/vstudio/aa700830.aspx ) -Michel Tag: help required related LCS(Live Communication Server).
  - 4
    - Word document Hi Friends I have two word documents.I have to compare the both documents.The difference between the two document is that the second documents contains an image,insert some data or delete some existing data.I am able to find the changes and store the result in another document in which the changes reflects.Now our main moto is how can the end user identify that there is a change of only image in both the documents without opening the word file. Thank & Regards Tag: help required related LCS(Live Communication Server).
  - 5
    - iexplore.exe - Application Error I get the exact same message. Have you found any answers What have you tried to do Tom Tag: help required related LCS(Live Communication Server).
  - 6
    - How do I deal with files of more than 65k rows? Well, you need to read the file yourself. And then populate each cell into multiple sheets. Or You can split up the csv file into multiple csv files and open them using Excel csv reader. I personally prefer the first approach because I need to put ' in front of zip code or zero leading IDs. Tag: help required related LCS(Live Communication Server).
  - 7
    - Using VBA macro to locate next free column on worksheet Try this to validate a column is empty or not. I know that I can make this more compact, but I can kind of too lazy, hehe. The Find function is basically a general driver for the same Find function in VBA, but take cares of error massage, and return boolean of found or not found. The Find_inOneColumn is self explaintory, general for all value. And the ColumnIsEmpty is the special case you want. You may want to think about treating a cell contains " " (spaces) is empty or not. Function ColumnIsEmpty() As Boolean ColumnIsEmpty= Not Find_inOneColumn("*") End Function Function Find_inOneColumn(vWhat As String, Optional vAfter As Range, _ Optional vLookInFormulas As Boolean = True, Optional vByPart As Boolean = True, _ Optional vMatchCase As Boolean = False, Optional vSearchFormat As Boolean = False) As Boolean If IsNull(vAfter) Then Set vAfter = Range("A1") Dim CurrentCol As Long CurrentCol = vAfter.Column If Find(vWhat, vAfter, vLookInFormulas, vByPart, False, vMatchCase, vSearchFormat) Then If CurrentCol = ActiveCell.Column Then Find_inOneColumn = True Else Find_inOneColumn = False End If Else Find_inOneColumn = False End If End Function Function Find(vWhat As String, Optional vAfter As Range, _ Optional vLookInFormulas As Boolean = True, _ Optional vByPart As Boolean = True, Optional vByRows As Boolean = True, _ Optional vMatchCase As Boolean = False, Optional vSearchFormat As Boolean = False) As Boolean If IsNull(vAfter) Then Set vAfter = Range("A1") vAfter.Select Dim vLookInFormulas2, vByPart2, vByRows2 If vLookInFormulas Then vLookInFormulas2 = xlFormulas Else vLookInFormulas2 = xlValues End If If vByPart Then vByPart2 = xlPart Else vByPart2 = xlWhole End If If vByRows Then vByRows2 = xlByRows Else vByRows2 = xlByColumns End If On Error GoTo FindByRow_Error_Handle Cells.Find(What:=vWhat, After:=ActiveCell, LookIn:=vLookInFormulas2, _ LookAt:=vByPart2, SearchOrder:=vByRows2, SearchDirection:=xlNext, _ MatchCase:=vMatchCase).Activate 'MatchCase:=vMatchCase, SearchFormat:=vSearchFormat).Activate Find = True Exit Function FindByRow_Error_Handle: Find = False End Function Tag: help required related LCS(Live Communication Server).
  - 8
    - Setting a Bookmark to insert a Page Break in MS Word Is this what you wanted Code Snippet Sub Insert_BKMK_PageBk() Selection.Bookmarks.Add "MyBookMark" Selection.InsertBreak End Sub Cheers Shasur Tag: help required related LCS(Live Communication Server).
  - 9
    - Macro - Replacing Contents of Cells Here is a simple sub that does that for you Code Snippet Sub Replace_For_Rachel() Dim rGCol As Range Dim sB2Text As String Set rGCol = Range("G2:G" & CStr(Range("G:G").Cells.SpecialCells(xlCellTypeLastCell).Row)) sB2Text = Range("B2").Value For Each gcell In rGCol If gcell.Value = sB2Text Then gcell.Value = 1 Else gcell.Value = 0 End If Next gcell End Sub Cheers Shasur Tag: help required related LCS(Live Communication Server).
  - 10
    - Getting data from other workbooks Hi Would it not be simpler to put a formula in cell B2 referencing the cells in the Slave sheets Tag: help required related LCS(Live Communication Server).
  - 11
    - Run Time Error 9 when Calling a Userform Hi, Error 9 is a 'Subscript out of range'. so for example referencing a worksheet that does not exit will raise that error. MsgBox Worksheets("Sheet99").Name or trying to access an element of an array beyond the bounds of the array. Dim vArray(3) As Variant vArray(4) = 1 But without seeing any of your code it's pretty hard to guess exactly whats wrong. Tag: help required related LCS(Live Communication Server).
  - 12
    - Excel CheckBox - Enabled "False" but I don't want it grayed out Hi, Set the Locked property to TRUE. You can change the value with code but not by clicking. Tag: help required related LCS(Live Communication Server).
  - 13
    - iexplore.exe - Application Error I get the exact same message. Have you found any answers What have you tried to do Tom Tag: help required related LCS(Live Communication Server).
  - 14
    - Parse AIM Buddy List Export file and Import to LCS 2005 Client Did you every successfully get the script working to get the AOL buddy list into LCS Tag: help required related LCS(Live Communication Server).
  - 15
    - How to make a macro to copy some parts of a table to an email that it will create? upz for today! Tag: help required related LCS(Live Communication Server).
  - 16
    - Automatically send attachment in email with a submit command button in word What errors are you seeing Tag: help required related LCS(Live Communication Server).

kultuze

i wanted to make a client that will get the status/username of the user from the LCS and initiate a collaboration chat session between the LCS users and between my client application.........is it possible our nt .

Top

Re: help required related LCS(Live Communication Server).

MS ISV Buddy Team

Hi,

Your best bet for an answer to this question is to post to one of the LCS newsgroups.

This page is an excellent resource for Live Communications Server 2005: http://www.microsoft.com/technet/community/newsgroups/server/livecomm.mspx

Here you'll find links to a general LCS newsgroup and a developer newsgroup, both of which have a number of LCS experts available to assist. They will likely be the best bet for a detailed answer. :-)

-brenda (ISV Buddy Team)

Top