Enabling both the Developer tab and VB macros when using Excel 2007

By -
Below are instructions on enabling both the Developer tab and VB macros when using Excel 2007.

 Additionally, attached is a Word document with screenshots showing the same basic steps, providing the reader with a better visual representation of what the steps look like.

A. Enabling the Developer Menu in Microsoft Excel 2007 - The Developer menu in Microsoft Excel contains options to work with Microsoft Visual Basic, macros, sheet properties, and so on. In Microsoft Excel 2007 the Developer menu is not automatically enabled and does not appear on the menu ribbon in the default view of the Excel workspace. In prior versions of Microsoft Excel supported for use with the ExcelToCI utility, and the Developer menu appears by default.

To use the Excel to Component Interface utility you need access to some of the features accessed through the Developer menu, and therefore you must enable the menu. Once enabled, the Developer menu appears on the far right on the menu ribbon.

To enable the Developer menu and Enable Macros in Microsoft Excel 2007 (2010 should be similar):

 1.       Click on the Home button (upper left hand corner) and press the “Excel Options” button as shown in the second screenshot below

2. In the Excel Options window select Trust Center as shown below, and press the “Trust Center Settings” button.


3. In the Trust Center Settings window select the “Macro Settings” selection as shown below, and ensure that the last radio button is selected (Enable all macros), and the “Trust access to the VBA project object model checkbox is selected


4. Next select Trusted Locations, and add the locations where you store and execute the ExcelToCI spreadsheet (and macro). The click Ok to close out of the Trust Center window.


5. Back on the Excel Options window select the “Popular” selection to add the “Developer tab” to the ribbon. Select the 3rd checkbox from the top as shown below.


6. Press Ok to close out of Excel Options.

7. Save the ExcelToCI spreadsheet

B. Macros - The Excel to Component Interface utility relies on macros; therefore, you must enable macros in Microsoft Excel for the utility to work. When a Microsoft Excel spreadsheet is opened, the system displays a dialog box asking you to select whether to enable macros on the spreadsheet. Always select Enable Macros so that the macros delivered with the Excel to Component Interface utility can function.  To ensure that the macros are available to run, you must set the security level in Microsoft Excel to allow macros to open.


Comments

  1. UnknownJanuary 15, 2016 at 11:04 AM

    Excel is a software program from Microsoft basic excel for beginners that is a part of Microsoft Office. Excel calculations is compiled for making and altering spreadsheets that are spared with a .xls expansion. It's general uses in corporate cell-based figuring, turn tables, and different diagramming devices. With an Excel spreadsheet, you could make a month to month spending plan, track costs of doing business, or sort and compose a lot of information calculations in spreadsheets of Excels.

    ReplyDelete

Post a Comment

Popular posts from this blog

Peoplesoft SFTP

By -
Image
Transferring a file using SFTP to specified target location: (Thanks to Jawahar who helped me in this article) A lot has been mentioned about sFTP support in PT 8.51. Below gives clear idea on SFTP. Are there any specific pre-requirements for using file transfer protocols? Yes. Though FTP can be used directly by giving the URL as a string to the peoplecode method, other protocols (ftps, sftp, http and https) require the URL to be passed as a URL identifier only. When an URL identifier is created, URL properties link on the page gets enabled. Users need to provide the URL properties specific to the protocol they are using on this "URL properties" page. The URL properties differ based on the protocol choosen. Once URL Identifier is ready, it can be used in any of the file attachment peoplecode methods just like the existing way.   What are the authentication methods supported for sftp? Password and Public Key authentication are supported.
Read more

How to find the Java Version being used by WebLogic

By -
1. Open the setEnv.sh/cmd (On PT8.51 and lower, located in <PS_HOME>/webserv/<DOMAIN_NAME>/bin On PT8.52 and higher, located in <PS_CFG_HOME>/webserv/<DOMAIN_NAME>/bin) 2. Check JAVA_HOME variable if JAVA_HOME variable is commented out, Go to 3. set PS_HOME=C:/psft/ora/pt849 set BEA_HOME=C:/Bea set WL_HOME=c:/bea/weblogic92 set DOMAIN_NAME=peoplesoft1  @REM Set Javahome via commEnv.cmd call %WL_HOME%\common\bin\commEnv.cmd >nul 2>nul  @REM JAVA_HOME is set via commEnv.sh, to override set it here. SET JAVA_HOME=%BEA_HOME%\jdk150_1 3. If JAVA_HOME variable is commented out, JAVA_HOME is set via commEnv.sh/cmd. Open the commEnv.sh/cmd (located in <WL_HOME>/common/bin) and check JAVA_HOME @rem Reset JAVA Home set  JAVA_HOME=c:\bea\jrockit_150_12 FOR %%i IN ("%JAVA_HOME%") DO SET JAVA_HOME=%%~fsi 4. Go to directory path specified by JAVA_HOME. Run "java -version" command. -bash-3.2$ ./bin/java -ve
Read more

Peoplesoft Error: All Processing Suspended: Restart OPRID=PS, RUNID=RUN01, PI=5000(108,503)

By mymithraa -
All Processing Suspended: Restart OPRID=PS, RUNID=RUN01, PI=5000(108,503) What is this about and what should be done? This error can occur when Application Engine programs are restartable and run via the Process Scheduler, and the last run was No Success - And an attempt re-run, rather than re-start will produce error as well The cause of this message is that previously this same AE program was run using the same OPRID=PS & RUNID=RUN01. It was not Successful on initial run, and now an attempt to RUN the same program has occurred, instead of an attempt to RESTART the original that failed. Whether this error Happened in Development??? This message happened while the Customer was in Development phase of this AE program. It could have happened when this AE was in Production as well. However, what to do would have completely different emphasis depending on if this happens in Development or Productions. During the development cycle, we would expect that this AE would have to run many tim
Read more