• Macro for copying data from Excel to AS/400

    Hi,I'd like to create a macro (in AS/400 or Excel VBA, doesn't matter) that copies cell data from an XLS spreadsheet to AS/400. How would I do that?E.g. copying cell A1 in Sheet1 from c:\spreadsheet.xls to 10/035...Thanks in advance.

    Hanisadeq963525 pointsBadges:
  • Microsoft Office: Missing Localized Strings Here

    I downloaded microsoft office from my college's website, and when I tried to open it the message "missing localized strings here!" what does that mean and how can I fix it?

    dsawyer5 pointsBadges:
  • Excel 2007: Digits turned into decimals automatically

    In Microsoft Excel, last 2 digits are turned to decimal automatically. What should I do?

    Harshendu5 pointsBadges:
  • How to update ODBC database in Microsoft Excel

    For our ODBC database, can I directly update it through Microsoft Excel? I'm able to view the tables on it but I need to modify some data. How can I do that?

    ITKE970,405 pointsBadges:
  • Excel cannot open the file ‘file.xlsx’ because the file format

    Every now and then, when I try opening an Excel file, I get a message saying that "Excel cannot open the file 'file.xlsx' because the file format or the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

    weinmagaul5 pointsBadges:
  • Convert Excel file to SIF file

    Hello, does anyone know how to or what program I need to convert an excel file to a SIF file?

    ResseJackson5 pointsBadges:
  • How to repair corrupted files

    My MS Word, Excel and PDF files have been corrupted and these files are showing there file extension as "qbnzgel". How to open this type of files?

    tanveerhamza5 pointsBadges:
  • Retrieving missing Excel data

    I had an excel file with 10 worksheets on it. I opened the file yesterday and found the whole 10 worksheets missing from the file. What could have caused it and is there a way to retrieve this data back to the file?

    Tess695 pointsBadges:
  • Automation object error when merging Microsoft Excel cells in LotusScript

    Whenever I try to merge cells in Microsoft Excel through LotusScript, an automation error appears. r=11 c=12 t=15 mysheet.cells(r, C).value="ABC " mysheet.cells(r, C).Font.Size=12 mysheet.cells(r, C).Font.ColorIndex=1 mysheet.cells(r, C).Font.Bold = True ' -4108 is for center mysheet.cells(r,...

    AnshuKumari5 pointsBadges:
  • Microsoft Excel: Create diagrams of risk types

    How can I create diagrams by overlap for risk types in Microsoft Excel?

    khaleghian5 pointsBadges:
  • Convert Microsoft Excel file to PDF

    I have a recently created / updated Microsoft Excel file. This needs to be converted to a PDF file ASAP. What's the best approach to do this? Possibly a Java API? Thank you so much.

    ITKE970,405 pointsBadges:
  • Change English numbers to Arabic numbers

    How I can change English numbers to Arabic numbers?

    Mark475 pointsBadges:
  • Arabic Text In AS/400 to Excel

    Arabic Text when transferred from Excel to AS/400 displays garbage. Is there an add-in I need to install? Kindly help me in this how to transfer the data file from Excel (.xls) to AS/400 DB2.

    AnwarHabib25 pointsBadges:
  • Zero keeps disappearing in my Excel spreadsheet column

    So I'm adding some of my personal information into an Excel 2007 workbook and I've noticed that when I put in a number count that starts with zero, it automatically disappears. Here's an example: 012345678 changes to 12345678 What do I have to do keep the zero as entered and not disappear.

    ITKE970,405 pointsBadges:
  • Edit Client Access TFR

    I'm trying to upload a multiple Excel sheets to iSeries, Getting warning message: Multiple sheets exist in PC file. Do you want to send data from sheets other then first. I don't want to use other sheets. Is there a way I can edit the TFR and change it so it does not ask? Where can I find...

    polsh5 pointsBadges:
  • Exporting controls studio modules into Excel

    How do I export control studio modules from DeltaV into Excel?

    cstjohn5 pointsBadges:
  • Create Microsoft Excel file from CSV file

    Within Java, I have to create a Microsoft Excel file from a CSV file. What would be the best API to do this? Would Apache POI framework be good? Thank you for all the help.

    ITKE970,405 pointsBadges:
  • How to open CSV files in Microsoft Excel for a Mac

    I'm currently using Microsoft Excel on a Mac. My issue is that I can't open my CSV files correctly. The files open up but all I'm seeing are commas in the columns. Do I have to set the comma delimiter for this to work?

    ITKE970,405 pointsBadges:
  • Microsoft Excel: Next Status Change

    I have a two tables. On table has a unique order number and the associated time it entered a production stage (status). I have another table which has the unique order number and time stamp for each time a production stage changed (status). On the first table how can I systematically determine the...

    mtrial5 pointsBadges:
  • Microsoft Excel: Interpret CSV URLs as hyperlinks

    I have a CSV file and I'm wondering if it is possible to have Microsoft Excel interpret my URLs as hyperlinks. Can anyone help me? Thank you.

    ITKE970,405 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