Automate

Dear Experts,

Please assist to let me know how can i execute (background mode) winshuttle script with multiple data set excel files?

 via schedule job, its able to execute 1 script mapped to 1 data set file, looking forward for your guidance on how can execute (via schedule job) 1 script with multiple data set excel files.

Thanks,

Brijesh 

------------------------------
Brijesh Varma
JNTL Consumer Health (India) Private Limited
Mumbai
------------------------------

Hi Brijesh,

I would suggest you copy all datafiles into different worksheets in one single Excel workbook. You create a script per dataset in a specific worksheet, chain all scripts together into one big chained script which you publish in the workbook.

That should work ...

rgds, jan

Dear Experts,

Please assist to let me know how can i execute (background mode) winshuttle script with multiple data set excel files?

 via schedule job, its able to execute 1 script mapped to 1 data set file, looking forward for your guidance on how can execute (via schedule job) 1 script with multiple data set excel files.

Thanks,

Brijesh 

------------------------------
Brijesh Varma
JNTL Consumer Health (India) Private Limited
Mumbai
------------------------------

Dear Jan,

Thank you so much for your response, indeed chain scripting is of great help..

btw one more query i have, after script execution please help to guide on how can we append system date and time stamp to data excel file...

Thanks,

Brijesh

Hi Brijesh,

I would suggest you copy all datafiles into different worksheets in one single Excel workbook. You create a script per dataset in a specific worksheet, chain all scripts together into one big chained script which you publish in the workbook.

That should work ...

rgds, jan

Dear Experts,

Please assist to let me know how can i execute (background mode) winshuttle script with multiple data set excel files?

 via schedule job, its able to execute 1 script mapped to 1 data set file, looking forward for your guidance on how can execute (via schedule job) 1 script with multiple data set excel files.

Thanks,

Brijesh 

------------------------------
Brijesh Varma
JNTL Consumer Health (India) Private Limited
Mumbai
------------------------------

hi Brijesh,

Since all info is contained in the Winshuttle log, the way I create a total overview of such a full upload: in a separate sheet of an upload workbook, I insert a number of formulas looking for :

1. number of errors
2. number of uploaded materials
3. eventually a date & time stamp could be possible: (take in this case A4 is the logging of one of the scripts I ran), then I insert this formula giving date & time stamp: =IF(ISERROR(FIND("Date",A4)),"",MID(A4,FIND("Date",A4),40))

this is a complete logging of such a chained script on one upload workbook:

(left column: content of the cell as a copy of Winshuttle log, 2nd column: worksheet name, as a indication of which part of the upload)

hope that helps ...

kind regards, jan

Dear Jan,

Thank you so much for your response, indeed chain scripting is of great help..

btw one more query i have, after script execution please help to guide on how can we append system date and time stamp to data excel file...

Thanks,

Brijesh

Hi Brijesh,

I would suggest you copy all datafiles into different worksheets in one single Excel workbook. You create a script per dataset in a specific worksheet, chain all scripts together into one big chained script which you publish in the workbook.

That should work ...

rgds, jan

Dear Experts,

Please assist to let me know how can i execute (background mode) winshuttle script with multiple data set excel files?

 via schedule job, its able to execute 1 script mapped to 1 data set file, looking forward for your guidance on how can execute (via schedule job) 1 script with multiple data set excel files.

Thanks,

Brijesh 

------------------------------
Brijesh Varma
JNTL Consumer Health (India) Private Limited
Mumbai
------------------------------

Dear Jan,

Thank you so much for your note,

Once these dates are determined into excel cell (e.g. A4) then please assist to guide how can i save the excel file with Original file name + date and time stamp?

Thanks,

Brijesh

hi Brijesh,

Since all info is contained in the Winshuttle log, the way I create a total overview of such a full upload: in a separate sheet of an upload workbook, I insert a number of formulas looking for :

1. number of errors
2. number of uploaded materials
3. eventually a date & time stamp could be possible: (take in this case A4 is the logging of one of the scripts I ran), then I insert this formula giving date & time stamp: =IF(ISERROR(FIND("Date",A4)),"",MID(A4,FIND("Date",A4),40))

this is a complete logging of such a chained script on one upload workbook:

(left column: content of the cell as a copy of Winshuttle log, 2nd column: worksheet name, as a indication of which part of the upload)

hope that helps ...

kind regards, jan

Dear Jan,

Thank you so much for your response, indeed chain scripting is of great help..

btw one more query i have, after script execution please help to guide on how can we append system date and time stamp to data excel file...

Thanks,

Brijesh

Hi Brijesh,

I would suggest you copy all datafiles into different worksheets in one single Excel workbook. You create a script per dataset in a specific worksheet, chain all scripts together into one big chained script which you publish in the workbook.

That should work ...

rgds, jan

Dear Experts,

Please assist to let me know how can i execute (background mode) winshuttle script with multiple data set excel files?

 via schedule job, its able to execute 1 script mapped to 1 data set file, looking forward for your guidance on how can execute (via schedule job) 1 script with multiple data set excel files.

Thanks,

Brijesh 

------------------------------
Brijesh Varma
JNTL Consumer Health (India) Private Limited
Mumbai
------------------------------

good morning Brijesh,

This is how I do so: I work with read-only templates. On opening of a template, a little VBA-script checks if the filename is the name of the template, if so a new name is proposed which is the name of the template, extended with the date (Datum = Format(Date, "dd-mm-yyyy")) and initials of the user Environ("Username"). This ensures the working template is saved as a read-write template that has the date of execution in it, and is linked to the user.

Private Sub Workbook_Open()

Dim nieuwenaam, naam As String

naam = ActiveWorkbook.Name

Datum = Format(Date, "dd-mm-yyyy")

If naam = "33-upload material TEMPLATE.xlsm" Then
    voorstel = "33-upload material " & Datum & " " & Environ("Username") & ".xlsm"
    nieuwenaam = InputBox(voorstel, "take this name for your workfile ?", voorstel)
    If nieuwenaam = "" Then GoTo eind
    ActiveWorkbook.SaveAs Filename:="working directory" & nieuwenaam, FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
End If

eind:

End Sub

Dear Jan,

Thank you so much for your note,

Once these dates are determined into excel cell (e.g. A4) then please assist to guide how can i save the excel file with Original file name + date and time stamp?

Thanks,

Brijesh

hi Brijesh,

Since all info is contained in the Winshuttle log, the way I create a total overview of such a full upload: in a separate sheet of an upload workbook, I insert a number of formulas looking for :

1. number of errors
2. number of uploaded materials
3. eventually a date & time stamp could be possible: (take in this case A4 is the logging of one of the scripts I ran), then I insert this formula giving date & time stamp: =IF(ISERROR(FIND("Date",A4)),"",MID(A4,FIND("Date",A4),40))

this is a complete logging of such a chained script on one upload workbook:

(left column: content of the cell as a copy of Winshuttle log, 2nd column: worksheet name, as a indication of which part of the upload)

hope that helps ...

kind regards, jan

Dear Jan,

Thank you so much for your response, indeed chain scripting is of great help..

btw one more query i have, after script execution please help to guide on how can we append system date and time stamp to data excel file...

Thanks,

Brijesh

Hi Brijesh,

I would suggest you copy all datafiles into different worksheets in one single Excel workbook. You create a script per dataset in a specific worksheet, chain all scripts together into one big chained script which you publish in the workbook.

That should work ...

rgds, jan

Dear Experts,

Please assist to let me know how can i execute (background mode) winshuttle script with multiple data set excel files?

 via schedule job, its able to execute 1 script mapped to 1 data set file, looking forward for your guidance on how can execute (via schedule job) 1 script with multiple data set excel files.

Thanks,

Brijesh 

------------------------------
Brijesh Varma
JNTL Consumer Health (India) Private Limited
Mumbai
------------------------------

Dear Jan,

Sorry for my delay, was out of office..

Thank you so much for your note !

Apologize, maybe a basic question, how can we execute (automatically) above VBA script at a time when we schedule to run a winshuttle scripts.

Regards,

Brijesh 

good morning Brijesh,

This is how I do so: I work with read-only templates. On opening of a template, a little VBA-script checks if the filename is the name of the template, if so a new name is proposed which is the name of the template, extended with the date (Datum = Format(Date, "dd-mm-yyyy")) and initials of the user Environ("Username"). This ensures the working template is saved as a read-write template that has the date of execution in it, and is linked to the user.

Private Sub Workbook_Open()

Dim nieuwenaam, naam As String

naam = ActiveWorkbook.Name

Datum = Format(Date, "dd-mm-yyyy")

If naam = "33-upload material TEMPLATE.xlsm" Then
    voorstel = "33-upload material " & Datum & " " & Environ("Username") & ".xlsm"
    nieuwenaam = InputBox(voorstel, "take this name for your workfile ?", voorstel)
    If nieuwenaam = "" Then GoTo eind
    ActiveWorkbook.SaveAs Filename:="working directory" & nieuwenaam, FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
End If

eind:

End Sub

Dear Jan,

Thank you so much for your note,

Once these dates are determined into excel cell (e.g. A4) then please assist to guide how can i save the excel file with Original file name + date and time stamp?

Thanks,

Brijesh

hi Brijesh,

Since all info is contained in the Winshuttle log, the way I create a total overview of such a full upload: in a separate sheet of an upload workbook, I insert a number of formulas looking for :

1. number of errors
2. number of uploaded materials
3. eventually a date & time stamp could be possible: (take in this case A4 is the logging of one of the scripts I ran), then I insert this formula giving date & time stamp: =IF(ISERROR(FIND("Date",A4)),"",MID(A4,FIND("Date",A4),40))

this is a complete logging of such a chained script on one upload workbook:

(left column: content of the cell as a copy of Winshuttle log, 2nd column: worksheet name, as a indication of which part of the upload)

hope that helps ...

kind regards, jan

Dear Jan,

Thank you so much for your response, indeed chain scripting is of great help..

btw one more query i have, after script execution please help to guide on how can we append system date and time stamp to data excel file...

Thanks,

Brijesh

Hi Brijesh,

I would suggest you copy all datafiles into different worksheets in one single Excel workbook. You create a script per dataset in a specific worksheet, chain all scripts together into one big chained script which you publish in the workbook.

That should work ...

rgds, jan

Dear Experts,

Please assist to let me know how can i execute (background mode) winshuttle script with multiple data set excel files?

 via schedule job, its able to execute 1 script mapped to 1 data set file, looking forward for your guidance on how can execute (via schedule job) 1 script with multiple data set excel files.

Thanks,

Brijesh 

------------------------------
Brijesh Varma
JNTL Consumer Health (India) Private Limited
Mumbai
------------------------------