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
Bookmarks