Delete entire row and column in a batch of excel files

Discussion forum for all Windows batch related topics.

Moderator: DosItHelp

Post Reply
Message
Author
ekpobobby
Posts: 1
Joined: 01 Feb 2014 12:16

Delete entire row and column in a batch of excel files

#1 Post by ekpobobby » 01 Feb 2014 12:22

Hello All, I need a batch code that will open all the excel files in a directory, delete the first row and first column and then save the files back in the same file extension

Squashman
Expert
Posts: 4488
Joined: 23 Dec 2011 13:59

Re: Delete entire row and column in a batch of excel files

#2 Post by Squashman » 01 Feb 2014 12:58

Cant be done with batch. You would need to do it with VBscript.

Post Reply