I have built a macro to import and format a dynamically generated webpage.
Now using WinXP with SP2 update and Office 2003, the macro works fine.
Here is the snippet of import code:

With ActiveSheet.QueryTables.Add(Connection:= _
        "FINDER;http://imv81:8080/PhoneList/app?service=page/PhoneListByName",
Destination:=Range("A3"))
        .Name = "PhoneListByName"
        .FieldNames = True
        .RowNumbers = False
        .FillAdjacentFormulas = False
        .PreserveFormatting = True
        .RefreshOnFileOpen = False
        .BackgroundQuery = False
        .RefreshStyle = xlInsertDeleteCells
        .SavePassword = False
        .SaveData = True
        .AdjustColumnWidth = True
        .RefreshPeriod = 0
        .WebSelectionType = xlSpecifiedTables
        .WebFormatting = xlWebFormattingNone
        .WebTables = "4"
        .WebPreFormattedTextToColumns = True
        .WebConsecutiveDelimitersAsOne = True
        .WebSingleBlockTextImport = False
        .WebDisableDateRecognition = False
        .WebDisableRedirections = False
        .Refresh BackgroundQuery:=False
    End With

Now using SP1 or windows 2000, there seems to be a bug in 
Office/Windows where the application launches the "Text Import Wizard"
instead of doing a "Web Page" import.  Now I am wondering if anyone
has experienced this and whether there is a work-around for this?

Thanks.

check here...it is free and the help you will get is immeasurable

http://www.mrexcel.com/board2/viewforum.php?f=2

I don't seem to find anything helpful on that link.

It appears that prior to SP2, anything that does not have the following
file extensions:
*.htm; *.html; *.mht; *.mhtml

Will be interpreted as a text file and so the "Text Import Wizard" is
launched.

After SP2, the document is parsed to 'guess' the file type and the proper
import is used.

Now I need to find a way to get pre-SP2 machines to do this.

It appears that creating a Web Query and using it instead of
trying a webpage import directly is a work-around for this
problem.