EVMNU formula not working

[Former Member]

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

[Former Member · Accepted solution]

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

[krishna_priya1 · Accepted solution]

According to this [How-to|http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f085dd92-a40c-2c10-dcb1-a7c24476b23a?QuickLink=index&overridelayout=true] Evmnu opens only local files . Please check 3 rd page

"We will be using u201COPENFILEu201D option with EvMnu to open a dynamic template. The OPENFILE

option within the NW Version can only open workbooks from cached directories in local PC.

Therefore, it is a best practice to ensure that OPENFILE only refers to templates that are available

as dynamic templates that are cached (updated template version) on all client PCs that are using

the EvMnu based workbook."

[Former Member]

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

[krishna_priya1]

Hi Chandra ,

Please check this [weblog|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/19614] [original link is broken] [original link is broken]; , on EVMNU . Hope this helps.

Thanks,

Krishna

[Former Member]

Hi,

What would be interesting to note or check is whether the 'Open File' option would work from all the user PCs. As per the blog it picks up from the local folder.

What if a particular user never accessed the other input schdule that you want the users to open? Would it be there in his or her local folder?

What if some user clears out all his or her local application information. That would clear all the information from the local folder. Check this.

Thanks,

Sreeni

[krishna_priya1]

Hi Sreeni,

I created one test template and saved in wizard folder . Then cleared local application information . Logged in again and the reports in Company\ Reports \ WIZARD folder got copied to LOCAL \ Reports \ WIZARD . That way EVMNU formula works as there would be template in LOCAL folder .

When saving report in WIZARD folder , its prompting to increase the template version . That way when ever this template is modified , based on the template version , latest version gets updated to all clients. This is very interesting .Even i am surprised to notice this.

Regards,

Krishna

[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...

[Former Member]

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

[Former Member]

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??

[krishna_priya1]

I thought only one user wants to use EVmnu.

[Former Member]

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

Regards,

Chandra

[Former Member]

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

[krishna_priya1]

'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 .

[Former Member]

Hi Sanjeev,

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

Regards,

Chandra