Naming Excel Sheet

[FrancescoDiMuro]

@water
If I have to use again the workbook that I've created with _Excel_BookNew(), it returns the error "Variable must be of type object".
Instead, If I use the _Excel_BookNew() first, and then I open it with _Excel_BookOpen(), it works smoothly ( like I wrote in the post #16 ) 
I don't know why, but I tried before writing here  

Edited March 17, 2017 by FrancescoDiMuro

[water]

[water]

Maybe the same problem that the object returned by _Excel_BookNew gets lost because the variable holding the object has a scope of Local?
Or you re-use the variable somewhere in your script?

[FrancescoDiMuro]

The variable I'm using is declared in the Global scope, and I use it in the same function 
So, since I'm not closing or deleting or re-declaring the variable, I don't why the variable becomes empty...
 

[antonioj84]

$DealerPicklist = IniRead(@ScriptDir & "\config.ini", "data", "Dealer", "")
    Local $sNewPickFolderPath = @DesktopDir & "\PickListCasa" ;folder to copy existing diretories while copying to desktop
    If Not FileExists($sNewPickFolderPath) Then DirCreate($sNewPickFolderPath)

                
        $oExcel = _Excel_Open(False) ; invisible
        ;$oExcel = _Excel_Open(True) ;visible
        $datawb = _Excel_BookOpen($oExcel, $DealerPicklist, False, "", "Casa321")
        If @error = 1 Then
            MsgBox(0, "Error!", "Unable to Create the Excel Object!, please reboot")
            Exit
        ElseIf @error = 2 Then
            MsgBox(0, "Error!", "File does not exist!")
            Exit
        EndIf
        $datawb.worksheets("StoreCasa").Select
        

                Sleep(15)
        $savewb = $sNewPickFolderPath & "\" & $checknum & "CasaPickList.xlsx"
        _Excel_BookSaveAs($datawb, $savewb, $xlWorkbookDefault, True, "", "Casa321")
        _Excel_BookClose($datawb, True)
        _Excel_Close($oExcel, True)

Can someone assist or give me an idea how to resolve.

the current code works the spreadsheet stay hidden, ONLy if there is no spreadsheet open at the desktop. However if there is a spreadsheet open at the desktop, it will hide that one, however my hidden spreadsheet will now become visible.

[water]

Set parameter $bForceNew in _Excel_Open to True and the UDF will start an independant new instance which doesn't interfere with an already running instance of Excel.

[antonioj84]

5 hours ago, water said:

Set parameter $bForceNew in _Excel_Open to True and the UDF will start an independant new instance which doesn't interfere with an already running instance of Excel.

 

thanks it works

[water]