excel 10

I just got a new laptop with windows 7 and when I click the file open icon in excel 2010, the entire spreadsheet locks up. It sounds like this could be an add-on issue. The only add-on I have is pdf filemaker. Once I am locked up, I have to kill excel through the task manager. Has anyone...

Hi everyone, I am new here and I really need your help. I am creating a excel macro to copy some information to a word file as plain text, after that, I am trying to format the pasted text. The macro runs fine once, the second time I try to run it, I get the run-time error '462'. If I tried...

I read some other posts saying that this cannot be done, but was wondering if anyone has a way to work around what I am trying to do. II work in a manufacturing facility where our product is recorded in real-time. My program opens an IE window for a specified date/time range copies the data that...

I've created a user form to enter some values in a few adjacent cells. When the user clicks on a button, I want several other cells to be loaded with special formulas that refer to the new values. This happens on a row by row basis. First, a working formula in that cell which is AB5 is...

Hi Guys, I have a template which is there in Templates folder of C:\Program files(x86)\Microsoft Office\Templates\London folder. Now when I click the icon from word ribbon which i have created to initialize the signature template from the London folder, it should pop up Signature user form with...

Hi I am trying to make certain calculations using the available data, which is as: Available Data Sheet 1 a3:L12 = Data with numeric values - months from Jan, Feb,... Dec n3:y12 = Name of Team members to be punched as desired, Jan, Feb, ... Dec, names from the list of Sheet 2 in the range...

My work uses a macro with one specific file that seems to work on every computer but mine. When I run the macro, I get the Run-time error '06 overflow message. When I use the debug option, it brings me to a part of the code that shows " x = x + 1". As I've said, this macro will work on the same...

I need to create a database out of daily emails dropping in a specific folder. 1> Emails seggregated into folders upon arrival with the help of RULES, 2> Upon arrival, same emails are Exported to Excel file 3> Excel file on Auto Save & Auto Update mode 4> all exported data is formatted as...

Hello, I am trying to work with a VBA macro which loads data from a microsoft excel file onto an Access database. This previously worked under our old systems (which also had Excel 97-03 and a previous version of Windows). This last week we were upgraded to Microsoft Office 2010 and Windows...

I have a pivot table that has a category column field (with categories of 15, 25, 45, and 65), a Status field (High, Medium, Low), and a Code field (X1, Y1, Z1, L1, etc.). The codes always match up to the same status (so L1 is always Medium, for example), so that data is somewhat redundant. At...

Hi, I have an excel file to keep track of inventory. 1st tab is an overview of the quantity available for each item. column A "Product Code", column B "Description", column C "Qty on 12/1/12", column D "Qty In", Column E "Qty Out", Column F "Total on Hand". 2nd tab in the tab where I insert...

Hi I am confused as to which function would be best suited for the following situation. I have tried using vlookup, indirect, index, match and max with no success. I havent used excel since college in 2005. I have a feeling this is a fairly simple funtion but I have exhausted my brain digging...

Hello, I am trying to make a scheduling spreadsheet that can give visuals and allow for a lot of variable change. I am needing some input on how to change the color of a cell. I don't want to use conditional formatting, because every time I add a new project, I will have to add the formatting...

Hello, I am needing some help calculating the number of working days between two dates, with the number of working days per week being variable. Not sure Excel has a built in function for this? I have checkout out weekday, workday.intl, and networkingdays, but they do not offer exactly what I...

I'm trying to highlight a row (columns 1-5) in a color based on two criteria: 1. The cell in column 1 of the previous row must not be blank. 2. The cell in column 5 of the current row must be blank. Here is what I have put in as a formula...

Hello -- I need to extract all the comments from all of the worksheets in my workbook, and I found the following <acronym title="visual basic for applications">VBA</acronym> code online which is great (How to Extract Comments in an Excel Sheet | TheAppTimes), but I need help to know if I can get...

Hi I have timesheet spreadsheet application,and this spreadsheet require to add new sheets for new employee using vba iam adding new sheets by copying sheets("sample") for every new employee,and this sheet("sample") contains Named ranges with scope to workbook,but the problem is : every new...

Hi Forum, I have a list of 24 names, and I have a spreadsheet with thousands of records, the 24 names show up multiple times within that sheet. Rather than searching 24 times for all the records with that name. I'm trying to create a formula that will find all the rows that have one or more of...

I an new to Visual Basic but cannot seem to get this code to populate the form data onto the spreadsheet. First row is fine but then wont add further data. Think that issue is in the 'RowCount' function... any help appreciated! Private Sub cmdClose_Click() Unload Me End Sub Private Sub...

Hi everyone. I need a method or function that can count the TOTAL number of pages to that will be printed. I don't need anything with HPageBreaks or Get.document(50, ""sheet name"")") for these don't seem to work on my worksheet. All they seem to do is give me a number lower then the number of...