• Exporting data from SSIS to Excel

    I am trying to export data into Excel from SSIS. For the purpose of this question, the table is called “products” and has two columns. I would like to extract each row of data into a separate Excel file and save it with the product name so I can email it accordingly. How do I go about this?

    WindowsServerATE335 pointsBadges:
  • Export from Visual Basic 6 to Microsoft Excel file

    how to export visual basic6 to excel file

    Goood5 pointsBadges:
  • Change date format

    I have a date field stored in the i5 as yymmdd that I would like to change to mmddyy when exported to Excel. If I just re-format the cell, Excel treats the number as a Julian date and mis-corrects the date. The other issue is that Excel drops the leading 0 so everything in this decade is...

    DanBubis75 pointsBadges:
  • What formula is needed for this below in Excel?

    What Excel Formula's could i use? First # is starts with 1  back slash 2400.   2400 stays the same only first # changes. example below: [table style="border-collapse: collapse; width: 65pt;" border="0" cellpadding="0" cellspacing="0" width="86"> [col style="width: 65pt;" width="86">[/cOLIST]...

    Jreifenstein001185 pointsBadges:
  • The “TRUNC” Function in Excel

    I used the "trunc" function this way "=TRUNC((H41-(I41*25))/10,9)", where H41is "=(A41-INT(A41))*100" and I41 is "=TRUNC(H41/25)".  A41 is 346.95. With the Excel 2003 version on my computer, the result is 1.999999999; when, in fact, the result should be 2. What am I doing wrong?  Or is there a...

    Whabby90 pointsBadges:
  • excel encryption

    I wish to encrypt and send excel spreadsheets to customers where they can modify some input data and calculate but not read formulars or change the spreadsheet. I want a form of security that is better that the standard microsoft encryption that cannot easily be broken by password crackers.

    Mosswood5 pointsBadges:
  • Should we use Web services to develop this integrated application?

    We are developing an integrated application that will incorporate excel application, access databases and pda applications using visual basic 2005. Problem is whether to use web services to develop the project. This request for help was originally submitted to the Research Assistant on WhatIs.com.

    ResearchAssistant855 pointsBadges:
  • Automatically Transfering from Excel to iSeries

    I see there is a Transfer Data to iSeries option but is there a way of making this run automatically daily? Can something be schedulled from iSeries to initiate that? I want to reduce user intervention so would prefer not forcing the user to daily execute the upload. Any suggestions? Thanks, Rod

    RodVerity20 pointsBadges:
  • Excel 2007 Large file issues

    I use Excel 2007 to do a fairly large multidepartmental Financial forecast and results package. The file size is currently at 48,000 KB and will continue to grow. I have this file open along with others of its size at the same time during use. Frequently Excel will crash during an autosave, when...

    Excelguy5 pointsBadges:
  • iSeries to excel Order of PF changes

    when I use a DTF to download directly to excel the order of my data changes. The PF is NOT keyed and I am NOT selecting any order on the DTF. It is intermitten. any suggestions?

    AmandaC30 pointsBadges:
  • Problem refreshing excel 2003 ms query using excel 2007

    I have several ms queries that were created using excel 2003. Now I have excel 2007 and I can't refresh or even edit the queries. I get odbc errors like 'data source name not found and no default driver found. I can create new ms queries in 2007 from the same database with no problem. I just...

    KA5 pointsBadges:
  • Transfer particular pieces of data from Excel into Word over a large number of documents

    Thank you for coming and reading my question! I am trying to write a letter in Microsoft Word 2007 that will be personalized with the names and addresses of about one thousand donors to a non-profit organization. I have a spreadsheet containing everyone's name and address in Microsoft Excel 2007,...

    JeanClaudeWasTaken5 pointsBadges:
  • Need loop to cut rows that meet criteria and paste to another sheet.

    I want a loop that will look at the first four words in column A and if they match then the entire row should be cut and pasted to another sheet.

    Mdsc25 pointsBadges:
  • String Comparison VBA

    I have two columns of string values in excel. They are part numbers so they are typically 6 - 10 characters and a mix of letters and numbers. The columns contain many like strings. That is, the part number is listed in both columns. I need a quick way to compare each string in one column with every...

    RoyAdler5 pointsBadges:
  • EXCEL 2003 – CONDITIONAL FORMATTING

    Hi, I am working with a tracking schedule for my job, and I am trying to impliment conidtional formatting into it, but some of it it just not working for me. I am working with Microsoft Excel 2003 and I was wondering if you could help me with my problem. Column L = Start Date Column W = Due Date -...

    Kelz82740 pointsBadges:
  • Converting Data in Excel to PF on DB2/400

    Hi All, I have data in the excel where each column equal to the field of a physical file. I want load this data into the PF on AS/400. Could any one let me know the process on how to do it. Thanks in advance

    rajsubhyd105 pointsBadges:
  • One macro to systematically run F5 key on up to 20 other macros

    I have put together a series of macros which autofilter information to create a report on different tabs within a workbook. Having 17 macros all similar it would be handy to have one macro which would systematically activate each Module in turn and therefore require just the one key combination...

    AsHappyAs75 pointsBadges:
  • Can any one correct this Microsoft Excel VBA code?

    ANY ONE CORRECT THIS Sub fill_series() Dim myrange As Range Set myrange = ActiveCell.Offset(0, 5) Range("N9").FormulaR1C1 = "Apr-2008" Range("N9").Select Selection.AutoFill Destination:=myrange, Type:=xlFillDefault End Sub

    Sa2915340 pointsBadges:
  • VB Active Cell problem

    I am a vb problem. On an excel sheet, I am trying to have a macro run when the user selects a changing column's active cell. For columns F to I on Sheet!Data, if you choose any cell in range (F9:I65000), then take the value of Column B in the selected row and make as my "Dept" Value. Can anyone...

    RICPickles5 pointsBadges:
  • Excel Page setup Landsacape

    How to write a VB script to change the Excel file page orientation to Landsacpe.

    Dha5 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