advanced code snippet search

Posted By

qrist0ph on 05/24/08


Tagged

excel vbs officeAutomation


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

qrist0ph


Excel Automation mit VBS

 / Published in: Visual Basic
 
Expand | Embed | Plain Text 
  1. set app = createobject("Excel.Application")
  2. app.Visible = true
  3. set oClientBook=app.Workbooks.Open("Datei.xls")
  4. app.Run "PB_SmokeTest.testMengen","20" & "", optionenString & ""
  5. oClientBook.Worksheets("Deckblatt").range("D28").value = "Lief" & i & " " & teststring
  6. oClientBook.save()
  7. oClientBook.close(true

Report this snippet  

You need to login to post a comment.