Home
Open A Excel File using VBScript @ Windows Script Host
Tags:, , , , , , , , , , , , , ,

Open A Excel File using VBScript @ Windows Script Host

February 22, 2013 1 Comment I/O File, implementation, programming languages, vbscript, windows, windows scripting host

Windows Script Host (WSH) is powerful. Every windows since Win95 come with default installation of WSH and two languages are supported, JScript (Microsoft’s implementation of Javascript) and VBScript.

Creating Automation Objects is easy. In VBScript, the syntax would be to use CreateObject function and in JScript it corresponds to new ActiveXObject function.

The below is a sample script in VBScript to open an excel file and bring the Excel Application to front.

1
2
3
4
5
6
7
8
9
10
11
12
13

' codingforspeed.com
 
Dim fso: Set fso = CreateObject("Scripting.FileSystemObject")
' directory in which this script is currently running
CurrentDirectory = fso.GetAbsolutePathName(".")
 
Dim csv: csv = fso.BuildPath(CurrentDirectory, "sample.csv")
Dim Excel
Set Excel = CreateObject("Excel.Application")
Excel.Application.Visible = True
Excel.WorkBooks.Open csv
' App Activate, bring to front
CreateObject("WScript.Shell").AppActivate Excel.Name
' codingforspeed.com

Dim fso: Set fso = CreateObject("Scripting.FileSystemObject")
' directory in which this script is currently running
CurrentDirectory = fso.GetAbsolutePathName(".")

Dim csv: csv = fso.BuildPath(CurrentDirectory, "sample.csv")
Dim Excel
Set Excel = CreateObject("Excel.Application")
Excel.Application.Visible = True
Excel.WorkBooks.Open csv
' App Activate, bring to front
CreateObject("WScript.Shell").AppActivate Excel.Name

–EOF (The Ultimate Computing & Technology Blog) —

GD Star Rating
loading...
181 words
Last Post: Happy Valentine's Day, another heart equation
Next Post: Variable Scopes in VBScript at Windows Script Host

The Permanent URL is: Open A Excel File using VBScript @ Windows Script Host

Related posts:

  1. Parity Sorting the Array by Index Similar to Parity Sorting, the Index Parity Sorting can be applied to an array of...
  2. C/C++ Function to Compute the Combination Number We all know that the total number of solution to pick combination of n items...
  3. How to Use the Dynamic Link Library in C++ Linux (gcc compiler)? The Dynamic Link Library (DLL) is stored separately from the target application and shared among...
  4. How to Analyze Website by using the Wappalyzer (Chrome Extension)? . And here is a list of technology used in this blog. And basically it...
  5. Displaying a File with Line Number on Linux Shells There are many ways to show line numbers when displaying text files. For example, in...
  6. Coding Exercise – Simple [nl] Implementation on Windows Platform using C++ (GCC) On Linux BASH shell, the ‘nl’ utility is used to print out text file (or...
  7. How to Run HTA as Administrator (Elevation)? HTA (HTML Application) are designed to work on Windows only. The *.hta are interpreted by...
  8. Passing Variables through different pages in PHP You often need to pass/keep variables from pages to pages when you design the website....

One Response

  1. Lucas

    Thanks, i used this code and worked. But i want my directory be a variable created by time update. How could work?

    Reply

Leave a Reply