Hi JP,

Is it possible for you to map part of the url then use in your vba code
the new map drive and add the rest of the url to have your full path. This
should shorten the entire url.

Stephane


"JP" wrote in message
m...
Working in Excel 2002 (XP) and VBA 6.3.

Trying to open up a web page in Excel. The address of the web page is
over 255 characters which appears to be in excess of the limit that
excel allows. The error received is that the address could not be
found. Is there a way around this?

The open method used in VBA is:
Workbooks.Open Filename:
The exact Error is:
Run-time error '1004':
Method 'Open' of object 'Workbooks' failed

Thanks in advance.
JM for MC