Menu

How to delete the content of Excel cells from VBS script?

Search this Thread

Prev

Previous Post

Next Post

Next

#7

Report Post

Posted to microsoft.public.excel.programming

Reventlov

Reventlov is offline

external usenet poster

Posts: 2

Default

How to delete the content of Excel cells from VBS script?

Il giorno 21 Jun 2008 05:07:45 GMT, (Claudia d'Amato) ha scritto:

I would like to delete the current content/value of the cells

3,6 .... 3,18

How can I do this within a *.vbs script?

Not (totally) tested:

xl.Range(xl.Cells(3,6), xl.Cells(3,18)).ClearContents

And how to do something similar on the xls dropped on the vbs.

Set objArgs = WScript.Arguments 'Vedo se c'è almeno un argomento passato allo script
If objargs.count=0 Then 'altrimenti mostro come si usa il programma
msg= "Trascinare un file xls sull'icona del programma "
msgbox msg ,,Title
wscript.quit
End If
Filename= objArgs(0)
Set xl=CreateObject("excel.application")
xl.Visible=True
xl.Workbooks.Open Filename

FromRow=3
ToRow=3
FromColumn=6
ToColumn=18
For MyRow= fromRow to ToRow
For myColumn=fromColumn to ToColumn
cells(myRow,MyColumn)=""
next
Next

--
Giovanni Cenati (Bergamo, Italy)
Write to "Reventlov" at katamail com
http://digilander.libero.it/Cenati (Esempi e programmi in VbScript)
--

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
how to delete part of the content on multiple cells in excel?	Luis	Excel Discussion (Misc queries)	3	May 17th 23 07:42 PM
How to delete the content of Excel cells from VBS script?	Claudia d'Amato	Excel Discussion (Misc queries)	2	June 21st 08 12:55 PM
How do I delete only the content of cells that are NOT protected?	DrDisk7	Excel Discussion (Misc queries)	1	May 17th 08 04:38 PM
VBA script to delete content in merged cells.	Calle	Excel Programming	2	July 7th 06 03:02 AM
how to delete duplicated content from 2 cells	lucent88	Excel Worksheet Functions	2	October 12th 05 10:57 PM

All times are GMT +1. The time now is 08:12 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement