I'm trying to download a table of data from a website for my company...in a macro. It downloads as CSV format (no problem!) and I've been looking up ways to access the site however the problem is, as I said, the URLs too long.

Bear with me a bit here as I'm still at macros101 and a little light on the computery details of the database server. the site's on the company intranet and from what I know, it's a front end lookup for a SQL database done in java or flash or something like that (graphicky fades, swipes, and buttons. ends in .jsp). I talked to the guy that made it and was told just use the URL to get the data plus "&csv=1" tagged on the back to download it as a CSV file automatically. Now, I do it manually, daily (with a check box to download as CSV) and once the .CSV file is in hand, data manipulations easy.

The URL to retrieve the data is 1815 characters long. (2/3 of a page in word with the default formatting. 10pt font and zero margins it's still 16 lines) the 255 character limit for excel to open URLs (at least that's what it appears) doesn't even finish the first part of the URL to get one condition for one room (264chars). shortened version: http....website.jsp&querytype&groupby&starttime&endtime&condition1=true&condition2=true&room1&room2&room3.... total of 42 conditions and 90 rooms (engine testing lab, bunch of dyno test cells. how much they're running and if not, why)

So: Can I get excel to open my 1815 character long URL? Breaking it into sections would be fine since the start day and time need to change daily and it's obvious how to get only certain conditions or rooms at a time.