• 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!

    ITKE392,185 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?

    ITKE392,185 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...

    ITKE392,185 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!

    ITKE392,185 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.

    ITKE392,185 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:
  • Saving Excel spreadsheet to multiple locations

    Is there a way to save my excel spreadsheet to both my computer file and the evernote file without the extra save as step?

    jerrydavisvybranz5 pointsBadges:
  • Microsoft Excel report generation from Oracle Forms 10g

    what is the procedure or builtins used to generate a excel report from application server in oracle forms 10G.

    Somnath895 pointsBadges:
  • Creating an Excel 2010 comparative monthly and yearly report to reflect trends

    I need your help on what information I need to enter to create a pivot table and a chart to compare in Excel 2010 to compare the monthly and yearly denials.

    guerreroaa55 pointsBadges:
  • Microsoft Excel: Setting for default sort based on remaining columns

    In Microsoft Excel, is there any setting for default sort based on remaining columns?

    addankirao5 pointsBadges:
  • Transfer data from iSeries RPG to Excel

    How can I transfer data from iSeries RPG to Microsoft Excel?

    Rmw10 pointsBadges:
  • AS/400 file to Excel with Headers and Footers

    I need to attach an Excel s/sheet to an email. I currently do that via the CPYTOIMPF as a CSV file but this doesnt give give me the true Excel Header row, which is a requirement. Is there any easy way to do this?

    NJFred35 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