advanced code snippet search

We Recommend

Visual Basic 2008 Programmer's Reference Visual Basic 2008 Programmer's Reference
Visual Basic Orcas Programmer's Reference is a language tutorial and a reference guide to the upcoming Orcas release of Visual Basic. The tutorial provides basic material suitable for beginners but also includes in-depth content for more advanced developers.

Posted By

qrist0ph on 05/24/08


Tagged

excel vbs officeAutomation


Versions (?)


Who likes this?

1 person has marked this snippet as a favorite

qrist0ph


Excel Automation mit VBS

Published in: Visual Basic 

Plain TextExpand 
  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.