02/04/10 17:02
trittico69
questi sono due file
Si posso unire in modo da diventare un unico file vbs?
il secondo file dovrebbe rimanere aperta il file
\CEDINFOSERVER\UfficioPosta\RUBRICA.XLS
primo file
Dim XL
Dim wB
Set XL = CreateObject("EXCEL.APPLICATION"
XL.Visible = True
Set wB = XL.Workbooks.Open("\CEDINFOSERVER\UfficioPosta\RUBRICA GENERALE MASCHILE.XLS"
Set wB = XL.Workbooks.Open("\CEDINFOSERVER\rotonda\MATTINALE TR2.xls"
XL.DisplayAlerts = False
XL.ActiveWorkBook.Close
Set wB = XL.Workbooks.Open("\CEDINFOSERVER\RepartoA\MATTINALI.xls"
XL.ActiveWorkBook.Close
Set wB = XL.Workbooks.Open("\CEDINFOSERVER\Femminile\MATTINALI REPARTO FEMMINILE.xls"
XL.ActiveWorkBook.Close
Set wB = XL.Workbooks.Open("\CEDINFOSERVER\Femminile\Transex.xls"
XL.ActiveWorkBook.Close
Set wB = XL.Workbooks.Open("\CEDINFOSERVER\RepartoB\mattinali.xls"
XL.ActiveWorkBook.Close
Set wB = XL.Workbooks.Open("\Cedinfoserver\rotonda\TR1 - Allegato 3.xls"
XL.ActiveWorkBook.Close
Set wB = XL.Workbooks.Open("\CEDINFOSERVER\CentClinico\ELENCO DETENUTI --.xls"
XL.ActiveWorkBook.Close
secondo file
Dim XL
Dim wB
Set XL = CreateObject("EXCEL.APPLICATION"
XL.AskToUpdateLinks = False
XL.Visible = True
XL.DisplayAlerts = False
Set wB = XL.Workbooks.Open("\CEDINFOSERVER\Casellario\RUBRICA.XLS"
XL.ActiveWorkBook.SaveAs "\CEDINFOSERVER\UfficioPosta\RUBRICA.XLS"
'XL.DisplayAlerts = False
XL.ActiveWorkBook.Close(True)
XL.Quit()
Si posso unire in modo da diventare un unico file vbs?
il secondo file dovrebbe rimanere aperta il file
\CEDINFOSERVER\UfficioPosta\RUBRICA.XLS
primo file
Dim XL
Dim wB
Set XL = CreateObject("EXCEL.APPLICATION"
XL.Visible = True
Set wB = XL.Workbooks.Open("\CEDINFOSERVER\UfficioPosta\RUBRICA GENERALE MASCHILE.XLS"
Set wB = XL.Workbooks.Open("\CEDINFOSERVER\rotonda\MATTINALE TR2.xls"
XL.DisplayAlerts = False
XL.ActiveWorkBook.Close
Set wB = XL.Workbooks.Open("\CEDINFOSERVER\RepartoA\MATTINALI.xls"
XL.ActiveWorkBook.Close
Set wB = XL.Workbooks.Open("\CEDINFOSERVER\Femminile\MATTINALI REPARTO FEMMINILE.xls"
XL.ActiveWorkBook.Close
Set wB = XL.Workbooks.Open("\CEDINFOSERVER\Femminile\Transex.xls"
XL.ActiveWorkBook.Close
Set wB = XL.Workbooks.Open("\CEDINFOSERVER\RepartoB\mattinali.xls"
XL.ActiveWorkBook.Close
Set wB = XL.Workbooks.Open("\Cedinfoserver\rotonda\TR1 - Allegato 3.xls"
XL.ActiveWorkBook.Close
Set wB = XL.Workbooks.Open("\CEDINFOSERVER\CentClinico\ELENCO DETENUTI --.xls"
XL.ActiveWorkBook.Close
secondo file
Dim XL
Dim wB
Set XL = CreateObject("EXCEL.APPLICATION"
XL.AskToUpdateLinks = False
XL.Visible = True
XL.DisplayAlerts = False
Set wB = XL.Workbooks.Open("\CEDINFOSERVER\Casellario\RUBRICA.XLS"
XL.ActiveWorkBook.SaveAs "\CEDINFOSERVER\UfficioPosta\RUBRICA.XLS"
'XL.DisplayAlerts = False
XL.ActiveWorkBook.Close(True)
XL.Quit()
aaa