Questions tagged [excel.application]

Use to focus your question on the use of an Excel.Application object outside of Excel's own VBA. Constructing an independent instance of Excel can present unique problems and this tag can be used to identify them. Examples: PowerShell or VB Script referencing and manipulating an Excel workbook; MS Access building a workbook without leaving its own VBA environment, etc. Should be considered a sub-category and used for focusing a question.

Excel is arguably the most popular of the applications within the MS Office suite; even more so when introductory programming is considered a factor. Excel workbooks and worksheets can be easiy manipulated outside of the native Excel environment by introducing an instance of an Excel.Application object and using that object to programmatically handle data retrieval, creation or modification.

This presents unique problems, particularly in addressing parent/child relationships that are taken for granted in a native Excel environment. Use this tag to focus attention on these issues when you are using an independent instance of the Excel.Application from an outside calling process.

Typical examples of outside calling processes would include , or even each of which can construct an instance of an object and use it to wrangle the data stored in a workbook/worksheet.

References:

36 questions
0
votes
1 answer

Set xlObj = CreateObject("excel.application") Requires Elevation (vbscript)

Every time I try to run a script that includes the line Set xlObj = CreateObject("excel.application") in vbscript, I get an error saying "Line Requires Elevation". I assume this is a permissions issue, but I'm an admin on the machine where I'm…
Sudo_Nym
  • 1
  • 2
0
votes
2 answers

Transpose range in excel with VBS

Hey guys need some help here . how can I transpose a range in excel with VBS? basically copy a range from one sheet then pastespecial transpose on the other sheet. thanks in advance
TriniCurry
  • 57
  • 1
  • 9
0
votes
1 answer

Unable to get open property of workbook class VBS

I'm trying to make a script that will remove the password protection for a excel (.xls) file but i keep getting the following error when I try to open my workbook: "Unable to get the Open property of the Workbook class" My code to open the file…
user3712526
  • 11
  • 1
  • 4
0
votes
1 answer

Application object in microsoft excel object model

Today while practicing vb script i came up with a little doubt please help to clear my doubt. I have written this code and created a excel sheet in my D: drive dim excel SET…
pushkar7767
  • 21
  • 1
  • 2
0
votes
1 answer

Error in vb script for .xls location finding

I'm facing a problem while writing the vb script for opening a .xls file that is given below.. Dim XLAPP Set XLAPP = createobject("excel.application") XLAPP.Visible =true XLAPP.Workbook.open"d:\book1.xls" When I run this script the pop…
Jeetu
  • 1
  • 1
0
votes
2 answers

Excel sheet doubts in vbscripting

I am creating an excel file as shown below strFileName = "c:\test.xls" Set objExcel = CreateObject("Excel.Application") objExcel.Visible = True Set objWorkbook = objExcel.Workbooks.Add() …
maddy
1 2
3