• 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:
  • Detecting MS excel is open in Citrix via Lotus Script

    I have an application that generates graphs using excel from data stored in a Lotus Notes Database. Once the graphs are created in excel,they are copied and pasted into a Rich Text Field in Lotus notes which is then displayed to the user so that the user never sees excel at all. However. If excel...

    WeDontByte30 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:
  • Upload data from excel to lotus notes in web

    How to incorporate the facility to upload data from excel sheet to lotus notes web?

    shivasanjay3,195 pointsBadges:
  • find and replace in excel

    I want to use the find and replace feature under Edit. i want to find a word and replace that word in a difference format. For example, replace charcoal with [strong]charcoal [/strong](in red, bold format), but instead it replaces [strong]ALL the contents in the cell[/strong] with 'red, bold'. I am...

    Lrhehn5 pointsBadges:
  • how to export to excel in web with heading row frozen

    I want to export to excel report in lotus notes web, when report is available it should be showing Ist column as frozen, , ie. 1st row should not move when scroll bar moved to up and down.

    shivasanjay3,195 pointsBadges:
  • Can you show lotus notes table rows as rows in a view?

    I have a table with 5 columns. Each row as 5 fields. first row, Field A, Field B, Field C, etc second row, Field X, Field Y, Field Z, etc I need to be able to show the table rows as as rows in a view to export to excel. I have tried using a lot of formula language in column formulas and it is not...

    Penguins10 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:
  • extenda x550 series

    I am using Extenda X550 (1+5) and having a typical problem while working in excel like - some area gets selected automatically - copy paste does not work - cursor starts moving weirdly

    Jaideep Khanduja11,225 pointsBadges:
  • Excel data and variables in SPSS

    I 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:
  • Displaying amount field in query 400.

    In query400, i created a report which will be downloaded to excel. If i download report, it is showing amount fields without decimal values. How to display amount fields with decimal fields using query400?  

    VJayashree185 pointsBadges:
  • Calculating Columns

    how do you create a formula using data tables calculate each divide each (3) quiz by 100 times .01 times 10%, each (2)test by 100 times .01 times 35% to get the final %

    Wandaj535 pointsBadges:
  • Automatic Publish web page when excel data changes

    I have 4 files created from scheduled jobs on the AS400. Each file automatically updates a worksheet in an excel spreadsheet. (sheet1 to sheet 4) On the 5th worksheet I have graphs based on the 4 sheets. I publish this final sheet as a webpage to the intranet but wanted to find a way for the...

    Gerrib150 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:
  • Excel .xla slow to save

    I have a custom toolbar saved as an .xla.  Works great.  It has always taken about 1 - 2 min. to save the .xla.  But about two weeks ago the save time increased significantly. It now takes over 12 mins. to save.  Any ideas.  I haven't added much in the last month.  Tried rebooting machine. ...

    Smf170 pointsBadges:
  • Excel Macro to password protect

    I have this spread sheet that I want to be able to protect from distrubution when given to one person. Is there a way of writing in a macro that will ask for a new password that is in a hidden list at the end of say 30 days and if not entered in the program will not be usable? I hope that my...

    Smarbada15 pointsBadges:
  • Send as excel received as pdf in Office 2003

    Hi, I have an employee who has a Windows 7 computer with office 2003. When she is sent an excel file, it comes through to her as pdf. We can't figure out why. Please help

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

Following