• Analyzing an Excel spreadsheet divided by categories and subtotal

    Column B has various vendors, column F Has Totals, Row 5 has a category subtotal which totals all categories in column 250,and row 7 starts a new category. I would like to create a total of each vendor in a table, what is the best way?

    Kerrie12345 pointsBadges:
  • Reading Excel with RPG HSSF

    I set up a program to read Excel on my AS/400 using the klement examples then move to user AS/400 and cannot get it to read the Excel. Program compiles fine.

    mr400man5 pointsBadges:
  • Row of data not transferring to Microsoft Word when using mail merge

    I'm using mail merged to transfer data from Excel to Word for my job. I just had to write a bunch of code to update to Word 2013 for it to work. However, when I try to transfer everything, it works perfectly except there is a whole row of data that does not transfer to the Word document. Everything...

    SARAHCYOUNG205 pointsBadges:
  • Export / import data from Excel to SQL database

    Hi, I want to do one program in which I have one Excel sheet that some data can be stored. I want to import that data in VB.NET application and store it in a SQL database and do same thing vice versa. Which means I can fetch data from SQL database through VB.NET and store that data in Excel. Please...

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

    ITKE407,505 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.

    ITKE407,505 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!

    ITKE407,505 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?

    ITKE407,505 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...

    ITKE407,505 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!

    ITKE407,505 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.

    ITKE407,505 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following