• 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:
  • vba loop help

    i am trying to run a simple loop, paste code. i am new to excel vba and am trying to teach myself. here is what i want to do, take the numbers one through ten and paste them one at a time into x. it looks like this. 1       x 2 3 4 5 6 7 8 9 0 once i can do that then all of the other math is...

    Opie9715 pointsBadges:
  • Re-linking data source in Word 2007

    I have a bunch of word documents that are linked to an Excel spreadsheet (master sheet) for mail-merge reasons. Now all these documents are templates on a server. I need to Copy-Paste the entire folder (Including all documents and the Excel sheet) onto my computer before editing them. My problem is...

    Minggggy5 pointsBadges:
  • Forms in Excel 2003

    I have created a form in 2003 Excel that has drop-down menu from a list file created on multiple worksheet within the document. This works fine. What I need to do is create a drop-down menu on a field that will not only bring up a list of title to choose from but also when a title is selected it...

    Mccuistionm5 pointsBadges:
  • email macro

    create amacro to send an email with Excelattachment

    Jraleccolin995 pointsBadges:
  • how to input excel file to crystal report in C# .NET

    How to input an excel file to crystal report and get a report in required format i.e as client requirement grapph,piechart or tables ? In c# .net

    C1915 pointsBadges:
  • How do I read in the comma delimited files by SAS

    How do I save an Excel File with 2 sheets into two comma delimited (.csv) files, first for the sheet tabbed "sheet 1" and second for the sheet tabbed "sheet 2"? Also, how do I then read in the comma delimited files by SAS? *note: these are excel files that I am trying to read into the SAS program

    Mimi1111115 pointsBadges:
  • Linked Workbooks return #VALUE error until linked workbooks are opened

    I used to save linked workbooks onto a remote server. One could be opened and it would display the last values it had. Now, the linked formulas show #VALUE error until the linked sources are opened. I'd really like to be able to open just one workbook at a time. Is there some setting in Excel 2007...

    Blubudda15 pointsBadges:
  • AS400 Transfer to Excel with a Locked Cell

    Hi everyone I hope someone can help me with this. I have an Excel template for a download for a group of users. The cell containing the formula was requested by management to be locked due to some of the users incorrectly removing the formula or leaving old data in cells outside the screen view...

    Patcoad30 pointsBadges:
  • db2 to excel

    i was tryin to import from db2/400 into excel but when i did. the description came up in a different language...in db2/400 the description was in araic then when i imported in excel it came up a different language?? any idea plz help  thank you

    Doodoo5 pointsBadges:
  • Inputing greek symbol in concatenated text

    I am trying to concatenate the contents of several cells (which contain alpha numeric data) into a text statement and and also concatenate the Greek letter "mu" representing micro to the end of the statement. When I do this it appears as m. It seems as if I need to be able to specify a symbol font...

    HENRYj5 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