locked
Vbscript Excel Workbook Visibility RRS feed

  • Question

  • I have a Vbscript which opens a new Excel workbook and write data formatted data from a text file into it.

    Now while the script is running and if i open Excel manually, the workbook which the script is running on, also gets opened(visible). What should i do to assure that the workbook is not visible to the users who open the Excel Application manually.

    Following is the code used:

    set objExcel = CreateObject("Excel.Application")
    set objWorkbook = objExcel.Workbooks.Open(xlsFile)

    'code to enter data

    objExcel .ActiveWorkbook.SaveAs path

    objExcel.Quit

     

    Thanks,

    Deep Patel

    Wednesday, December 1, 2010 5:28 AM

All replies