• Can I use then Forms 6i DDE build-in package to generate 2010 EXCEL File?

    Hi all, My company' application is used Oracle FORMS 6i Solution,Client /Server environment to generated EXCEL file I coding the PL/SQL in the Oracle FORM, it's succeed generated EXCEL file in MS office Excel 2007/2003/2000. Now I have problem in MS office Excel 2010. It's just opening the Excel...

    Wangakai5 pointsBadges:
  • How do I associate an employee # to a name in Excel 2007?

    I work in a restaurant and created a tip out spreadsheet. I need to insert employee names constantly. It would be much easier to just type in their employee# and have their name appear in another cell. Ex: Column A=Employee#, Column B=Employee's name. I want to type in the employee's # in cell A1...

    Weazel5830 pointsBadges:
  • Why does Excel keep crashing?

    I have a relatively small file used for work. It contains 20 worksheets (most have very little information, or none at all, which all work fine except for one of them. It WAS working fine, but now every time I try to add or delete a row (which I have to do often) Excel 'encounters an error and...

    ATCPurdue65 pointsBadges:
  • Help to debug VBA code for Excel 2007

    I’m trying to have Excel look at the contents in Cell E (Account #2) and match it with A,B,C and extract to another sheet. B cell goes to 427,776 rows and E cell goes to 1,406. The end goal is to get the Salesforce ID & Company name lined up with the accounts in Account #2. I’ve got to load...

    cheekymonkey5 pointsBadges:
  • Programming quiz – Excel, VB etc.

    Recently heard an interesting quiz and thought it will be fun to see the solution done programmatically. The quiz is as follows: A person bought an old car with over 170,000 miles on it. The odometer is a digital device with 6 digits. The odometer shows only full digits – no decimals. One day as...

    SbElectric2,540 pointsBadges:
  • Excel File from PL/SQL Procedure

    Hi, I have an Oracle PL/SQL procedure that creates a csv file with output. I would like to create an Excel spreadsheet with multiple tabs, seperate information in each tab. Can you advise how I achive this in PL/SQL. Thanks Heather

    HeatherM5 pointsBadges:
  • Append extra zero on the numeric field using Data Transfer Excel Add-in

    My PC configration is MS Window 7 Professional (64-bit Traditional Chinese version), MS Office 2010 (32-bit Traditional Chinese version) and IBM Client Access V6R1M0 (64-bit English version). The problem is that the actual numeric value is 1,2 or 3 only in the physical file. After using the Data...

    Mingwong30 pointsBadges:
  • Download AS400 Physical File to Excel Using VBA

    I am in the process of developing an Access database with the intention of using it to control the download of AS/400 physical files into Excel. I am fine developing the Access / Excel side of the data, however I ahve no experience with the AS/400 side of things. The access database will contain...

    Martyjw5 pointsBadges:
  • extract data from as400 to excel

    I have CL and DB files and i need to extract the data from the files to excel sheet by writing an program.How can i do that?

    Copinky45 pointsBadges:
  • Data and Variables in SPSS from Excel spreadsheet

    have an Excel spreadsheet with responses to questions from a 49 question survey. At the top of the spreadsheet I listed each variable that the questions address. When I transfer this to the data page in SPSS, it lists the variables on the variable page with sequential letters after each variable -...

    Terrymb310 pointsBadges:
  • Forgot password on Excel

    In LAN environment, is there any way to find out forgot password that I set for excel spreadsheet?

    Eogy60 pointsBadges:
  • Problem with AS/400 data transfer to Excel

    I have been downloading AS400 query files to Excel spreadsheets for many years using the Data Transfer utility in Client Access. There has never been any problem. Now suddenly all of the output data has started transferring to Excel as long hexadecimal strings and is unusable. I asked the IT folks...

    JDK55 pointsBadges:
  • Excel 2007 ‘Edit Links’ Command deleting information

    I received a file from our corporate office. Some of the formulas in the workbook were referencing a location on a persons C:documents and settingsthatpersonmy documents. I wanted to change the reference to the existing file instead of the past months file it was looking at. I went into DataEdit...

    Hporiginal15 pointsBadges:
  • Need help using excel to amend ibm reflections

    Hi, I have been tasked with updating a database using IBM Reflections for 1600+ entries. I have been doing it by hand so far and have seen threads but never gotten enough info out of them. What I want to do, which I would do if it were two excel files, is update the database file by using a vlookup...

    Riotburn15 pointsBadges:
  • Microsoft Excel report generation from Oracle Forms 10g

    what is the procedure or builtins used to generate a excel report from application server in oracle forms 10G.

    Pupun5 pointsBadges:
  • how to use databases made in access or excel in sql

    how to use databases made in access or excel in sql   importing readymade databases in sql

    Dragan1525 pointsBadges:
  • Reports to be pulled from iSeries

    Hi. I have a query regarding pulling the report from i series, am working on I series when i pull the report into txt format in notepad,when  i copy and paste it into excel it displays unwanted rows with blanks and some special characters and word like particulars would be splitted like parti cula...

    Ausboi095 pointsBadges:
  • Excel: Hyperlink to Lotus notes with message field populated

    Hello I have a spreadsheet which just has email addresses on it.  When I click on them they open a new email in Lotus Notes.  I want to know if there is a way to make it so that when I click on the hyperlink the message field is populated with a template letter which can be edited by the user...

    Hosteen5 pointsBadges:
  • Performance files to Excel

    I know how to run performace tools on Iseries but how can I download the Iseries performance files into Excel and create a graph on the data? Thanks

    DudleyShaw15 pointsBadges:
  • Lotus Notes 8.5 documents to Excel worksheet

    Exporting documents to Excel worksheet.  Going well, but need to have the Excel sheet open in landscape.  What would be the commands for that?  This works fine so far: currentprocess = "formatting the spreadsheet" wsheet.Name = viewname wsheet.Cells.Font.Size = 10 wsheet.Rows("1:1").RowHeight =...

    TrinidadM5 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