• 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:
  • 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:
  • SQL 2005 SSIS 64 bit EXCEL

    How do you configure driver to read EXCEL 2003 for SSIS on 64 bit SQL Server? How do you configure EXCEL 2007 for SSIS on 64 bit SQL Server?

    Oldmickey65 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:
  • 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:
  • 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:
  • 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:
  • 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:
  • Outlook 2003: Export PST Emails To Excel

    When I use the "File > Import & Export" command from Outlook 2003, I have mixed results. I keep my emails in sub-folders off one of several PST files that I use regularly, in the "All Mail Folders" side-panel. I broke up the larger folders into smaller ones in case there was a size limitation. I...

    CaliforniaJerry5 pointsBadges:
  • Trouble with Unload statement in VBA

    What am I missing? I have written code with an Unload Userform statement that doesn't seem to wipe out the Userform from memory. For Ex: (Default: CheckBox1.Value = False) MyForm.Show CheckBox1.Value = True Unload MyForm MyForm.Show So, the form is shown to the user, and they mark CheckBox1 so the...

    McNitro255 pointsBadges:
  • Issue viewing “additional controls” for toolbox in VBE

    I am unable to view the dialogue box when I select the "additional controls" option from the VBE menu bar, or when right clicking on the toolbox itself.  The project I created on one computer includes several forms, one of which includes a few DTPicker(s).  Some internal office issues have forced...

    McNitro255 pointsBadges:
  • Storing a ComboBox selection as a variable

    I have written a reporting procedure with various company code variables representing full company names. Different reports will be generated according to the company code that is plugged into the procedure. I am trying to create a ComboBox that allows the user to select the company code, which...

    McNitro255 pointsBadges:
  • Working with Login Userforms

    I've been doing research on Login Userforms and have come up with a code variation similar to coding trend. However, I am having an issue clearing the previous information, allowing the user to reenter their password before the loop continues. (i.e. the user inputs "password", receives an invalid...

    McNitro255 pointsBadges:
  • Excel to Access conversion

    Accounting came and asked me if a very complicated Excel spreadsheet that they are using for cash receipts could be "moved" into Access. I explained to them the difference between a spreadsheet and a database and that Access could definitely be used to better handle transactions etc. but it would...

    KSoniat610 pointsBadges:
  • Global Search Parameter – Microsoft Query

    I have a microsoft query setup in excel 2003 using parameters where the user inputs a departure airport and then a destination airport to retrieve various sales data. However I want to be able to leave the departure parameter blank so that on occasions the user can retreive ALL departure aiports...

    TrueBlue7615 pointsBadges:
  • Object Library Error

    I keep getting this error when exporting Crystal Reports Ver. 10.0 to MS Excel 2003: Object Library invalid or contains references to object definitions that could not be found. Can this be fixed?

    Mzdoreen5 pointsBadges:
  • Link Outlook Calendar to Excel Spreadsheet

    Hello I am new here and this is my first post. I am wondering whether is possible to link Outlook 2003 Calendar to a spreadsheet in the same way as you would link 2 spreadsheets. For instance if a new entry is created in the Calendar the spreadsheet would be updated automatically. So far the way I...

    Yosiniro5 pointsBadges:
  • VBA How to get cpu usages and updated in every one hour,in with in the system.

    How to get cpu usages and updated in every one hour,in with in the system.

    Rajuaruna70 pointsBadges:
  • VBA EXCEL 2003 table coding

    Trying to write VBA code taking daily averages from datalogger (144 values/day). Its placing the averages every 144 lines apart in excel sheet. Looking for coding to condense averages into table.

    Bellyflop5 pointsBadges:
  • Excel custom format, weekday & date line break query….

    I created a spreadsheet which is to act as a rota, with the day and date displayed to the left. I entered the date then went to the custom format tab and entered dddd dd/mm/yyyy so it would display the day and date. So it can be printed with all the relevant data it is nessacery for this data to be...

    Dangerchef35 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