making a macro to pull a spreadsheet from a changeable link

I am working on a spreadsheet that will allow a sup to change dates and then with their sup id it will generate a link to a performance website where they can download their teams data. I am trying to make a macro to do this automatically, however, =hyperlink has issues with links over 256 characters and this is a concatinated link which is much longer. Any help writing this script would be amazing. I have tried to do this multiple times and searched google for additional assistance to no avail.

Basically i want to allow a supervisor to enter dates (already setup), enter their id already setup and then click an update data button (already setup) and have a macro use the link created (which gives a popup box to open or save the spreadsheet) and save the data to a data.xls file and then automatically copy that data file to the data tab.. (or even open the data copy it and then plug it into the data tab...

The problem i have is the hyperlink code won't work and i can't seem to get anything to work properly

First the link:

CONCATENATE("http://mybusinessdata/corporatedata/Performance%20Viewer/Files/SpreadsheetExport.aspx?grpg=Agent&jde=&spr=",B6,"&mgr=any&bu=any&st=any&tnr=any&trnr=any&trnrnm=any&clid=any&clst=&clend=&rptst=",TEXT(A15,"yyyy-mm-dd"),"&rptend=",TEXT(A16,"yyyy-mm-dd"),"&maxprs=false&excludeterms=true&sgrpg=none&cols=min")

Now the script i have tried... unsuccessfully i might add..

Please Login or Register  to view this content.

It doesn't work.. and that one tries to open the link save it as data.xls and then open it again and copy paste into the data tab..

Thanks for any help!

Charles

I posted this the other day and have not been able to get any responses. Is this not possible or did I post this in the wrong area?

I waited as long as i could wait before cross posting. I got a solution or part of one at the following forum.

http://answers.microsoft.com/en-us/o...0-aaba428a5ef4

This can be closed.