Answer Questions

• edward1028 Search all text objects - PowerPoint VBA

  I need something very urgent. I am creating a search function for a custom addin. My search function ritght now searches only text placeholders. Is there any way of searching all text objects (text placeholders, textboxes, etc..) I don't think I need to go into text like text on graphs, more so pure text objects. Does anyone have any ideas Thank you for your help. Hey all. I solved my problem. Click link below to view my solution Click here to view solution ...Show All

• bilalso iexplore.exe - Application Error

  I get the following error message when I close my internet explorer. The instruction at "0x62304320" referenced memory at "0x62304320", The memory could not be "read". Click on OK to terminate that program. Any ideas what is causing this after fixing prob. stated prev. now get THIS error msg. "The instruction at"0x02302bf2" referenced memory at"0x029b6aa8" the memory could not be "read". Is there no end to these error msgs Hello i would like to know how to fix this problem on my computer. If there is away please let me know so i can fix it. Tracyb On t ...Show All

• MaggieChan Public access to a Windows Live Communication Server (LCS)

  Hi. First of all I don't know if this is the right section of the forum to put this question. I want to make a proof of concept to a company and to develop my application I need to sniff the packets that Office Communicator Mobile exchange with the LCS. I've installed LCS on a VMWare machine and I can log in to it with MSN 5.1 on the same machine where the LCS is installed. I've put another machine on the same domain that I create on the LCS server and still can make login with MSN 5.1 My problem is giving access to a machine that is unable to join the domain... I can ping the machine with the LCS server but when I try to do a REGISTER it returns a 401 Unauthorized and I can't login. Can anyone explain me who can I give public access to t ...Show All

• MtgFanatic iexplore.exe - Application Error

  I get the following error message when I close my internet explorer. The instruction at "0x62304320" referenced memory at "0x62304320", The memory could not be "read". Click on OK to terminate that program. Any ideas what is causing this I don't use the Yahoo tool bar and I get a similar message when I close Ie 6.. "The instruction at "0x02653812" referenced memory at "0x0277bb2c". The memory could not be read. (All XP updates installed.) On the tool bar there is a pencil. Click that and then uninstal or use control panel. It sounds like you might have a badly-behaved control on your system, if y ...Show All

• Simon Heffer Refresh excel external data - then save macro

  I'm writting a little macro that refresh data from an external source, then saves the file. However, it starts to save to early, and I get a error message that saving will disrupt the refresh. How do I wait to save until everything is refreshed and calcualted It isn't entirely clear what you are doing but it sounds as if you could close the external file without saving and avoid the problem. I'm sorry I guess I was not that clear, I am refreshing data in two ranges, its a web request. I think the macro tries to save in between. ...Show All

• pcompassion OUTLOOK When trying to open Outlook, I get the following:

  Microsoft Visual C++ Runtime Library Runtime Error! Program:C:\Progra~1\Micros~3\Office10\OUTLOOK.EXE Any ideas Thanks Hi, Can you please be a little more specific What version of Office/Outlook are you running What operating system Can you provide the error message details and the steps that led up to this error You might find additional assistance on the Outlook newsgroup at http://www.microsoft.com/communities/newsgroups/en-us/default.aspx query=outlook&dg=&cat=en_US_d02fc761-3f6b-402c-82f6-ba1a8875c1a7&lang=en&cr=&pt=&catlist=&dglist=&ptlist=&exp=&sloc=en-us Also, have you searched for the error number in the Microsoft Knowledge ...Show All

• Ian Barber Compatibility Issue Excel 2000 and Excel 2003

  I wrote a macros for a customer in Excel 2003. He didn't tell me he used Excel 2000 until after the project and like an idiot I forgot to ask. The macros will not run on his version of Excel 2000. A compile error shows up. So he got a version of Excel 2003 and the macros will still not work for him. I have tested this macros on other machines using 2003 and they all work correctly for me. I live in the US and the customer lives in the UK. When he runs the macros it immediately goes into the debugging window and highlights a bit of code that simply references the path of the existing folder to a variable. The exact code is: DestFolder = ThisWorkbook.Path & "\" There is a compile error with a message that the data fold ...Show All

• kart Automating PowerPoint

  I have a vba procedure within a ppt presentation that creates a new presentation with a set of slides and saves it. This process is repeated until about 30 different presentations are created, but I would like to automatically execute it at a specific time so I don't have to run the code manually everyday. Can you please suggest how I can automically execute my vba code to run thank You! Jenise One possible way around the limitations of Powerpoint is to use Excel to automate powerpoint. As Excel workbooks support the AutoOpen event. You will need to port your code over to excel. And within the code create a reference to Powerpoint. No doubt your code will require other changes in order to wo ...Show All

• enric vives Access 2003: Connect to Word Document.dot and fill in DocVariables dynamically

  Hi, i hope i find a answer on this way. Let me describe my little ( i hope so...) problem: I would like to have my code figure out which fields are on the document and populate only those. I realized this with the following code: Sub sendToWord(DokPath, DokName) Dim strPfad As String strPfad = DokPath On Error Resume Next Dim objWord As Word.Application 'search instance of Word Set objWord = GetObject(, "Word.Application") If Err.Number = 429 Then 'no instance found Err.Clear Set objWord = CreateObject("Word.Application") 'create instance On Error GoTo Fehler ElseIf Err.Number = 0 Then ' nothing Else On Error GoTo Fehler End If With objWord .Visible = True . ...Show All

• pritha Setting a global variable and referring to it from a private sub routine?

  Hi, I am basically wanting to improve my code and make it more user friendly and error proof! Ok, so currently its based around a single user form which toggles on and off from a set command buttons which allows the user to view the from and select certain buttons which automate a lot of the tasks necessary from within the workbook. I have a different amount of records/rows in it each month and I display a pop up msg box asking the user to input the number of employees to be processed each time they click a button. This is grand and works fine but is not very user friendly and if they put in too many it messes up the data! So I got some feedback from these forums a while back saying that I should redo it and instead of ask ...Show All

• Chandresh LCS complience with IMS / SIP standards ?

  1. It seems, to register to Live Communication server from a SIP client, NTLS or Kerbaros authentication is a must. How to register from a SIP client which doesn't support NTLS or Kerbaros Is there any configuration required on LCS to acheive the same 2. If LCS doesn't support HTTP Digest Authentication then its not interoperable with SIP standard rfc 3261 and IMS Please correct me if I am wrong Please revert back !!! Best Regards, Deepak K Bramhapuriya Per our support engineer: Regarding following issue, our buddy has 2 questions on SIP standard in LCS. 1) How to register from a SIP client which doesn't support NTLS or Kerberos 2) Does LCS support HTTP Di ...Show All

• cybertaz69 How to get Sum of row members in ScoreCard?

  Hi, We have ben working on BSM 2005. We are not able to get the sum of row members in ScoreCard view. Say, I have a KPI as Total sales of various countries and their respective cities. For example: Total Sales $6000 India ( ) Delhi $1000 Calcutta $500 Bangalore $1000 USA ( ) New York $1000 California $2000 San Diego $500 (Country is a dimension and not a KPI) Now in the above case what should we do to get the total amount for each country depending upon it's cities (eg. India should show a total sum of $2500) We would really appreciate any help in this regard. Thanks. ...Show All

• yeos_lee Forms Text Input

  Hi All... I have an EXCEL workbook with two sheets A & B On Sheet A i have a Display Page with Various vlookups from Sheet B ... I created a Form which has a text box '1' with a number which is taken from Sheet A (a3) & an other empty text box '2' which is also taken from sheet A (comments d5).... What i need is a string that takes the text that is inputted in t extbox2 on the form finds the number which is on textbox 1 on Sheet B and inserts the text in same row but in the a different column of sheet B . I hope u can help me ...cos i am going nuts !!! Here's a quick script I whipped up that will do what you want. You'll need to tweak it a bit to make it fit your needs exactly. B ...Show All

• edukulla Combo Box Issue

  I have a main form and a sub form linked by cust id The cust id is a combo box on the main form using the following code Private Sub Combo31_AfterUpdate() On Error GoTo ErrorHandler Dim strSearch As String strSearch = "[CUSTID_HDW] = " & Chr$(34) & Me![Combo31] & Chr$(34) 'Find the record that matches the control Me.RecordsetClone.FindFirst strSearch Me.Bookmark = Me.RecordsetClone.Bookmark The problem I have is that I have a auto number on the sub form. If I select a custid from the main form and then select a item in the sub form the auto number creates a new record but if I then select a new custid from the combo box on the main form the auto number on the sub form deletes and the autonu ...Show All

• Rups11 SQL within a VBA Module

  Hi, I'm new to VBA and have only been using it for 3 months, so please don't laugh! I have a VBA routine in Excel, which connects to a SQL Server database, and I need to know how to incorporate an IF expression into the SQL statement. The SQL looks like this in the MS Access query I am trying to re-create: SELECT IIf(IsNumeric([PromoSource]),"REC",IIf(IsNull([PromoSource]),"OTHER",IIf([PromoSource]="WWW","Web",[PromoSource]))) AS [Promo Source], Count(dbo_tblCustomers.CustomerID) AS CountOfCustomerID FROM dbo_tblCustomers WHERE (((dbo_tblCustomers.DateEntered)>=#1/1/2006#)) GROUP BY IIf(IsNumeric([PromoSource]),"REC",IIf(IsNull([PromoSource]),"OTHER",IIf([PromoSource]= ...Show All