URL too long in Excel (VBA).

  • Thread starter Thread starter JP
  • Start date Start date
J

JP

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
 
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
 
Hi,
That is not an Excel limit, it's an internet limit.


--
John
johnf 202 at hotmail dot com


| 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
 
Back
Top