Microsoft Excel

Problem in CCSID converting

I have a QM query that forms up a DB file. A physical file. A file that afterwards will be tranferred to the excel worksheet. All the source DB files (as well as all the records inside) that I use in the QM query are having the CCSID=297 (french). But the data itself stored in these DB files...

Puzzle - Find the number?

This is not a question & I am not sure if this is a proper forum. So I will let the site moderator decide. I recently came across a nice quiz which, I think, supports/encourages developing programming skills. So ... here is the puzzle. Find the lowest number with the following...

How to export an AS/400 physical file to Microsoft Excel?

how to export as400 physical file to excel

Microsoft Access 2007 Data Input & Report

I am given a Start date 1/3/09 and an end date 1/5/09. 3 days. I am given 1 of 4 Codes (I, C, V, O). How do I get Access to show one of the predetermined codes under a monthly calendar starting day 1 through 31? ie., Rec# Jan 1 2 3 4 5 6 ** 1 I I I 2 C C 3 ...

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

Cell color coding

I am using a spreadsheet designed by someone else and it has some formatting gin place that when a date is entered if it is within a certain period the cell goes green if not red and so on. I need to add some columns and apply the same formatting however for some reason I cant see the formula used...

CL Program

Hello, I have these queries on a job schedule now and, I want to export them to excel using CL.. PGM RUNQRY MYENTRIES1 RUNQRY MYENTRIES2 COPYTOIMPF FROMFILE(MYLIB/MYFILE1) (MYLIB/FILE2) ENDPGM Where do I send these two file to? and can I run both queries this way? thanks,

I am unable to do my Import, when I run my macros I received two errors, running excel 2003

I Need some ones' assistance with this error that I am getting in my excel spreadsheet: "compiler error in hidden module: ChroniclesExport " This error is only when I'm running the MACRO's function. The MACRO has been checked by other colleagues at my work and is running fine on some PCs & but it...

COUNTIF command using Excel and s comma-delimited file

I saved a comma-delimited file to my excel 2003 worksheet and had a problem using the countif command. It wouldn't recognize the text info. For example, countif(xx:xx,"abc"), it wouldn't recognize the abc cells. Can you help me?

AS400/iSeries Queries on a schedule

I have several queries that I run daily manually, I will like to know step by step how can I have my queries to run on a schedule using the SBMSCHJOB command, then I will like to export them to Excel or Access.

What is the difference between =+ and =?

Hi, I have a excel sheeting showing a formula as c1=+A1*B1. What does it mean? If I try with C1=A1*B1 the results are same. Then why do we need =+? pls help. Arun.K.S sarunmphil@gmail.com

CPYTOIMPF and EXCEL defaults

I have an issue when copying an AS400 file to the IFS. One field that is defined as 15 charachter and contains numeric data does not show up in .csv format correctly without reformatting the column to special. I also tried defining the field as numeric, and had the same result. Example of data...

Query/physical file headings

Hi, I have a query that creates a file. I transfer the file to my C drive as a cvs file that I send out to a vendor. He would like headings on the file.....I can't seem to find out how to do this.....I know this is a silly question but how can I get the column headings on the file? If I import...

I want data from AS400 PF to my windows system in form of XL sheet.

I want to create a pgm in any of the high level language supported by AS400. I want that when this program is run, an XL sheet is created and all the data in a specified PF should come in this XL sheet. If I am right, then every XL sheet has a limit on the number of rows it can accomodate. If...

Image storage in Microsoft Excel

I'd like to know the code or procedure to use in Ms Excel that will help me to lookup a photo into a cell. I've observed some customised banking software which is able to display the picture and signature of a client whenever his unique account number is entered. Could I use excel to perform the...

Menu Driven Macros

I have a database within Excel 2007. There are quite a few macros in it. I want others to be able to use the database and certain macros, but I want the options to be in a menu type layout not on the bar. I know this has to be possible, but I don't even know what it would be called to look it up....

file format or extension invalid

after using Excel 2007 for several months with no problem, I had to reformat and reload windows xp professional. then I installed Excel 2007 and now I can't open the xlsx files created by Excel 2007. I get the error in the above title box. Any help will be welcomed. Gervis.

Data transfer from webpage to excel

I have a complicated problem for data extract from a web site. It is about a horse race analysis. problem description as below 1. want to retrieve some historical data and non-dynamic 2. datas are spread into many different web pages and they are in asp. 3. pull down menu is on the web page and...

office 2003 excel filter

Within excel 2003 I have 1245 records in a sheet and I try to add an auto filter and not all items in that column are in the list, why. When I select just a few cells in the column and apply the auto filter the missing items are there but highlighting the whole sheet or just the entire column and...

Critical Path

I created a project plan and everything looks normal but when I want to view for a critical path (using Gant Wizard Chart), I don't see any critical paths. I am wondering what went wrong