Skip to Content
author's profile photo Former Member
Former Member

EVMNU formula not working

Hi experts,

I have written a EVMNU formula(In one of the input schedule) whcih opens another Input Scheudle from the server.

The formula is as follows:

=EVMNU("OPENFILE","","INPUT SCHEDULES/Upload File Expenses.xlt")

*Where 'Upload File Expenses.xlt' is the file name.

The formula is working fine in my desktop, however it not opening the Input Schedule when tried with other desktop/Machines.

I Just wonder whether in anyway, this formula is desktop based/ opening the file from the local desktop??

I would be pleased if someone could explain me the possible reaseons for this and your suggestions to solve this.

Thanks in Advance.

Regards,

Chandra

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2011 at 10:03 AM

    Hi ,

    Please check the settings.

    Select Tools - Macro - Security

    Click the 'Trusted Sources' tab

    Select the checkbox next to 'Trust access to Visual Basic Project.'

    Please note this Excel options only applied to trusted files.

    Hope that will solve your problem.

    Regards,

    Sanjeev

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2011 at 12:58 PM

    Hi Sanjeev,

    Tried the setting as suggested by you. But still facing the same error.

    Regards,

    Chandra

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2011 at 01:16 PM

    Hi Pkrishnas,

    Thanks for the reply.

    Now I understand that "OPEN FILE" refers to the files in the Cached folder. Can you just elobrate what settings needs be done in the Desktop's of the users who are using this function.

    Regards,

    Chandra

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      'cached directories in local PC' refers to 'My Documents\PC_NW\Your domain\User ID\AppInfo\Appsetname\ApplicationName\eExcel\Reports\' folder.Reports needs to be placed in the specified folder in users desktop. And you can just specify EVMNU parameters as it is .

  • author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2011 at 01:20 PM

    And also please let me know, if by any other way we can open the input schedules/ Reports saved in the server.

    Regards,

    Chandra

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2011 at 01:31 PM

    Hi Pkrishnas,

    So, you mean to say, that , the report has to placed in the desktop of all the users who would be using that particular report??

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2011 at 03:00 PM

    Hi,

    How about updating the full path. Could you please give it a try as below

    =EVMNU("OPENFILE","","HTTP://{webserver ID:port}///eEXCEL/Input Schedules//Upload File Expenses.xlt")

    Thanks,

    Sreeni

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 07, 2011 at 04:23 AM

    Hi Sreeni,

    Tried even with giving the full path. It still doesnt work. Let me know, if in someother way we can open the file directly. It would be very useful for us.

    Regards,

    chandra

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello experts,

      I read your discussion on the topic, and it is very good.

      However, can we not using the EVHOT function to open a new report from the existing one? Wouldn't that be easier? Please provide your valuable advice.

      Thanks...

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.