Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 255 Character limit when opening URL's, any way around it?

Any way to get around the 255 character limit in a File-Open URL or External
Data Query?

I don't have any control over the length of the URL (which happens to be 257
characters). Does 2007 have this same problem?

Here is my URL breakdown, if someone can test this out for me:
format, 7 character: "http://"
server, 25 character: "intranet_svr.company.com/"
path, 5 character: "path/"
filename, 12 character: "csvlist.cgi?"
querypart, 208 characters:
"columnlist=field1,field2,field3,field4,...&"
"field1=somevalue,field2=...&"
"outputtype=csv"

Amazing how quickly those characters can get used up, but they do.

Any way to configure the filename limit?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 255 Character limit when opening URL's, any way around it?

For clarification, I'm using Excel 2003 now (sp3).

Can anyone confirm that 2007 isn't affected? My previous version wasn't,
but since I just got a new PC with 2003 on it, I don't know which version I
had.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a character limit within a cell? Allyson Excel Discussion (Misc queries) 1 September 14th 06 02:02 AM
Character limit when printing Neil Conduit Excel Discussion (Misc queries) 1 June 1st 06 01:54 PM
Character limit in cell Jan Excel Discussion (Misc queries) 3 April 21st 06 02:40 AM
255 Character Limit Colin Excel Discussion (Misc queries) 2 March 2nd 06 07:58 PM
Character limit in an Excel Row Denise Excel Worksheet Functions 1 October 6th 05 02:33 AM


All times are GMT +1. The time now is 02:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"