• Excel to AS/400 PF

    I know this topic is widely discussed. But even after going through some of those discussion, I am not able to proceed. I have an Excel sheet which has one row header and one row of data, which includes both numeric as well as alpha data. I have opened it in notepad and but ',' separators after...

    RamvishakRamesh2,505 pointsBadges:
  • Excel copy and paste

    Microsoft Excel Worksheet for Windows : Using copy & paste, if I transfer some information into one cell of an excel,during the course of routine work, if the number of words is around 200 or more, only part of the information is saved and not the entire information. Is there any solution for...

    NAGKUDLIG5 pointsBadges:
  • Excel Question

    Can you repeat the 'LESS' command by pressing CTRL + R?

    edjames10 pointsBadges:
  • Excel x-axis labels

    I have tried unsuccessfully to create labels such as Aug 11, Sept 11 under the x-axix. Would appreciate any help.

    lorilee5 pointsBadges:
  • SQL table connectivity via odc

    Can a user create a Microsoft .odc file from a SQL database (eg Visual Manufacturing, Dynamics, etc.) without a special tool? Looking to design refreshable Excel reports.

    tswanson3005 pointsBadges:
  • Outlook email

    Can I export my daily mailbox into an Excel spreadsheet or table?

    vonka5 pointsBadges:
  • Opening files

    How do I get excel and word to open files without giving me the "read only" screen and having to click "notify" and wait? In the 2007 version, they would just open and 2010 takes so much longer because of this "read only" issue. How do I take that off so they just open?

    cmeveland5 pointsBadges:
  • Excel Quickbooks Update Report

    I was wondering what the Quickbooks Update Report in Excel does? I was going to try it but I am on a work computer and was afraid to try it without knowing what it does first.

    Administrative5 pointsBadges:
  • how to recover an excel file

    i did format my disk, but unfortunately, i also deleted an important excel file. i used getDataBack to recover that file, but when i get it back, i totally cannot read it, the data inside appear all like this "ZUØƠ&¥¥<Ó·UßçœZZ.XMUßwđ¥¥.^µUø™Ũ{đ¥¥_®×,R¥|ni2#EZ™™�"...

    Devil5 pointsBadges:
  • I want to play one of two wav files

    I want to play one of two wav files when cell D11 value changed from Right to Wrong. What I have works perfectly for the value "Right". But I don't know how to change the code to play a wav for "Wrong". I tried adding a second modual but that did not work. Sheet 1 Private Sub Worksheet_Change(ByVal...

    Moses585 pointsBadges:
  • Numbers not registering in cell

    I am trying to enter data (money totals) in an existing spreadsheet but when I enter the numbers and go to the next cell, no numbers but ##### instead.

    Amgarner5 pointsBadges:
  • 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:

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