• Is it possible to pop up an option box for user to select after checkbox is checked in Excel?

    I would like to create a checkbox that once checked, pop up an option box woth 3 or 4 options to choose from. Based on the option choose, write different values into a cell. This is all in excel. I'm trying to prepare a timesheet with checkboxes for, e.g. Worked, Vacation, Sick, etc. Once the...

    Funghui5 pointsBadges:
  • Printing the contents property of an EXCEL file

    I have an Excel spreadsheet that has 92 macros and many queries with a Data Connection to Access. I can view the contents of the Excel file in a narrow window. Does anyone know how to print the contents so I can read the full contents?

    SharieL10 pointsBadges:
  • Vista and Office 2007

    We have a customer upgrading their PCs with Vista and Office 2007. The host is an 820 at V5R3. iSeries access fix pack is SI28055. Does anyone have this mix and do you have issues to report? Thank you.

    maryann465 pointsBadges:
  • Error while running a form

    Hi when running a form i am getting an error and my output is not been created and when i debug i gives me a clause that excel is running in the back end but there was no excel running

    810 pointsBadges:
  • Query from Oracle forms to Excel sheet

    I had a matrix report made in oracle reports builder 11g. This report was called from a button in my form. now, I want to open an excel file when that button is pressed and show the data exactly in the format as it was shown previously in the report which was made using report builder. I am unable...

    Sarah1234520 pointsBadges:
  • Adding an editable Excel spreadsheet to a Lotus Notes form

    Hi, I'm totally new to Lotus Domino designer so please forgive me if this is an incredibly stupid question. I'm trying to add an editable spreadsheet to a form. It seems simple enough to add a spreadsheet attachment, however the attachment is not editable as the edit button is greyed out. I need to...

    TheBinman10 pointsBadges:
  • 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,355 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:
  • Save an Excel Add-in to a network drive

    I have a MSExcel 2010 workbook which uses a User Defined Function via an Add-in (.xlam file). Although the add-in is saved on a network drive, when I try to load it into my add-in list using the browse in the Add-in Manager, it prompts to copy the add-in to the default path on my harddrive:...

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

    shivasanjay2,510 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:

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following