• Microsoft Excel Graphing

    I need a line that is able to move. I want to grab it with my cursor and move it up and down on my bar graph. The bar graph is showing the zero to the max percentage of the percentage of income brackets for each year from 1913 to 2013. So there are 100 vertical columns (bars). The series of the...

    ITKE352,565 pointsBadges:
  • Loading image into MySQL database from Excel file

    I have an excel file that contains an image in the first col. When I save it to an csv format, the excel program creates two images ( 1 small, 1 large) for each line in the excel file. How do I load both the file data and the large image into my mysql database?

    Wlm49hv5 pointsBadges:
  • How to create an Excel spreadsheet from an Oracle database

    I currently have a table in a Oracle database and I need to create a complex Microsoft Excel spreadsheet structure from that specific table. Should I use SSIS to do this? Is there another way to create it? Appreciate the help.

    ITKE352,565 pointsBadges:
  • How to save the exported Excel files from Oracle Forms 6

    Hi, I am using oracle forms 6.0. I generate multiple excel files from oracle forms and am using ole2 to export the data into excel. But i dont know how to save those files into the local machine. please someone help me. Thanks in advance

    Rajanoracle10 pointsBadges:
  • How to export an AS/400 physical file to Microsoft Excel?

    how to export as400 physical file to excel

    Reskind5 pointsBadges:
  • Data Transfer from AS400 to excel

    i need to download data from As400 to Excel using TTO option. How to download the description of the fields instead of field names. I have tried with the COLHDG & TEXT keywords in the DDS of the PF. But, the records are getting downloaded with the filed names only. Please revert to me ASAP if...

    Saranyahere5 pointsBadges:
  • Excel 2003 ranking with VLOOKUP

    I know there is a way to rank a list without using the "sort" feature in excel but rather formulas. I need to sort the list of 25 items below by the first column with the highest value first. What formulas do I use? Thanks for the help. Weight Management 65% 74% 67% 84% 75% Healthy Heart 46% 24%...

    Jha9005 pointsBadges:
  • Excel and Access integration and auto-population

    Overall, I want to create a database that tracks defects for several sites and ouputs the information in a pivot table.  Each site (7 in total) documents their internal defect data and sends it to me weekly.  I then merge all of this data (have been doing so manually) into one spreadsheet to...

    Sm6hans25 pointsBadges:
  • Excel 2007 Macros problem

    Hello, I am using Office 2007. The Macros are disabled when we open password Protected Workbook. What should we do?

    Mobilink115 pointsBadges:
  • Are you using Excel for cost estimating?

    Over at ConstructionSoftwareReview.com, we have noticed that a fair number of cost estimators, cost engineers and contractors in the construction industry use Excel to determine how much a particular project will cost and to prepare the cost estimate that they present to potential clients. Is...

    Beastwood1,105 pointsBadges:
  • How to link a macro by clicking on a cell of an Excel sheet

    I need to get the current time by clicking on the cell in Excel.

    78345 pointsBadges:
  • Date format in Microsoft Excel 2002

    In my program I pass values from VB to Excel for reporting. When I pass 03-01-2009 (3rd Jan 2009), in excel it shows as 01-03-2009. I have set short date format to dd-mm-yyyy, in control panel, regional settings. Also in excel, I set cell format through VB as ... Exl.Range("A1").NumberFormat =...

    Mayuri155 pointsBadges:
  • Exporting Exchange 2003 public folder calendar into Excel and then into a personel calendar.

    I need to export public folder calendar data into excel and them into a personal folder.

    Dre5 pointsBadges:
  • How do I export an Outlook 2007 public folder calendar to Excel?

    With Outlook 2007, I want to export from a calendar in a Public Folder into an Excel format. The Import/Export menu option only allows me to pick as a source for the export, a calendar in my personal folders. How do I export from a Public Folder calendar? This question was submitted by a...

    BrentSheets6,925 pointsBadges:
  • Export Outlook 2007 calendar to Excel spreadsheet

    How do I export Outlook calendar 2007 to Excel spreadsheet?

    Cwessner5 pointsBadges:
  • How to get AS/400 macro to pull data from Excel

    Hello I’m trying to create a macro on the AS/400 that will pull data from an Excel sheet and input data to the screen. I know how to create a macro to run the menu option by using the record macro button but not sure how to get it to access the excel file so it will run through the list.

    dluy688020 pointsBadges:
  • Lotus Notes calendar invitees into Excel spreadsheet

    I created an event with 8 separate invites because the group is that large. Now I'm supposed to turn the "accepted" responses from an email into their name and in an Excel spreadsheet. Would rather not comb through 1 by 1 through 1000s of names. Please help!!

    Brods135 pointsBadges:
  • Convert iSeries Character set in VB

    I am creating a VBA macro in an Excel spreadsheet to download selected data from an iSeries database. Running into an issue with character set. I don't understand VB well enough yet and have not had success w/ google in resolving this. I appear to be getting the data, but a lot of the fields are...

    azohawk675 pointsBadges:
  • Excel 2003 toolbar functions greyed out, but not Excel 2007

    I bought a new laptop which has a trial version of Office 2007. I have been using Office 2003 on this macjhine for a few weeks, & suddenly both excel 2003 & word 2003 have most functions greyed out, and excel and word are unusable. Excel & Word 2007 work fine (no protection is on). Could Office...

    Trevor1c5 pointsBadges:
  • How to send an Excel spreadsheet to Microsoft Exchange

    We currently have a user form that helps our users fill in data into a Excel spreadsheet. When the data is added in, it needs to be sent by email to several users. This is happening in a corporate organization that's using Microsoft Exchange. Now I need to create a new email account for the file so...

    ITKE352,565 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