Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Deeppurple

    replacing a string from the field value

    thank you very much.
  2. Deeppurple

    replacing a string from the field value

    Hi all, I need to replace all occurances of a string 'abc' with 'def' from a string which a field value. How can I do it? I am using Oracle 8i. regards
  3. Deeppurple

    Power Point : selection across text frames

    ok. Let me explain again. Consider I have 3 slides, all with text frames. Now I select the the contents in the textframes of slide 1 and slide 2. I want to put some text at the start of the selection and some text at the end of the selection. How do I do that? My approach, right now, is to take...
  4. Deeppurple

    Power Point : selection across text frames

    Hi all, I want to put some text before and after the user selected text, in powerpoint. The user can select the text across text frames on a slide. I am using Office 2000. Right now what is happening is whenever i am selecting across text frames, each text frame is becoming a separate slide. How...
  5. Deeppurple

    Word: COM addin -CommandBarComboBox not firing events

    Hi all, I have a COM Addin toolbar with few commandbar buttons and one commandbarcombo box. The issue is, when i open word first time i.e parent window, the combo box onChange events is fired. but events are not fired, from child windows (ctrl+N) of the word. Events are fired only in fresh word...
  6. Deeppurple

    Disabling toobar while Excel worksheet being edited

    Hi all, I have a COM add-in, a toolbar, written in VB, for MS Word and MS Excel. I want to disable the toolbar whenever user is editing excel worksheet. On searching i found this can be done using Application.onKey. How to implement this in VB code. Can any body help me with this? Regards
  7. Deeppurple

    Issue while editing an excel worksheet

    Hi all, I have COM Add-in. I want to disable this whenever user is editing a cell, as it happenes for other toolbars in excel. I searched and found out it can be done using onKey method. But when and how to call this 'onkey' method. How to do this? -regards
  8. Deeppurple

    VBA:Issue with Generating TOC in Word 2000

    Hi all, I have an issue with Word 2000. I am able to generate TOC programmatically. But it works fine with Office xp. But same code throws error on word 2000. Sometimes it throws error like "Method ~ of object ~ falied" and sometimes "Automation error- server threw...
  9. Deeppurple

    How to write to a word document?

    Hi nikki, Thanks for the reply. But it doesn't work if selection includes any image or table. How to handle those scenarios? -regards
  10. Deeppurple

    How to write to a word document?

    Hi all, How to write to a document at a particular position? My requirement is, say if user has selected few words on his document,- "this is very beautiful"-, then i want to add few characters before and after this selection,-"abc 'this is very beautiful' abc"-,something...
  11. Deeppurple

    VBA:Generating Table of contents for MS Word

    Here is what I did. What i am doing is I am taking first sentence of every paragraph which is 'Bold' and adding it to the TOC. But I cannot see anything in Bookmarks. How do I find out if TOC already exists while recreating it? However the below code is working fine. Dim i As Integer...
  12. Deeppurple

    VBA:Generating Table of contents for MS Word

    Can you please elaborate on that, Rob. How do I generate TOC with only first 4 words on every paragraph? -TIA
  13. Deeppurple

    VBA:Generating Table of contents for MS Word

    Hi all, I am able to generate the TOC from the document but not the way I need. What i want is something like this. I want to put only first few words of every paragraph on the word document as part of TOC. As of now the whole paragraph becomes part of TOC. How do I do this? TIA
  14. Deeppurple

    VBA: PowerPoint

    I tried recording a macro, but to my disappointment the macro threw up a blank. Never mind below is a piece of code that works fine For Each sld In Application.ActivePresentation.Slides For Each shp In sld.Shapes If shp.HasTextFrame Then Set txtRng =...
  15. Deeppurple

    VBA: PowerPoint

    Hi all, I am trying read the slides of a powerpoint presentation. I want to search for particular words in the powerpoint presentation comprising of 'n' slides. How to read thru the all the slides? -TIA
  16. Deeppurple

    Excel: To get the cell values from the selected region

    Hi all, How can I get the values from all cells in the user selected region? My requirement is to replace the all values from the cells in the region with some other text. How can i do that? Any tips, links are welcome. (-:

Part and Inventory Search

Back
Top