Can I use a .bat file to copy data from one spreadsheet to another?

SUHAS December 3, 2011
Pinterest Stumbleupon Whatsapp

Can I use a .bat file to copy the columns from an existing excel sheet into another? I’ve tried but the rows and columns become jumbled. I just want to copy data automatically in the existing template.

  1. Anonymous
    December 4, 2011 at 7:31 pm

    Copy data from one sheet to another using VBA
    http://www.computing.net/answers/office/copy-data-from-one-sheet-to-another-using-vba/11317.html
    Copying and pasting a worksheet to a different excel workbook
    http://www.pcreview.co.uk/forums/copying-and-pasting-worksheet-different-excel-workbook-t3868939.html

    Merge all CSV or TXT files in a folder in one worksheet
    http://www.rondebruin.nl/csv.htm

  2. FIDELIS
    December 4, 2011 at 4:07 am

    Hello, probably if you convert your excel sheet or column to CSV, XML or text(tab delimited) you could add that file to your batch file.  Make sure to make a copy of your file.  Work on the copy...not the main file.

    http://creativyst.com/Doc/Articles/CSV/CSV01.htm

    -- open excel
    -- open the excel sheet
    -- once open click on save as
    -- choose other format like any of the following:

    XML Data (.xml)
    CSV (comma delimited) (.csv)
    Text (tab delimited) (.txt

    -- add new file name to batch file
    -- run it.