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

SUHAS December 3, 2011

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
    Copying and pasting a worksheet to a different excel workbook

    Merge all CSV or TXT files in a folder in one worksheet

    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.

    -- 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.