Getting error when opening excel file using a VB script

[Madri]

I am sure there is something wrong with the VB script code that I am using to open up the Excel file. Every time I tries to open the excel file I get an error messaged popped up saying “Excel has encountered an error”. Initially I thought there must be problem of compatibility with MS excel and my windows system but later on found that compatibility is not an issue.

Also tried the script on other systems too but the problem is still the same. anyways, below is the code that I am trying to modify and get corrected but it’s not working. Please guide me guys.

Set objectExcel = CreateObject("Excel.Application")
objectExcel.Workbk.Open "Qualified path\filenm.xlsx"
objectExcel.Visible = True

[Brunon]

As far as I can understand I do not see any mistake or error in your vb script code. For opening the excel file the code is proper and fine. It would be much better if you let me know how exactly you try to open the file.

There are possibilities that the problem might be with excel file itself. I would first suggest you to try to open the file without using the vb script code. I mean try to open the file normally by simply double clicking on it and see whether it opens up fine or gives the same error. By looking at the error I feel that excel has some problem and not the script. Try to verify things from MS excel’s side too.

[Haviva]

I too believe the same. The problem has to do something with Excel and not just with the VB script. The script looks fine (I have not yet tried it) and also the error message indicates the problem with Excel. I knew that you already checked out your system’s compatibility with Excel but it’s your betterment if you check the version of the Excel software present in your computer. The version of your present Excel software may play a huge role in this problem as you may not know that you are actually trying to open a kind of .xlsx file which is quite new for your Excel version you have. Older version of Excel used to only support .xls extensions extension files whereas the current versions supporst .xlsx extensions.

Verify the version and also the filetype which you are trying to open.

[Holbrook]

I have got the solution for your problem. First of all let me tell you that do not search of any error in your excel version of the excel file because the error persist in your script and not in the file or something else. The code is well written but unfortunately in your second line you committed a mistake which is disallowing you to target the file name and its path. Below is the code:

Set objectExcel = CreateObject("Excel.Application")
set wbX = objectExcel.Workbooks.Open("path name\Filename.xlsx")
objectExcel.Visible = True

[Fred Fruax]

If in case you aren’t able to still get the problem solved then I would suggest you to try out the following R&D and note down the difference:

• Firstly for a safer side update your antivirus
• Try an Excel Diagnostics (to check whether there is no problem with your Excel file and Excel program)
• Make sure there I no other Excel running instance
• Within your script, see to it that you have entered the file name and the path name properly, the file location and the file should be existing in your computer