Calling Find/Replace Dialog Box in MS Office
Calling Find/Replace Dialog Box in MS Office
Calling Find/Replace Dialog Box in MS Office
Calling Find/Replace Dialog Box in MS Office
Calling Find/Replace Dialog Box in MS Office
Calling Find/Replace Dialog Box in MS Office Calling Find/Replace Dialog Box in MS Office Calling Find/Replace Dialog Box in MS Office Calling Find/Replace Dialog Box in MS Office Calling Find/Replace Dialog Box in MS Office Calling Find/Replace Dialog Box in MS Office Calling Find/Replace Dialog Box in MS Office Calling Find/Replace Dialog Box in MS Office
Calling Find/Replace Dialog Box in MS Office Calling Find/Replace Dialog Box in MS Office
Calling Find/Replace Dialog Box in MS Office
Go Back  Xtreme Visual Basic Talk > > > Calling Find/Replace Dialog Box in MS Office


Reply
 
Thread Tools Display Modes
  #1  
Old 03-01-2004, 12:52 AM
thevbgirl thevbgirl is offline
Freshman
 
Join Date: Nov 2003
Posts: 25
Default Calling Find/Replace Dialog Box in MS Office


Hi,
Just had this simple question/query regarding VB.NET.

Using VB.NET, is it possible to 'call' the inbuilt "Find/Replace" Dialog Box in MS Word, MS Excel and MS PowerPoint and perform search/replace for a term?

If possible, then can somone guide me with the code to do it in case of MS Word.
Thanks,
thevbgirl
Reply With Quote
  #2  
Old 03-01-2004, 09:39 AM
Mike Rosenblum's Avatar
Mike Rosenblum Mike Rosenblum is offline
Microsoft Excel MVP

Forum Leader
* Guru *
 
Join Date: Jul 2003
Location: New York, NY, USA
Posts: 7,848
Default

Are you willing to learn to do this in VBA instead? It would be 100x easier.
It would look somethng like this:
Code:
Dim SearchRange As Excel.Range Dim FoundCell as Excel.Range Set SearchRange = ThisWorkbook.Worksheets("Sheet1").UsedRange Set FoundCell = SearchRange.Find("Hello")
But there is a list of parameters for the Find Method that can be used to refine your search which can be found in Help. The .FindNext and .FindPrevious methods are also useful.

Using this in .Net, however, requires a fair amount of changes to the code. I would start by having a read here: Automating Office Programs with VB.Net.

Then come back and let us know which way you want to go, and we'll do our best to help!

,
Mike
__________________
My Articles:
| Excel from .NET | Excel RibbonX using VBA | Excel from VB6 | CVErr in .NET | MVP |
Avatar by Lebb

Last edited by Mike Rosenblum; 03-01-2004 at 05:12 PM.
Reply With Quote
  #3  
Old 03-02-2004, 03:03 AM
thevbgirl thevbgirl is offline
Freshman
 
Join Date: Nov 2003
Posts: 25
Default Find/Replace in Powerpoint tables

Hi Mike,
Thanks a zillion for the reply. I am presently using VBA Macros built into MS Word, Excel and PowerPoint for the purpose. However, I find serious limitation with this technique.

One of the limitations I have been struggling with recently is to do a find/replace within Tables in PowerPoint slides.

Can you offer some suggestions.
Thanks,
TheVBGirl
Reply With Quote
  #4  
Old 03-02-2004, 04:21 AM
herilane's Avatar
herilaneCalling Find/Replace Dialog Box in MS Office herilane is offline
Unashamed geek

Retired Moderator
* Expert *
 
Join Date: Jul 2003
Location: London, England
Posts: 8,988
Default

Since your follow-up question is not related to VB.Net any more, could you please post it in the VBA forum.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MsFlexGrid & VBA msl Word, PowerPoint, Outlook, and Other Office Products 2 09-17-2006 04:21 PM
Help needed: Template and Common Dialog in VB6 baufay API 1 04-28-2004 04:27 AM
have you noted that the dialog win of office 2003 in help-about is different from... mbira Interface and Graphics 1 02-08-2004 06:04 PM
Common Dialog Tutorial MikeJ Tutors' Corner 0 06-04-2003 10:12 PM
Office 2000 Common Dialog orufet General 1 07-28-2001 04:59 PM

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Calling Find/Replace Dialog Box in MS Office
Calling Find/Replace Dialog Box in MS Office
Calling Find/Replace Dialog Box in MS Office Calling Find/Replace Dialog Box in MS Office
Calling Find/Replace Dialog Box in MS Office
Calling Find/Replace Dialog Box in MS Office
Calling Find/Replace Dialog Box in MS Office Calling Find/Replace Dialog Box in MS Office Calling Find/Replace Dialog Box in MS Office Calling Find/Replace Dialog Box in MS Office Calling Find/Replace Dialog Box in MS Office Calling Find/Replace Dialog Box in MS Office Calling Find/Replace Dialog Box in MS Office
Calling Find/Replace Dialog Box in MS Office
Calling Find/Replace Dialog Box in MS Office
 
Calling Find/Replace Dialog Box in MS Office
Calling Find/Replace Dialog Box in MS Office
 
-->