Wrox Programmer Forums
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 25th, 2005, 07:19 AM
Authorized User
 
Join Date: May 2004
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Default Search a text

Hi all,

I presume it is a question of rather Word VB, but maybe somebody could help me.

I am saving a html document from a site (Chamber of Commerce) and I want to create a macro that searches the text and saves the names of the shareholders into an Excel spreadsheet, in certain cells.
The names appear after the string "Name:". How can I search and select the following 3 words (or 25 characters) after "Name:"?

Thanks for all the previous advices,

Mihai

 
Old January 25th, 2005, 09:32 AM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 180
Thanks: 0
Thanked 0 Times in 0 Posts
Default

When you say seaches the text can you confirm that you want to search the visible text that you see in the browser and not the HTML tags etc background.

Cheers
Matthew

 
Old January 25th, 2005, 10:07 AM
Authorized User
 
Join Date: May 2004
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Matthew,

for me it is not important if I search the html or the document opened with Word or Excel. But as I'm not common to html I saw Word as a solution I could handle easier.
Perhaps you can give me clue with html...

Thanx,
Mihai






Similar Threads
Thread Thread Starter Forum Replies Last Post
New text search doesn't preselect search string planoie Visual Studio 2005 0 July 23rd, 2007 06:47 AM
Search all types of files containing text. salman Classic ASP Databases 9 April 6th, 2005 02:36 AM
Search Engine for Full-text Search Kala ASP.NET 1.0 and 1.1 Professional 2 August 29th, 2004 02:16 AM
HTML text search JAtkinson VS.NET 2002/2003 0 February 29th, 2004 10:17 PM
Search files containing text salman Classic ASP Databases 1 October 22nd, 2003 05:43 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.