• Excel 2003 toolbar functions greyed out, but not Excel 2007

    I bought a new laptop which has a trial version of Office 2007. I have been using Office 2003 on this macjhine for a few weeks, & suddenly both excel 2003 & word 2003 have most functions greyed out, and excel and word are unusable. Excel & Word 2007 work fine (no protection is on). Could Office...

    Trevor1c5 pointsBadges:
  • Paste from Microsoft Excel cells to Microsoft Access table successfully but…

    When I perform a Paste Append into the table, the field I need that is a hyperlink is being truncated, thus link fails. How can I get the link to pates exactly as is from Excel?

    Lpjedpp5 pointsBadges:
  • UNC alternative

    I have many excel worksheets that link to other worksheets. Some link by drive letter mappings and others have a UNC name. Is there a way to link without using the UNC name? Concern is what to do if the linked server is changed. Do we have to go through each spreadsheet and change the link? Or is...

    Smf170 pointsBadges:
  • How do I write this Microsoft Excel macro?

    Hi, I'm trying to create a macro that will move rows in my spread sheet. I am working with orders that are keyed into excel, once the orders ship or are canceled; the rows are highlighted green or red. I want these shipped/canceled (green/red) rows to cut from the first page and paste into another...

    Js7135 pointsBadges:
  • Extract text from HTML pages, separate into articles, extracts keywords, tag with keywords, import to wordpress

    We run a niche news B2B news service; every day we send out an email with between 10 and 30 stories in it. This email is then turned into an html page including all the stories, and uploaded to our website. This has been going on for around 6 years, so I reckon there are about 1500 individual HTML...

    Tangled5 pointsBadges:
  • Using a drop down window in Excel to look up a List .. The names shown are so small it is difficult to read them

    How can I get the Font larger in the drop down window in XL for say cells A1:A200

    Yoka25 pointsBadges:
  • excel table to text flat

    Hello, I am not an IT expert to start with! I have a series of tables in excel made of 3 dimensions. Two dimensions are vertical (indicator and country), one is horizontal (years). The different tables contain data for a variable number of years and for a variable number of countries and...

    Brunella5 pointsBadges:
  • split column into column

    I need to Split the single datetime column into separate date and time column in SSIS package and exprot the data into Excel Sheet. Can any one guide how to do it ? Thanks in advance.

    Shamilh10 pointsBadges:
  • Script to extract files information from ftp server

    Hi Wonder if you could help me with the following please. I would like to construct a script (in any language whichever it's easiest) which when run, it will log on to a ftp server using a generic account and password, then list the files in a specific folder that begins with the string "abc". The...

    Aiko2720 pointsBadges:
  • Search Excel Macro Help!

    I do not know scripting and i really wish i did, any help would be greatly appreciated!I have an excel document that I need to search through for a list of words, when of the words from my list is found, i need the word it found to be put into a new column.

    Abrkadabragimmeahandle5 pointsBadges:
  • Office minimizes after right clicking

    Whenever I right click while in Outlook, Word, or Excel the program minimizes to the system tray. Therefore, I cannot cut and paste, among all the other useful things. What is the cause and how do I regain control of the right mouse click?

    Jerjr5 pointsBadges:
  • Excel macros – code does not execute

    I have written the following macro. I do not really see it necessary to explain ehat it does, I only need help with a problem - for some reason it does not reach the code after the loop. It does everything exactly as I want it until and into the loop, but does not execute the code after the loop at...

    Wyaneva10 pointsBadges:
  • How to extract data to the various excel sheets in a CL.

    Hi, I am new to the CL (Command Language) used by the as/400. I need to generate a spreadsheet of data from the as400. I would like to have all the data stored in one excel file instead of multiple excel files. Can someone show me how to use the various sheets in excel to store the data and how to...

    Djsqueeze5 pointsBadges:
  • I am unable to do my Import, when I run my macros I received two errors, running excel 2003

    I Need some ones' assistance with this error that I am getting in my excel spreadsheet: "compiler error in hidden module: ChroniclesExport " This error is only when I'm running the MACRO's function. The MACRO has been checked by other colleagues at my work and is running fine on some PCs & but it...

    IVANZAMU40 pointsBadges:
  • Open XL file from ILE program

    We have a process that converts a spooled file into a .CSV file and stores it in a folder on the IFS. The user then opens Excel and locates and opens the file for editing etc. Is there a way to open up the file in Excel for them after its transferred to the IFS? Could you show me code examples...

    filuphaze475 pointsBadges:
  • Group Policy Objects

    i want to restrict users in my domain to protect their ms excle sheet. how can i do this

    Sagardip10 pointsBadges:
  • Excel 2003 – Conditional Formatting, please help a girl out :)

    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 B = Start Date Column C = Due Date -...

    Kelz82740 pointsBadges:
  • Excel 2002 Copy GetPivotDATA function

    I have a number of different items that I need to extract from a pivot table. Can I copy the GETPIVOTDATA function? it seems to get stuck and return only the value from the first cell

    Steve74745 pointsBadges:
  • MS Access Tools References…

    Cheers, Does anyone know where I can get a list of what a specific reference in Access can do. Specifically, I have VB.NET code that Imports System.Web.mail that I would like to use in my vba code. I have had luck with similar .NET code: I used the reference Microsoft Excel 12.0 Object Library...

    Rjwilcox45 pointsBadges:
  • How can I find an Excel formula that helps me change text?

    How can I find a formula that helps me change letters in typed words without the daunting task of retyping them again? For example, I typed (in a table) 100 words ending in -d, and I want the same words just without the -d or with -s instead. Or can I join letters to form different words? Copy and...

    Ja555you15 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