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

    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?

    ITKE440,500 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:
  • Exporting Crystal Reports into Excel

    When I export a report to excel all columns export correctly except the sub report it makes it a new row. Any tips on how to fix this PLEASE!!!

    Kostical5 pointsBadges:
  • Excel Pivot Table

    Sir I Using Excel Pivot Table I Create Calculated Filed Formula is If(((total Debit-total Credit)>0),(Total Debit-Total Credit),0) This Formula very perfect use But Pivot Table Grand Total show the zero (0) How Grand total sum run please tell me

    Sankar12345 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.