Using createobject Excel application to create excel 2007 application

0 votes

I have 2 excel versions installed on my system. 2007 and 365.

when using

function open1()

set h = createobject("Excel.application")
h.visible = true
h.workbooks.add

end function

Excel 365 opened up when I wanted to open excel 2007.

I tried searching for a solution to this. but could not find any similar case.

Is there any specific way I can open excel 2007 application?

Jan 13 in Others by Kithuzzz
• 28,700 points
37 views

1 answer to this question.

0 votes

Try the next adapted way. No need to function, if it does not return anything:

Sub open1()
  dim h as Object

  set h = createObject("Excel.application.12")
  h.visible = true
  h.workbooks.add
end Sub

To use the alternate version, try createObject ("Excel.application.16"). If not, the default version is picked up automatically...

Since I have never needed two different versions, I am unable to test it. However, I used Corel versions, which operate in a similar manner. In the case of Corel, there are certain variations between the versions that affect how the same thing is done. I created some programs, and I had to update them all in the event that any changes were necessary.

answered Jan 13 by narikkadan
• 53,160 points

Related Questions In Others

0 votes
1 answer

Using Java to create PDF graphs based on Excel formulas

The Apache POI project, an API for ...READ MORE

answered Oct 22, 2022 in Others by narikkadan
• 53,160 points
206 views
0 votes
1 answer

Trying to create an enclosing bookmark after pasting a picture from Excel into Word using VBA

Try this: Sub IMPORT_TO_WORD() Dim ws1 As Worksheet, ws2 ...READ MORE

answered Oct 30, 2022 in Others by narikkadan
• 53,160 points
114 views
0 votes
1 answer

How to create page borders using Apache POI in excel files with Java?

Microsoft Excel cannot do this. Libreoffice Calc ...READ MORE

answered Dec 13, 2022 in Others by narikkadan
• 53,160 points
90 views
0 votes
1 answer

Using excel I need to open PPT and create ".gif" image of a ."pdf" and save it

It appears happier if you get a ...READ MORE

answered Dec 24, 2022 in Others by narikkadan
• 53,160 points
63 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
530 views
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,620 points
2,408 views
0 votes
1 answer

Using VBA Excel to create a gramatically correct list

The Excel AND function is a logical ...READ MORE

answered Feb 9, 2022 in Others by gaurav
• 22,940 points
117 views
0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
294 views
0 votes
1 answer

How to create and download excel document using asp.net

First, download the Open XML Format SDK 2.0. It comes ...READ MORE

answered Oct 3, 2022 in Others by narikkadan
• 53,160 points
533 views
0 votes
1 answer

How to create Dropdown list in excel using php

Try this: $objValidation = $objPHPExcel->getActiveSheet()->getCell('B'.$i)->getDataValidation(); $objValidation->setType( PHPExcel_Cell_DataValidation::TYPE_LIST ); $objValidation->setErrorStyle( PHPExcel_Cell_DataValidation::STYLE_INFORMATION ...READ MORE

answered Oct 3, 2022 in Others by narikkadan
• 53,160 points
305 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP