I want to use Solidworks macro to open an existing excel file and create a new sheet every day.

Is there a way to be able to do that?

Certain commands that seems to work in Excel API does not work in solidworks api.

Can any one help me?