LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Removing rows from a excel spreadsheet using a vb script

Hallo,

Can anyone help?

I have a folder containing multiple csv files. What I want to do is
write a vb script that will make a copy of the csv files (for backup
purposes), then open the csv files one by one and remove the first 4
rows.

The first 4 rows contains the following,

Daily Backup Status Report
02/22/2006 03:15:53
Summary of backup jobs done in the last 24 hours. This may exclude some
backup clients which could not be connected.
Job.Description,Job
No,JobType,JobID,JobStatus,JobStart,SourceHost,Pat h,Status,Name

Does anyone have a script that will do something like this? I'm very
new to vb scripting and have no clue were to begin.

Any help will be appreciated.

Cheers

Ruaan

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing Blank Rows in an excel spreadsheet Phyllis Excel Discussion (Misc queries) 5 December 18th 08 12:51 AM
Removing a listbox from excel spreadsheet TrishB98 Excel Worksheet Functions 3 July 16th 08 07:57 PM
removing gridlines in Excel spreadsheet JUNE BUG New Users to Excel 1 May 5th 06 03:36 PM
Removing rows via macro/VBS script ssciarrino Excel Programming 4 August 8th 05 07:45 PM
Removing Hard Borders from Excel Spreadsheet Battery Dude Excel Worksheet Functions 1 January 11th 05 04:28 AM


All times are GMT +1. The time now is 07:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"