Jon,
Like yourself, I'm not familiar with VBN - when I first read the post I
thought he may have made a typo and meant VPN (Virtual Private Network) - but
that may not be the case. And I haven't a clue as to why Excel would have
anything to do with the functioning of a VPN anyhow.

"Jon Peltier" wrote:

Sorry, I don't know what VBN is, and I haven't tried Excel 2007 in the
context of web site data acquisition, so I cannot answer your question.

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


"pops69" wrote in message
...
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