• R6V1 iseries Excel Addin to download data from AS400

    On V6R1, how do I install the Excel Addin? The file that is in the shared folder for IBM does not have the cwbtfxla.xll like it did in R5.4

    Lorettarepman10 pointsBadges:
  • error in grid xml: each dimension must be used once and only once

    Hello, I've got problem on one workstation with installed Hyperion version 9.2.1.0.0.002 Add-in for Excel. When we run Refresh of sheet full of HsGetValue formulas we can't get data. It shows #NAZEV? instead numbers and popups Error window 'Hyperion Smartview for Office' with message "Error in grid...

    KAZAN5 pointsBadges:
  • Mail Merge

    I have an excel document from my accounting software that lists donors by each donation they have given. When I mail merge them I want to print one document for each name- putting more than one donation on each page. Meaning, I need to get more than one row on each page when the name is the same....

    Malachinetwork5 pointsBadges:
  • Data transfer from excel to PF

    How to transfer data from excel to PF if PF file has more the 300 Fields

    97834441841,465 pointsBadges:
  • How to Update Manager Field in Person Document

    HI,   It will be great, if anyone answer my query. I am searching for agent/script which can be used to update/modify Manager Field in Person document using Excel sheet.

    DominoDirectory5 pointsBadges:
  • Programming quiz – Excel, VB etc.

    Recently heard an interesting quiz and thought it will be fun to see the solution done programmatically. The quiz is as follows: A person bought an old car with over 170,000 miles on it. The odometer is a digital device with 6 digits. The odometer shows only full digits – no decimals. One day as...

    SbElectric2,540 pointsBadges:
  • Detecting MS excel is open in Citrix via Lotus Script

    I have an application that generates graphs using excel from data stored in a Lotus Notes Database. Once the graphs are created in excel,they are copied and pasted into a Rich Text Field in Lotus notes which is then displayed to the user so that the user never sees excel at all. However. If excel...

    WeDontByte30 pointsBadges:
  • Excel File from PL/SQL Procedure

    Hi, I have an Oracle PL/SQL procedure that creates a csv file with output. I would like to create an Excel spreadsheet with multiple tabs, seperate information in each tab. Can you advise how I achive this in PL/SQL. Thanks Heather

    HeatherM5 pointsBadges:
  • Append extra zero on the numeric field using Data Transfer Excel Add-in

    My PC configration is MS Window 7 Professional (64-bit Traditional Chinese version), MS Office 2010 (32-bit Traditional Chinese version) and IBM Client Access V6R1M0 (64-bit English version). The problem is that the actual numeric value is 1,2 or 3 only in the physical file. After using the Data...

    Mingwong30 pointsBadges:
  • Download AS400 Physical File to Excel Using VBA

    I am in the process of developing an Access database with the intention of using it to control the download of AS/400 physical files into Excel. I am fine developing the Access / Excel side of the data, however I ahve no experience with the AS/400 side of things. The access database will contain...

    Martyjw5 pointsBadges:
  • extract data from as400 to excel

    I have CL and DB files and i need to extract the data from the files to excel sheet by writing an program.How can i do that?

    Copinky45 pointsBadges:
  • Upload data from excel to lotus notes in web

    How to incorporate the facility to upload data from excel sheet to lotus notes web?

    shivasanjay3,205 pointsBadges:
  • find and replace in excel

    I want to use the find and replace feature under Edit. i want to find a word and replace that word in a difference format. For example, replace charcoal with [strong]charcoal [/strong](in red, bold format), but instead it replaces [strong]ALL the contents in the cell[/strong] with 'red, bold'. I am...

    Lrhehn5 pointsBadges:
  • how to export to excel in web with heading row frozen

    I want to export to excel report in lotus notes web, when report is available it should be showing Ist column as frozen, , ie. 1st row should not move when scroll bar moved to up and down.

    shivasanjay3,205 pointsBadges:
  • Can you show lotus notes table rows as rows in a view?

    I have a table with 5 columns. Each row as 5 fields. first row, Field A, Field B, Field C, etc second row, Field X, Field Y, Field Z, etc I need to be able to show the table rows as as rows in a view to export to excel. I have tried using a lot of formula language in column formulas and it is not...

    Penguins10 pointsBadges:
  • Data and Variables in SPSS from Excel spreadsheet

    have an Excel spreadsheet with responses to questions from a 49 question survey. At the top of the spreadsheet I listed each variable that the questions address. When I transfer this to the data page in SPSS, it lists the variables on the variable page with sequential letters after each variable -...

    Terrymb310 pointsBadges:
  • extenda x550 series

    I am using Extenda X550 (1+5) and having a typical problem while working in excel like - some area gets selected automatically - copy paste does not work - cursor starts moving weirdly

    Jaideep Khanduja12,670 pointsBadges:
  • Excel data and variables in SPSS

    I have an Excel spreadsheet with responses to questions from a 49 question survey. At the top of the spreadsheet I listed each variable that the questions address. When I transfer this to the data page in SPSS, it lists the variables on the variable page with sequential letters after each variable...

    Terrymb310 pointsBadges:
  • Displaying amount field in query 400.

    In query400, i created a report which will be downloaded to excel. If i download report, it is showing amount fields without decimal values. How to display amount fields with decimal fields using query400?  

    VJayashree185 pointsBadges:
  • Calculating Columns

    how do you create a formula using data tables calculate each divide each (3) quiz by 100 times .01 times 10%, each (2)test by 100 times .01 times 35% to get the final %

    Wandaj535 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following