• Any tools for comparing office docs /whole directories? But ignore dates, page nums, etc.

    I am a developer/tester and want to regression test some crystal reports that are generated as excel and rich text.  The reports have the date run in the header so I want to exclude that.  Any suggestions?

    Janeway25 pointsBadges:
  • Problem in Data Downlod from SAP to Msoffice 2007

    Problem in Data Downlod from SAP to Msoffice 2007. If i use data export option from SAP to Excel 2007 a blank xls sheet open but no SAP data apear in sheet.

    Mkamil5 pointsBadges:
  • AS/400 file to Excel with Headers and Footers

    I need to attach an Excel s/sheet to an email. I currently do that via the CPYTOIMPF as a CSV file but this doesnt give give me the true Excel Header row, which is a requirement. Is there any easy way to do this?

    NJFred35 pointsBadges:
  • I need vba code to update item cost from a word document w/o changing the previous wks item cost in Excel 2004

    I have a work book with week 1 - 5  ending inventory worksheets.  I need vba code to update item cost from a word document w/o changing the previous wks item cost.

    J1549120 pointsBadges:
  • Outlook 2007 excel attachments

    I was sending an email with an excel doc. right before i hit send, I opened the attachment, realized I needed to make some changes. Started on the changes, in the middle of that, I removed the attachment from my email message. I continued working on the still open spreadsheet and saved it multiple...

    BOBE5 pointsBadges:
  • Copying from Excel using clipboard in a gridview

    Hello, i am working with vs2008 (web application) and I want to copy some content from an excel sheet and and using the clipboard i want to copy the contents in a gridview I have tried using Clipboard.GetDataObject() but no matter what ever i do it is always returning null so can anyone suggest me...

    Vamsikrishna2015 pointsBadges:
  • Macro code for QC to Excel?

    I need a macro code to pull result table from Quality Center9.2 to excel sheet....Can someone help?

    Viv0rns5 pointsBadges:
  • Moving .XLS from a folder on an as400 to a shared folder on a network

    I have an excell spread sheet generated from Sequel, I can get it ot a folder on the 400 but would like it get it to a shared folder on my network. I have tried to copy it FTP it and nothing seems to work.

    Johnd0155 pointsBadges:
  • minor loss of fidelity but cant find data!

    I have a large database saved in xls. 2003; I changed one column heading and got a message that reads: Compatibility Report for Thurs Brkfst Data Base.xls Run on 11/20/2008 16:50 The following features in this workbook are not supported by earlier versions of Excel. These features may be lost or...

    mmpp295 pointsBadges:
  • Count Distribution

    From an input table consisting of YEAR and COUNT, e.g. YEAR COUNT 1999 3 2000 4 2000 7 2000 15 Can a Pivot Table or SQL Query be constructed to output a Yearly Count Distribution? e.g. YEAR 1->9 10->19 20->29 1999   1 2000   2        1 Thanks, JaG

    Jaggerdude60 pointsBadges:
  • MICROSOFT INTERCHANGABILITY

    Does Word, Excel and Acess work together interchangeably?

    Swanson5 pointsBadges:
  • error solving

    "Provider=Microsoft.Jet.Oledb.4.0;Data Source="+path+";Extended Properties="Excel 8.0" " i write this ^ in source of click event of  button  i want to convert  the data in gridview that were in excel file but i got some error so please help me and take me out of this problem

    Amystudent25 pointsBadges:
  • Download from iSeries directly to an Excel xls file – no CSV

    I need a little help! Is there anything out there that I can incorporate into a CL program that will download a database file to Excel with an xls extension so no further converting is necessary. I tried the CVTPFXLS but get Pointer not set for location referenced.

    Sillyhp35 pointsBadges:
  • Read/Write Excel spreadsheet in Forms6i but no excel

    Hi!  I'd like to know if I there's a way to read/write a spreadsheet without to install Excel. I'm working en Forms 6i and I'm performing a programmed task, so a file csv doesnt' work for me, the application must access and generate the Excel file automatically.  Please, help me. Regards, thanks...

    PaolaChile35 pointsBadges:
  • Exceeding Limit in Excel

    I am loading 20k records from our AS/400 using Excel icon(transfer from AS/400) but after 16k records loaded I am getting message indicating that limit is over need to start in another worksheet. I changed file type under RECV - Details icon in AS/400 to Excel 5 then also no use same error. Pls Let...

    Alicsc370 pointsBadges:
  • Role of Excel/Access in SQL Server 2008 R2

    What is the role of Excel / Access in SQL Server 2008 R2?

    ITKE353,260 pointsBadges:
  • Data entry and calculations in the same cell

    I have an excel template and would like to allow the user to input their date in one of two ranges and have the other range calculated automatically based on a formula to use in each cell This means that the formula needs to be outside the cells in the two ranges as they are both used for date...

    Askm5 pointsBadges:
  • Business Objects XI and Microsoft Office 2002

    Hi. On some different pc I have MS Office 2002 and BOE XI. After a couple of time (usually after a system update) something goes wrong. Example: I create a document on Excel, like a graph. I copy the graph on a Powerpoint sheet or a Word page, then when I try to modify the data with a double clik...

    AlessandroStillitano10 pointsBadges:
  • Subtraction using Excel VBA

    Hi, I'm creating a sheet for the employees in my retail store. The spreadsheet has a column for the different items that I'm selling, and another column for the number of these items that I have in stock. Next to each of the item, I'd like to create a button. So here is my question: How do I assign...

    Curioussam25 pointsBadges:
  • client access for Iseries export

    I have exported data via excel but I can't seem to get a certain column (data not numeric) across. I have displayed my database file and it is there but when I export it, that column is missing. What do I do?

    Informations30 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