re: Hey, Scripting Guy! How Can I Tile Workbook Windows in Microsoft Excel?

Excel newbie — Wed, 30 Nov 2011 20:36:34 GMT

It's very difficult to find the answer in this mass of words. How about a link to a webpage that just gives the answer and nothing else?

re: Hey, Scripting Guy! How Can I Tile Workbook Windows in Microsoft Excel?

labar0ness — Wed, 21 Apr 2010 22:17:01 GMT

Hey, Scripting Guy!

I have three comma-separated values files I would like to import into one Excel workbook with three worksheets. How do I do that with VBScript or Powershell? I have a VBScript that works for one file. But, I can't figure out how to get the other csv files to open and save in the same workbook in a separate worksheet.

Set objExcel = CreateObject("Excel.Application")

objExcel.Visible = True

objExcel.displayalerts=false

Set objWorkbook = objExcel.Workbooks.open(srccsvfile)

Set objWorksheet1 = objWorkbook.Worksheets(1)

objWorksheet1.SaveAs srcxlsfile, 2

Any assistance would be greatly appreciated.

-MM