Posts

Showing posts from January, 2011

How to hide Menu while transferring from one page to another page (with in Peoplesoft)

There are various ways to achieve this. When I google for this I am able to see one javascript to be placed in target page. But most of the Technical Guru's won’t accept this solution since we need to add HTMLAREA in your delivered page. But below solution will work. Instead of Transfer please use below approach… &MyURL = GenerateComponentContentURL(%Portal, %Node, MenuName.menu, "GBL", Component.Component, Page.Page, "U",keys); ViewContentURL(&MyURL, True);

Cannot find project or library - Spreadsheet Journal Import not working on Excel 2007 with Windows 7 or Vista

After we open the Journal Import Spreadsheet in Windows 7 or Windows Vista, it does not let us click on any buttons to create journals, etc... We get, "Compile error, Cannot find project or library". The spreadsheet journal import, JRNL1.XLS, can be used so long as the Microsoft delivered XML library file msxml.dll exists on the environment. It does not exist with Windows 7 nor Windows Vista. Please copy the msxml.dll file from the Windows XP computer to the workstation with Windows 7 or Windows Vista. Place the file under the windows directory where it is referenced, as follows. --Open JRNL1.xls and then go to the VB Editor (Tools > Macro > VB Editor) or ((Developer > Visual Basic for Office 7) --With JRNLMCRO highlighted, click Tools > Reference There should be a reference to the Microsoft XML DLL library file (msxml.dll). Microsoft has several versions of this library (msxml2.dll / msxml3.dll / etc.) and they coexist on some computers. NOTE: • For Windows 7, t