excel_OperateStart

Excelを起動

関数名：

excel_OperateStart

引数：

$true｜$false

戻り値：

無し

例：

excel_OperateStart("$true")

EXCEL_OPERATESTART( VISIBLE )

Let(

Script="

if (($excel -eq $null)-Or($excel.Name -eq $null)){

try {

$excel=$null;

Remove-Variable excel;

$excel =[System.Runtime.InteropServices.Marshal]::GetActiveObject('Excel.Application');

} catch {} finally{}

}

if (($excel -eq $null)-Or($excel.Name -eq $null)){

$excel=$null;

Remove-Variable excel;

$excel = New-Object -ComObject Excel.Application;

}

$excel.Visible = {Visible};

$excel.Name;

"

;

SMPS_ExecSync(

Substitute ( Script ;

["{Visible}" ; Visible] /*$true｜$false*/

)

)

)

/*

230190418修正前

if ($excel -eq $null){

$excel = New-Object -ComObject Excel.Application;

}

$excel.Visible = {Visible};

*/

/*

20170630 追加2018/09/07

if ($excel.Visible -eq $null){

↓修正

if ($excel -eq $null){

*/