First time here? We are a friendly community of Power Systems Engineers. Check out the FAQ!

Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

asked May 22 '13

anonymous user

Anonymous

Is there any way to prevent pssexcel from closing excel

I am running a couple of macros off of excel.

These macros then launch batch files which run python macros, who in turn convert PV results to excel using the pssexcel function.

However, once I Import pssexcel, it closes all of the excel sheets that are already open, and as such I cant copy the PV results onto the output spreadsheet.

Any Ideas?

click to hide/show revision 2
No.2 Revision

Is there any way to prevent pssexcel from closing excel

I am running a couple of macros off of excel.

These macros then launch batch files which run python macros, who in turn convert PV results to excel using the pssexcel function.

However, once I Import pssexcel, it closes all of the excel sheets that are already open, and as such I cant copy the PV results onto the output spreadsheet.

Any Ideas?

click to hide/show revision 3
No.3 Revision

Is there any way to prevent pssexcel from closing excel

I am running a couple of macros off of excel.

These macros then launch batch files which run python macros, who in turn convert PV results to excel using the pssexcel function.

However, once I Import pssexcel, it closes all of the excel sheets that are already open, and as such I cant copy the PV results onto the output spreadsheet.

Any Ideas?