All,

I am newbie to excel macros and using vba. I was given assignment to create a button which will prompt for the date then when one clicks submit or ok then it will append the date at the end of a link. Once the date gets appended to the end of the link then execute the link and once its finishes save the .xls file to a directory path.

Example of what date needs to look like when getting appended to the end of a link: (www.someurl.com&date=09/26/2012)

Can someone please point me in the right direction or show me an example of what i am asking for.

Thanks,
prodrigu