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

    ITKE435,950 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!

    ITKE435,950 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?

    ITKE435,950 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...

    ITKE435,950 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!

    ITKE435,950 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.

    ITKE435,950 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:

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