Load Excel with Japanese characters to iSeries DB2 file

How do I load an Excel spreadsheet containing Japanese characters to an IBM iSeries DB2 file?

tonycurtis135 pointsBadges:

MS Office 2007 Excel files not opening

I have MS Office 2007, Windows 7. When I double click on an XLS file, Excel opens up but it is just a empty Excel program. It is similar to opening up Excel and then just closing the book1 that opens up automatically. Just a grey background. Also I can't open up XLS files by doing File > Open or...

CharlessReynoldss5 pointsBadges:

Copying Outlook messages into Microsoft Excel using VBA

I'm fairly new to Macros and VBA. So, on a daily basis, I receive roughly 50 emails with one specific subject - Task Completed. Now, I made a rule that moves them directly into a Task Completed folder. But now reading all these emails has pretty much consumed my day. Is there a way I can copy these...

ITKE1,068,150 pointsBadges:

VBA Exporting to text file

I am trying to make a VBA to copy multiple cells from excel to notepad in this sort of format: Interface GigabitEthernet1/0/1 Switchport access vlan 990 shut But all I seem to be doing is copying the top line over and over again. Here's the code I've been using: Sub exprtToText() Dim ff As Long,...

Dozii35 pointsBadges:

How to repair and recover corrupt MS excel file?

How to repair and recover corrupt MS excel file? I am unable to open corrupt MS Excel file due to virus infected, I have crucial Workbook sheet got lost, so how to get back corrupted MS Excel file. Please help me.

DredSelpy5 pointsBadges:

Microsoft Excel: Convert number into column

Could I convert a number to my Microsoft Excel column name? Now, I can't use automation (basically I can't get the value straight from Excel). I'm also using Excel 2007. Thank you.

ITKE1,068,150 pointsBadges:

Break through password on Microsoft Excel VBA

The project I'm currently working on is to update some macros in in Microsoft Excel. But here's my issue - a bunch of the VBA projects are protected by a password that I don't know. Can I remove / break through those passwords? Thanks!

ITKE1,068,150 pointsBadges:

How to convert Excel file to CSV

I currently have a Microsoft Excel that has characters in different languages. I have to convert it to a CSV file. But when I'm trying to save it, those characters are destroyed (FYI - those characters aren't ASCII characters). How can I go about doing this? Should I use UTF-8?

ITKE1,068,150 pointsBadges:

Recordset in Excel spreadsheet

I have table of counties and one query, I want to loop through the same query that produces a separate report for each county and export each one to excel spreadsheet

karenMcCracken20 pointsBadges:

What is the next step for an Excel database?

I have been developing Excel applications for 6 years. Creating Scheduling, Invoicing, Estimating, HR & CRM applications with Excel exclusively. As my applications and customer needs get larger i have been running into some headaches with Excel as a database. Customers want to share workbooks...

Excel4Business15 pointsBadges:

Copying data from Excel workbook with VBA

I'm currently working in Microsoft Excel and I have one workbook that I need to collect data from different files. Here's what I have so far: Do While THAT_DIFFERENT_FILE_SOMEWHERE_ON_MY_HDD.Cells(Rand, 1).Value <> "" And Rand < 65536 then 'I will search if the last row in my main...

ITKE1,068,150 pointsBadges:

Finding data in Microsoft Excel spreadsheet using a macro

I'm using Microsoft Excel and I'm looking to find the last row that contains data in a specific column on my spreadsheet. How can I do that with a macro? Thank you!

ITKE1,068,150 pointsBadges:

Change to Crystal report affect export to Excel

We have a Crystal Report that has been being exported to Excel for a few months. It is then imported into an Excel template with macros. We have used this report and the macros have worked properly for several months. Recently I made a change to the Crystal report, adding subtotals to the footer of...

cbonnell5 pointsBadges:

How to use Excel icon in SAP to export a report

I am using a transaction code ZASLIDET to pull a report. This T-code has an Excel icon which should allow me to export the report in a clean format, but when I click on that excel icon, I am only getting blank spreadsheets. How to enable this excel feature to export the report?

Larisaivanova5 pointsBadges:

Reading Microsoft Excel using C#?

I need help ASAP! Can anyone help me? I need to figure out how I can read an important Microsoft Excel file using C#? Thank you very much.

ITKE1,068,150 pointsBadges:

Microsoft Excel macro If Script

I'm no macro expert, so I need a little helps with this. Here is what I am trying to do: If (2,36)="2C" then (2,37)="Physician" If (2,36)="1E" then (2,37)="nurse". Then I need to apply this to the whole column. so that if (3,36)="2C" then (3,37)="Physician" and so on down the column. What I am...

PatrickKP5 pointsBadges:

Export contacts info from Outlook 2007

Can someone suggest the easiest way to export my personal Contact information from Office Outlook 2007? I want to migrate my personal Contact information from office Outlook to my home computer. Early response will be much appreciated as I am leaving office from this Friday (1/30). Thank you.

SbElectric2,540 pointsBadges:

$ sign and numbers after decimal

One of my columns is for a $ amount that never changes for that particular person. Recently, I wrapped the text to print out a readable copy. For some reason I lost all the $ signs in that column. Also, when changing an amount such as $176.37, the .37 will not stay.  The $ sign is true for all 129...

kaykay9085 pointsBadges:

Microsoft Excel: How can I display the users names of the top three counts

In my Excel spreadsheet, is there a way I can display the users names of the top three counts? Thank you.

Userdj25 pointsBadges:

Monthly call volumes vs. weekly call volumes for determining required head count at call center

I need an advice on what is the industry to calculate the monthly required headcount of a single service at contact center. I'm using erlang C calculator on Excel and one of the inputs required for this formula is the per interval (1 hour) number of calls. But this formula does not define the...

aalsbiei10 pointsBadges: