Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Invalid procedure call or argument

Posted on 2016-10-11
9
37 Views
Last Modified: 2016-10-17
Hello,

I have downloaded an 'EXCEL' worksheet from a government tax website. I have to fill out some details in this sheet ( .Xlsm )
This sheet has a 'BUTTON' called " Generate XML " 
When i choose this option, it asks me to choose the file name and location. When i choose OK, it comes up with an error.
" Invalid procedure call or argument ".
How do i fix this error and generate an XML file?
This is a protected worksheet and does not allow me to edit the "macros" or choose " file - save as - XML "
I use Excel 2007
Please help
Thanks,
Michael
1.jpg
0
Comment
Question by:Michael Sachin
  • 4
  • 3
9 Comments
 
LVL 26

Expert Comment

by:ProfessorJimJam
ID: 41838133
different to find the issue, without seeing to code or the file.
0
 
LVL 1

Author Comment

by:Michael Sachin
ID: 41838229
Hi,
I have attached the actual Excel file for your reference. The previous post also has an image file with the error.
I hope you can work on this

Thanks for your help,
Michael
Annx-08-Goods_Purchased_in_the_Cour.xlsm
0
 
LVL 26

Assisted Solution

by:ProfessorJimJam
ProfessorJimJam earned 500 total points
ID: 41838619
@Michael Sachin

i have examined the file, i have repeated what you did, added some data and then click Generate XML and then it asked for folder selection and it successfully created XML file.

the reason you face that error is that you use Excel 2007 and the VBA code that generate XML is using a method called "Early Binding" which requires the object reference in VBA reference library.
the current XML library selected in the file is XML 6 while the one in Excel 2007 is the lower version.
2016-10-11-17_32_05-Microsoft-Visual.png
unfortunately, you cannot change that because the VBA is password protected; and breaking the password is easy, however, it is not ok to do so, becuase the author of workbook must have locked it for a reason.

this is one of the mistakes that VBA developers do all the time, using early binding that creates problem with next versions of software and that is why it is preferred to use Late binding method when VBA developers write the code that uses object libraries.

this issue is fixable, but since we do not have the VBA project password, i think it is best to approach the author of the workbook and ask to fix this.

or if author is willing to share with you the unlocked version, then simply Open VBE by pressing ALT + F11 then go to Tools > References then untick the MISSING item and scroll down and select the XML version which is available in your library list. could be version 5 . click save and then it will work.
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
LVL 1

Author Comment

by:Michael Sachin
ID: 41839501
Hello,
Thank you for your effort. I tried the above mentioned options but no go.
I have attached the unprotected worksheet for your reference. Please look into this and
see if you are able to get it to work. I hope you can. I have been trying to work around this for the past
5 days and unable to.

Thanks
Michael
Annx-08-Goods_Purchased_in_the_Cour.xlsm
0
 
LVL 1

Accepted Solution

by:
Michael Sachin earned 0 total points
ID: 41839794
Hi,

I downloaded the previous version of the excel file (V1.0) and it worked fine. I think the issue was that I had used the file that was meant for the mac OS. Attached a screenshot that suggests that.

Issue resolved.

Thanks for your help

Cheers!
Michael
issue.jpg
0
 
LVL 26

Expert Comment

by:ProfessorJimJam
ID: 41841674
you are welcome.

i am glad i was able to help.
0
 
LVL 1

Author Closing Comment

by:Michael Sachin
ID: 41846343
Downloaded file was for the mac OS. Had to download a different file for Windows. Thanks.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question