Hello every1

i am writing a macro where in i should be able to open a htm file from a directory and again save it into another directory in the same htm format, but this should happen from inside the excel file


IN DETAIL

i download a htm file everyday from the net and save it to D:\Downloaded Files\contract.htm

Then i open the file and copy the data from the htm file to excel, close the htm file and then save it to d:\Data\2009\Nov\18-Nov-2009.htm (the date and month is the date when the htm file is downloaded)

My Requirement

when i run the macro the file contract.htm should automatically open and after i copy the data it should automatically rename itself to current date and save itself to the desiganated folder (d:\Data\2009\Nov)[it should save in folder Dec when the december month starts]

Please help me
Thanks in advance
sibalamit