• Microsoft Excel: How to find top 10 figures based on a condition like country wise

    I do have sales figures country wide and i would like to make a separate table for each country and populate top 10 sales figures in XLS. Thanks in advance.

    rangagom15 pointsBadges:
  • 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...

    ITKE434,530 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.

    ITKE434,530 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!

    ITKE434,530 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?

    ITKE434,530 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...

    ITKE434,530 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!

    ITKE434,530 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.

    ITKE434,530 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:

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