• Can I find an Excel merged cell size in VBScript?

    I have a set of Excel spreadsheets which all have similar properties and I'm trying to automate a set of processes on them. I'm a compelte VB beginner, but it's going ok - I've just hit a stumbling block with the internet isn't being very helpful with. Once I have found a certain cell, is it...

    Bengreen15 pointsBadges:
  • Put rows in numerical order

    I have data entered randomly and now I want to sort it numerically using a certain column as the numbers to sort.

    Kooka5 pointsBadges:
  • Excel 2007 – gauge, speedometer, or dial charts

    Hi, Does anyone have any idea were I could find some some sample templates on these 3 for: Excel 2007 - gauge, speedometer, or dial charts. Thanks Jared~

    Jreifenstein001185 pointsBadges:
  • Combo box in Microsoft Excel

    How do I link numeric values to word choices in my combo box? I have tried If Then's for if you pick a certain choice it = a certain number, but I'm stuck! Thanks.

    Toriel5 pointsBadges:
  • SAP export to Excel 2007

    When exporting a spreadsheet to Excel 2007, currencies show in the wrong format (ie. 1,882,456.96 shows as 1882456:96). I've tried to format the cell but this does nothing. Also I've verified switching the regional settings but no luck there neither. Help will be truly appreciated, Max.

    Duscher5 pointsBadges:
  • Convert spreadsheet into a flat file

    I need to convert a spreadsheet into a flatfile using the mid function. I only want to use a couple fields out of the spreadsheet, can someone help me?

    Kioh4650 pointsBadges:
  • Associate or link cells in Excel

    I have a 30 person sales staff and I'm keeping track of the sale of one item on a monthly basis (31 rows, 13 columns). There are ten 3-person sales teams and I'm trying to get a team total for the 10 teams based on what each salesperson sells during a given month. I can total each individual's...

    Rbecker6915 pointsBadges:
  • Unable to run macro in Microsoft Excel 2007

    I'm unable to run any macros stored in this workbook but macros stored in the personal file will run. What should I do?

    Rich6245 pointsBadges:
  • Exporting data from report 6i to excel

    Can anyone tell me how to export data from report 61 to excel? I am looking for the code to do this.

    Pandoogroup15 pointsBadges:
  • Excel Macro Help – .ThemeColor = xlThemeColorDark1

    The spreadsheet I'm working on pulls data from an oracle database and automatically populates cells for which there is no data with "999999." I am attempting to use an excel macro to essentially gray-out all cells that contain this value with the intention of saving users the time it takes to apply...

    Jwahl5 pointsBadges:
  • TMP Files in MS Office

    When I'm saving in DOC or Excel file, a temp file gets created automatically. That happens only when I'm saving the file to 2003 format though I'm using MS 2007.

    Wahaib30 pointsBadges:
  • Disable saving in Excel 2007

    Hi, I need to get rid of the save option. I only want the sheet able save when the document is closed and it asks if you want to save. I do not want the document to be saved any other time. Here is my document (Office 2007 Only). http://www.savefile.com/files/1848919 It has been made to book out...

    Juel35 pointsBadges:
  • Can I use then Forms 6i DDE build-in package to generate 2010 EXCEL File?

    Hi all, My company' application is used Oracle FORMS 6i Solution,Client /Server environment to generated EXCEL file I coding the PL/SQL in the Oracle FORM, it's succeed generated EXCEL file in MS office Excel 2007/2003/2000. Now I have problem in MS office Excel 2010. It's just opening the Excel...

    Wangakai5 pointsBadges:
  • Using Access query data in Excel

    I have a need to use some employee data that is contained in an Access database in a dashboard like application in Excel. I have tried several attempts at getting this data but have not had any success. I can move the entire file, but I really need to move only the data that meets some selection...

    Ronmcnaughton5 pointsBadges:
  • Multiple users to one Excel document

    What is the easiest way to share a spreadsheet between multiple users in Excel? If I am setup in a work group environment and need multiple users to use the same spreadsheet, I know you can do the "select Share Workbook under the Tools menu" but how does that affect saving edits for each user if it...

    ConFlicker210 pointsBadges:
  • How do I associate an employee # to a name in Excel 2007?

    I work in a restaurant and created a tip out spreadsheet. I need to insert employee names constantly. It would be much easier to just type in their employee# and have their name appear in another cell. Ex: Column A=Employee#, Column B=Employee's name. I want to type in the employee's # in cell A1...

    Weazel5830 pointsBadges:
  • Excel 2007 – How do I ignore zero’s and #DIV/0! for a graph?

    Excel 2007 - How do I ignore zero's and #DIV/0! for a graph? example: you have data that looks something like this: week # 1 2 3 4 5 6 PTP% 10% 13% 0% 0% #DIV/0! 0 % Then graph the PTP% across from week 1 which is 10% to week 6 which is 0% On the graph all u will see is the plots from week 1 & 2....

    Jreifenstein001185 pointsBadges:
  • Copy data from an entire row in Excel 2003 sheet to another sheet in the same workbook automatically

    I have an excel workbook that has a Year To Date summary in it. People enter new data into the YTD summary (along a row there are 15 columns of data to be entered). One of the criteria for the entries is report date. I would like to have other sheets in this workbook (Each named a month, ie. jan,...

    Wiggetssis25 pointsBadges:
  • How can I retrieve an Excel file saved in Hotmail?

    I opened an Excel attachment in Hotmail and started editing. I saved it continuously but when I closed Excel and reopened, the file was gone. I'm running Office 2007 and Windows 7 64-bit.

    Mohanb5 pointsBadges:
  • Print one row on all pages in Excel

    Hi, Does anyone know of a way to print one row on all pages in Excel, kind of like a header? Thanks, Dustin

    RoadDust390 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.

Thanks! We'll email you when relevant content is added and updated.

Following