Functional Testing for Developers Discussions

Home

Verified Answers

If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it! Learn more.

State Not Answered
Replies replies
3
Subscribers subscribers
11
Views views
228
Users 0 members are here
Locked Locked

Related

Options

This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Getting error as "Expected Expression " in error time but no issue on runtime .How to remove the error?

snehasishdass over 2 years ago

Developed a script which has a function file .

In the function file , there is line of code like

Set oSheet=XLBook.Sheets.Add( , XLBook.Sheets(XLBook.Sheets.Count))

In the error tab , this line is giving error as "Expected expression".

But during execution , it runs without any issue .

Can someone please help me to remove the error message.

0 Ivan Petrov over 2 years ago

Hi,

you just need to remove the comma in the brackets, i.e.: Set oSheet=XLBook.Sheets.Add(XLBook.Sheets(XLBook.Sheets.Count))
Cancel
Vote Up 0 Vote Down

Cancel
0 snehasishdass over 2 years ago in reply to Ivan Petrov

Removing , resolves the error message but it doesn't perform the intended purpose of the code.

What this part of code does is it create tabs in Excel sheet after the current sheet instead of adding before the previous sheet.
Cancel
Vote Up 0 Vote Down

Cancel
0 Ivan Petrov over 2 years ago in reply to snehasishdass

Then use following:

Set oSheet=XLBook.Sheets.Add(Null, XLBook.Sheets(XLBook.Sheets.Count))
Cancel
Vote Up 0 Vote Down

Cancel

Resources

Learning Services

Partner Programs

Privacy

Compliance

Help

Company

Privacy Policy
Terms of Use
Cookies Preferences

Accessibility
Anti-Slavery Statement

Support
Contact Us

Careers
Code of Business Conduct and Ethics

The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.