• Excel report from RPG or SQL

    How do I produce an excel report via RPG or SQL inside an RPG program?

    Taborly0820 pointsBadges:
  • excel macro formated to highlight current date

    I have a calendar in an excel workbook that I would like to develop a macro that could be formated to highligt the current date. I have my dates formated as the serial date. When I write my macro it highlights the same "number" "=DAY(TODAY())" in every month.

    Jlcford15 pointsBadges:
  • Data Conversion

    How to convert PDF files to Excel Files

    Aumarve5 pointsBadges:
  • how to increase no of rows of validation list (drop down list)???

    Hello, Thanks for viewing this thread. I have one excel sheet. I have entered following data in 30 rows in one column and created the validation list for that data 10:00 AM 10:01 AM 10:02 AM '' '' ' '' 5:00 PM I want to show drop down list box with my own no of rows to be displayed not current...

    Abhikop5 pointsBadges:
  • Add to Excel spreadsheet from System i

    I want to add data from a DB2 file to an Excel template that has a header row and totals certain columns without overwriting the header row or the totals.

    ljjk1225 pointsBadges:
  • Combining data from two Excel sheets into a new sheet

    Hi, I Have few leave detail excels wherein the leave details of each resource are present.I need help to create a macro wherein all months leave details will be clubbed together into a new excel for each resource.Kindly help me with the code or give me some ideas to do this since am very new in...

    Vaibhav1235 pointsBadges:
  • How to repair and recover corrupt MS excel file?

    How to repair and recover corrupt MS excel file? I am unable to open corrupt MS Excel file due to virus infected, I have crucial Workbook sheet got lost, so how to get back corrupted MS Excel file. Please help me.

    DredSelpy5 pointsBadges:
  • Problems oprning Excel File

    I have been working with an Excel 2003 workbook since January 2008 and from last week began having difficulty opening the file. Whenever I attempt to open it, I get an error window with the following messages shown in bold below: [Excel found unreadable content in 'filename.xls'. Do you want to...

    EB35 pointsBadges:
  • Number formatting in Microsoft Excel

    I have a series of 8 digit numbers that I want to add 2 zero's to the middle of the numbers. For instance, I want 30251111 to be 3025001111. Without manually retyping every number (I have over 1,500 to modify), is it possible to do this with a formula? Any help would be appreciated!

    jlotts5 pointsBadges:
  • SSIS only 255 rows uploaded?

    Hi, I have a simple Data Flow with an Excel Source and an OLE DB Destination to upload data from an Excel file to an SQL table. The Excel file has 8155 rows. Once the package is finished running, the SQL table only shows 255 rows. The data access mode is Table or view - fast load. Any suggestions?...

    SbcOrc35 pointsBadges:
  • Comparing 2 Large Excel Files

    I have 2 large Excel files, one containing yesterday's data, and another containing yesterday's data + today's updates/changes. For registration purposes, I need to find all the differences (ie new rows/entries, a value changed within the row in the new file vs the old file, etc). These excel files...

    Drawde5 pointsBadges:
  • I have a case that the client work on an exists Excel file

    I have a case that the client work on an exists excel file, she try to save the file on a different name, sines than the file was corrupted an could not be open at all. I try the auto save of Excel, but nothing there. I try several fix software but the most of them get me a blink results. Some of...

    olenprazd5 pointsBadges:
  • How to repair corrupt MS Excel (XLS and XLSX) Files

    I have an important MS Excel file data and unfortunately it got corrupted due to virus attacks, so my crucial Excel sheet got lost. How do I repair corrupt MS Excel (XLS and XLSX) Files. If have any solution please assist me.

    kritchernos5 pointsBadges:
  • My Excel 2007 Files seriously corrupted

    Dear Experts, All my excel files have been corrupted and I'm unable to open any of them. I tried couple of free download for excel file recovery but non of them helped me. I see message from Microsoft Excel: Your file is severely damaged unable to recover is the message I am getting. Please help...

    NealReyd5 pointsBadges:
  • Lotus Notes: Stuck with unprocessed document

    I've been running an unprocessed document so it only runs as a selected document in Lotus Notes and now I'm at column values so I can export the document to Microsoft Excel. My code has been working fine but the first document is always displaying last after all of the other documents in the Excel...

    ITKE351,965 pointsBadges:
  • Export Lotus Notes view to Microsoft Excel

    I'm trying to export a Lotus Notes view to Microsoft Excel. Here's where my problem lies: I have two different columns in the view that's displaying multiple values with "New line" as the seperator. I've already tried the export function and the Lotus Notes script export function but in both cases,...

    ITKE351,965 pointsBadges:
  • can we export General Ledger to Excel file?

    I want general ledger listing for a given period and I want to edit the file so if such file is in Microsoft excel, that can be easily done.

    Csareska5 pointsBadges:
  • How to make restoration of corrupted Excel 2007 file?

    Hi there, When I open an excel file the following error message is displayed: “The file may be corrupted, located on a server that is not responding, or read only”. Since this happened whenever I open any excel file, the above error message is again displayed, I must also mention that I am sure...

    manuelhanke5 pointsBadges:
  • I have a user that is unable to open Excel xlsx file.

    I have a user that is unable to open xlsx file. Our environment is Office 2007, Win 7. Everyone else can access the file except for her. And it doesn't matter what PC she tries to access the file from - it seems to be linked to her profile/login. We have tried to delete the shortcut, recreate it,...

    garymoore5515 pointsBadges:
  • I am running Excel 2007 and have been working on files and ONLY saving them to my USB memory stick.

    I am running Excel 2007 and have been working on files and ONLY saving them to my USB memory stick. On connecting the device to my PC (using an extension USB cord) I noticed a very brief minute blue like spark, and didn't release until I tried to access my files that the entire content was wiped....

    groonbori5 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