• Excel affecting other windows

    When one of the employees that I deal with saves or copies a document in excel, it closes all open windows on the desktop and doesn't save or copy the document. This issue is intermitant. Any ideas?

    Wolfshaker5 pointsBadges:
  • Display External File Properties in Excel

    I have an MS Access database that uses two tables (tblOrders1 and tblOrders2) that are linked to two MS Excel spreadsheet files (Orders1.xls and Orders2.xls). The Excel spreadsheet files are occasionally updated by being replaced with new files with the same file names. I want to continuously...

    OdeMitch35 pointsBadges:
  • Using a combobox to control textbox

    how do I code this?

    Wstring0115 pointsBadges:
  • How do I sort an entire state customer list by only the zips I work with?

    how do I sort an entire state customer list by only the zips I work with

    Mayabel025 pointsBadges:
  • iSeries File Transfer

    How do you create the iSeries file transfer icons in Excel 2003

    KKile5 pointsBadges:
  • SQL To Excel Data Dumping with the help of SSIS flow task.

    I am trying to do a Sql To Excel Data Dumping with the help of ssis flow task.I create a sql connection and give the query in the sql source.I aslo have a excel template to map in excel destination ready which has around 400 columns/fields.In bettween i use a dataconvrsion for unicode/non unicode...

    Ssis5 pointsBadges:
  • Excel 2003 cell protection function

    How to lock selected cells when the protect sheet feature is turned on?

    Damient5 pointsBadges:
  • Enabling xlmacro help in Excel 2003

    Excel 2003 includes the file Xlmacro.chm linked to "Help on this function." When I click on "Help on this function" the XlMacro.chm file is not loaded - actually nothing at all happens, not even an error message.

    HSExcel15 pointsBadges:
  • minor loss of fidelity but cant find data!

    I have a large database saved in xls. 2003; I changed one column heading and got a message that reads: Compatibility Report for Thurs Brkfst Data Base.xls Run on 11/20/2008 16:50 The following features in this workbook are not supported by earlier versions of Excel. These features may be lost or...

    mmpp295 pointsBadges:
  • Script to add a Period after a Middle Inital- Then query AD for User ID

    I would like to create a script that parses an excel spreadsheet column with user's full names (I.E. 'John A Smith') and inserts a period (.) after the middle inital character. (I.E. 'John A. Smith') Once the middle inital period has been inserted, I would like the script to query Active Directory...

    AASuperTech5 pointsBadges:
  • How do I bring specific data from one Excel spreadsheet to another?

    We currently pull a report of data that needs to be broken into many client related files. Not each client needs all the data that is reported in this Excel spreadsheet. Is there some sort of method that we can automate this process to pull data, align in a new Excel spreadsheet with specific...

    Jtuliao5 pointsBadges:
  • Cross associate between 2 excel 2003 files

    I have a data base of 3000 products each product has a unique code followed by 5 different cells of information. I need to, on a daily basis produce a spreadsheet showing which products are used in each of 400 shops. All i want to do is type the unique code in column C on the spreadsheet and have...

    Tallbloke5 pointsBadges:
  • Getting rid of multiple macro copies in Excel 2003

    Somehow, in Excel 2003 I have 4 copies of the same macro on the toolbar (not sure how that happened).  However, when I click on Tools>Macro>Macros, there are no macros shown, and all options are grayed out except Cancel.  When I go to Tools>Add-ins, one copy of the macro is shown, and it...

    Rerics595 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:
  • New at Excel VBA Need Help Please!!!

      Can anyone help? Below is a basic way to find rows that match 3 criteria, work out the average to each column G to M of all the rows that match the criteria and copy and past to a repot sheet.

    Opus35 pointsBadges:
  • How to make excel rows/columns writable by only specific people

    I have two users working on the same spreadsheet, both should be able to write to only their specific part of spreadsheet, i.e. user2 should not be able to overwrite what user1 has previously entered. I know NTFS permissions, will operate on the file level, but I guess I'm looking to restrict it to...

    Pandub130 pointsBadges:
  • Excel that increments number when created from template?

    Hi all, Need to create an excel template that everytime it's opened, it increment a number in the excel spreadsheet. The idea is everytime a file is create from the template, it gets a unique number. Also do you think it possible to use this unique number as the name of the file to be save. For...

    Pandub130 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:
  • 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:

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