jon, i have a excel 2007 spreadsheet with a VBN which auto logs into 9
different web sites and puts in my user name and password, and than retreives
a bunch of data for each and formats it and dumps it into an excel
spreadsheet. it worked fine with excel 2003 for many years. i installed
excel 2007 and now when i run the macro it pulls up the 1st web address and
just sit at the login screen and will not put in the user name or password.
a send IE window also opens up behind it but it's always blank. is this a
VBN or excel 2007 problem
--
tks in adv for your help


"Jon Peltier" wrote:

There are no converters that I've heard of to convert VBA to Excel 2007 VBA.
Excel 2007 VBA is the same as prior Excel versions, except for additions to
the object model and for slight (but frustrating) differences in what works.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"OldDog" wrote in message
ups.com...
Hi,

I have a lot of code samples written for Excel 2000. When I try to
load them into Excel 2007 I get this message:

"This workbook has lost its VBA project, ActiveX controls and any
other programmability-related features"

It then directs me to search for "VBA converters" on the Microsoft
Office site. When I go there, I can't find what I am looking for.
Either it does not exist or I can't read. Any help for converting
these useful samples to something that Excel 2007 can use?


Old Dog