excel 2007

I have a macro that pulls in a tab called "Registration Form" from multiple other files and dumps it into my working file. I also have a "Control Panel" and "Master" tab in my working file. As a result, the tab names in my worksheet are as follows: Control Panel Master Registration Form...

I have an Excel-macro which alters a file, saves it and opens a word file, containing a Mail merge, based on the just saved file. But if I run it, it just opens the file, not making the connection. Anyone who can help me with this? I'd like to open it From Excel, so that the user input is...

I am using this code in a very large vb project, but I isolated the problem area: Sub Test() Dim CondCount1 As Integer Dim CondCount2 As Integer Dim vCondCount As String Dim AssignCount As Integer CondCount1 = 26 CondCount2 = 30 For i = 1 To Worksheets.Count -...

Hello, I need to refresh (i.e. in this case: use the SourceName again) row headers in pivot tables with vba. I found code (probably written with a former version af Excel): Public Sub piv_kor() Dim wS As Worksheet Dim pT As PivotTable Dim pF As PivotField Dim pI As PivotItem For Each wS In...

I am using the following code to insert an Event Handler into a specific sheet. I am getting inconsistent results in what sheet actually get the code inserted. The sheet I am placing the event handler onto is added to the sheet by the code. The new sheets name is Always Sheet1 and the code name...

Hi, I am new in forum and I need help :) I have a word document (word 2007), with tables. I want to fill tables, using data from excel workbook (excel 2007). There will be 20 tables with 15 rows each approximately. In every row I want to add and combobox (activeX), where user can choose an mark...

I have a spreadsheet with column headers of Skills and row headers of Employees. Where an employee is trained on a given skill, the cell has the training date. All this data is exported from Access. This spreadsheet just needs the fact that they were trained in a given skill, not the training...

Hi, I have a range say A1:A100 that is populated with Client Names. I would like to use Advance Filter to copy unique values of Client Names to another Range ... say G1 and in another case H1. This is the criteria I have been testing for a while with no success: in Range B2, my criteria...

Hi, I tried to use this code in VBA if ClName.Formula = Evaluate("=if(iserror(find("ccs",ClName)),0,1) "=" 1 then I know it is not correct, but here is what I am hoping to achieve. I would like to check the variable ClName to see if it has an extension of "ccs". For example the clients...

Hi I just had Windows 7 installed (by a specialist) and I then installed Office (2007), Outlook, Firefox and a few other programs. Windows installed loads of update (I suspect this is where problems originates). I have set TRUST Center to allow Macros, Active X etc but Excel doesn't allow my...

I have a SAP Business Objects Web 7.5 Add-in in Excel 2007. The add in itself is made up of a compiled .xll file (CtExcelLinksWeb.xll) and a number of dll's. A bit of vba shows the xll is registered, and all of its registered functions. However, when I try to use one of these functions in VBA...

How would one utilize a Pivot Table to return the number of occurrences of a feature in a worksheet or collection of data throughout the whole number of cells in the worksheet?

I'm trying to show deadline dates which are the 3rd working day of the month. I'm using =Workday(start date, number of offset days, Holidays). The Holidays element is not causing the issue (I get the same issue if I have Holidays or not) so it's not that. The examples I'll show, therefore, do...

I developed a macro with Excel 2013 which includes ActiveX comboboxes that execute some code. When I open that file with Excel 2007 and click on the ActiveX controls the code is not executed, nothing happens. This has nothing to do with the December 2014 upgrade which I have not installed. I...

Hi Experts, I need your help. I am actually converting addresses into GPS coordinates "Longtitudes and Lattitudes". I am using a website where input around 200 addresses and they provide output in a csv. You can see the image below. The formating is little bad. All the data is good but they are...

Hi, I am trying to copy a form button from one excel sheet to another sheet while keeping everything intact including position of the button and macros associated to the button. **This NEEDS to work in Excel 2007** my current code copies an entire sheet over to a new sheet including the...

Hope you can help a first time poster (self taught at Excel). I am working in Excel 2007 and have data in 2 columns (approx. 70000 rows) which contains details of 500 current & historical: Employee No., Role, Name & Office I have cleansed, trimmed and matched so I know which rows do not match...

How can I exclude cells having value less than 29 from array(column) which have values between 0 to 100. I have to calculate percentile from renaming values. <tbody> Total 38 51 72 59 45 77 40 76 82 71 68 29 50 0 53 54 52 20 65 </tbody> <tbody>...

Hello Since I work with a lot of data files that involve names and addresses of local businesses, I find a lot of duplicates in the names, addresses, emails etc. "Remove Duplicates" doesn't help as it removes all occurrences of a duplicate value, including the first one. I ideally need...

Hello How can I flip the content of a cell in Excel 2007 For example:- I want to have Trim Motors : Electrical System : Honda Outboard as Honda Outboard : Electrical System : Trim Motors I have thousands of cells with data in this order that I need to reverse/ flip. Please advise Thanks a lot