Vista - Deleting specific columns in an Excel spreadsheet...

01-21-2009

Hello all,

I'm a newbie when it comes to scripting so I apologize in advance.
I'm trying to create a script that performs three tasks:

1. Removes specific columns from an existing spreadsheet
2. Changes the date format in a particular column to mm/dd/yyyy
3. Saves the results as a .csv.

Is there any way to make this happen? I'm going to need help with the
full script, from beginning to end.

Thank you

01-21-2009

"centre21" <centre21@xxxxxx> wrote in message
news:5b86fec9-61fa-4e6d-a484-5e02fda4bb80@xxxxxx

Quote:

> Hello all,
>
> I'm a newbie when it comes to scripting so I apologize in advance.
> I'm trying to create a script that performs three tasks:
>
> 1. Removes specific columns from an existing spreadsheet
> 2. Changes the date format in a particular column to mm/dd/yyyy
> 3. Saves the results as a .csv.
>
> Is there any way to make this happen? I'm going to need help with the
> full script, from beginning to end.
>
> Thank you

Here you go:

Quote:

> 1. Removes specific columns from an existing spreadsheet

oSheet.Range("B1:B1").EntireColumn.delete

Quote:

> 2. Changes the date format in a particular column to mm/dd/yyyy

oSheet.Range("A1:A1").EntireColumn.NumberFormat = "mm/dd/yyyy"

Quote:

> 3. Saves the results as a .csv.

oExcel.ActiveWorkbook.SaveAs "d:\test.csv", 6

You'll have to put in a bit of your own time and effort to wrap it all up in
a complete script.

01-21-2009	#1 (permalink)
centre21 n/a posts	Deleting specific columns in an Excel spreadsheet... Hello all, I'm a newbie when it comes to scripting so I apologize in advance. I'm trying to create a script that performs three tasks: 1. Removes specific columns from an existing spreadsheet 2. Changes the date format in a particular column to mm/dd/yyyy 3. Saves the results as a .csv. Is there any way to make this happen? I'm going to need help with the full script, from beginning to end. Thank you
My System Specs

01-21-2009	#2 (permalink)
Pegasus \(MVP\) n/a posts	Re: Deleting specific columns in an Excel spreadsheet... "centre21" <centre21@xxxxxx> wrote in message news:5b86fec9-61fa-4e6d-a484-5e02fda4bb80@xxxxxx Quote: > Hello all, > > I'm a newbie when it comes to scripting so I apologize in advance. > I'm trying to create a script that performs three tasks: > > 1. Removes specific columns from an existing spreadsheet > 2. Changes the date format in a particular column to mm/dd/yyyy > 3. Saves the results as a .csv. > > Is there any way to make this happen? I'm going to need help with the > full script, from beginning to end. > > Thank you Here you go: Quote: > 1. Removes specific columns from an existing spreadsheet oSheet.Range("B1:B1").EntireColumn.delete Quote: > 2. Changes the date format in a particular column to mm/dd/yyyy oSheet.Range("A1:A1").EntireColumn.NumberFormat = "mm/dd/yyyy" Quote: > 3. Saves the results as a .csv. oExcel.ActiveWorkbook.SaveAs "d:\test.csv", 6 You'll have to put in a bit of your own time and effort to wrap it all up in a complete script.
My System Specs

Similar Threads
Thread	Forum
create Excel spreadsheet without loading Excel	VB Script
Excel Spreadsheet Problem	Microsoft Office
Excel Spreadsheet Help	Software
Hyperlink from web page to specific cell in specific Excel sheet	VB Script
EXCEL spreadsheet running slow	Vista performance & maintenance