macro for export to excel in specific folder

[panipat1990]

Dear Team,

I have a requirement. In my Application 10 Sheets.

And Each Sheet Contain 2  Straight Tables. Means 20 Reports. I want to make a macro which make report from each sheet.

One by one.

Which macro i used.Kindly Guide me.

[tripatirao]

Hi,

Please look into this.

This May help you.

!

[panipat1990]

In my Application 10 Sheet.And 20 Straight Table.

i want to One after one Export in excel.

So Which Macro you sent it is run or not.

Because when i click button as sent by you then Only Macro window open.

But i want to 20 table export in excel in specific folder.