how to send all objects in a sheet to Excel file

[#1]

hai,

can anyone tell how to make all the objects in a sheet should send to Excel file. This action should be done by Button click.

Please share your ideas on this.

Thnks

[#2]

Hi,

This could help you, just check

Thanks & Regards

[#3]

hai,

when i am testing the macro edit script its showing black color in line where

Set XLApp= CreateObject("Excel.Application")

can you check it reply me why it is not giving exact result.

Thnks

[llauses243]

Hi venkat,

For me all ok, only you must verify name sheet ...

Good luck, Luis.

[llauses243]

Hi venkat,

Also you must to check Module Security ...

Good luck, Luis.

[#6]

hi thanks for reply,

After selecting "Allow System Access" it is working fine but now another line it is showing in Black color i.e,

Set XLDoc= XLApp.Workbooks.Add.

Please check this and say why it is getting error .

Thnks