Microsoft Excel

Excel to Access conversion

Accounting came and asked me if a very complicated Excel spreadsheet that they are using for cash receipts could be "moved" into Access. I explained to them the difference between a spreadsheet and a database and that Access could definitely be used to better handle transactions etc. but it would...

Oracle Form: export to Microsoft Excel

I have an oracle form,i need the code of a function that exports a given SQL query into Excel sheet on a button click action.

Change English numbers to Arabic numbers

change english numbers to arabic numbers

AS/400 addon for Microsoft Excel

is there an addon that allows data to be sent back and forth excel to as400

File Transfer to iSeries from Excel 2007

I am using the iSeries Client Access for V5R4, and trying to transfer an Excel 2007 (.xslx) file. There is no corresponding file type to choose from (only goes up to Excel 2003 (BIFF8). Is there any other way to do this using Client Access

Inventory work for storeroom using Excel VBA

Im supposed to do inventory for a store room at work using excel. Oraganizing and labeling all the items in there so that my boss can be able to find what he wants easily by simply for example if he wants a clock he looks for clock and he sees its at b1 and he looks for b1 and that specific item...

email macro

create amacro to send an email with Excelattachment

VBA copying a range from Excel and pasting to a text file

Do you know how to copy from excel and paste to a text file using VBA?

iSeries V5R3 downloading to Excel 2008

Are there compatibility issues using File Transfer from iSeries V5R3 to download data to Excel 2008?

Importing to Excel one record appear on more than one line..

I am using crystal reports to make an excel file. I have different information for several people that needs to be put on this file. Each persons information needs to appear on one row instead of multiple rows. How do I manipulate crystal reports to show this information correctly?

Excel VBA - Cell value not being displayed

when i display all the values there is a cell that dosnt display it's result,but when u put the mouse on it in the comment box it appears

String Comparison VBA

I have two columns of string values in excel. They are part numbers so they are typically 6 - 10 characters and a mix of letters and numbers. The columns contain many like strings. That is, the part number is listed in both columns. I need a quick way to compare each string in one column with every...

VBA format a cell based on range contents

I need to create a macro that goes in to a worksheet and looks at the contents of a range to see if it contains any number other than zero. If it does, I need it to turn a separate cell yellow. 'assign variables Dim rngSat As Range Dim rngSun As Range Dim wsOT As Worksheet ...

Conditional formatting in Microsoft Excel 2003

Basically I have 2 columns the first column has years in it & the second has random letters. Now, going down the 1st column it reads: 2007,2007,2007,2007,2007,2008,2008,2008,2009,2009,2009,2009 And going down the Second Column it reads: A,B,A,B,B,B,A,B,A,A,A,B Note: This is just a segment of...

Raw Data not in Pivot

I have a large pivot table looking to a raw data worksheet. All the data in raw data is not showing in the pivot table.

Extracting max value from 3 columns of data in exel

My warehouse system contains length, width, and height calculations but the longest side isn't always in the correct column (length). Does anyone know how to extract the max, median, and miminum measurement across 3 columns of data?

How to insert symbols in AS/400

In Excel , when we try Insert->Symbol there appears a dialog box where it has all the funny symbols and one of our users requested a symbol which has a A and a bar on top of it(Latin Capital letter A with Macron) on iSeries which i fancied is not possible . Please could some one suggest if...

How can I export data from mainframe to Excel in REXX

i want to export data in PS to excel through rexx code.As i am a beginner in REXX .can any one help me in this .

Wildcard Characters

I have a formula to search for a code and return results. The problem is that within the code there are wildcard characters. How do I make wildcard characters searchable text?

Object Library Error

I keep getting this error when exporting Crystal Reports Ver. 10.0 to MS Excel 2003: Object Library invalid or contains references to object definitions that could not be found. Can this be fixed?