Excel Macros

Run a Macro in Excel 2007 spreadsheet located on a file server

When I run the macro located on the local drive it works, but when I put the document out on a shared file server I get an error. The server folder is in my trusted locations.

email macro

create amacro to send an email with Excelattachment

Macro to Open Crystal Reports

I have an excel spreadsheet that I've used to create a crystal report. The excel file has multiple employee id's on it. The crystal report has a parameter that uses the employee id to only show that employee's information. I'm trying to set up a macro to loop through the employee ID column, pass...

Macro to breakout data into separate tabs

I have a weekly report that holds line item detail for seven different account numbers. The data is going to vary from week to week and I need vba code that will separate the data by account number into different tabs. Any tips on how to write the code? RWC

vba recorder issue

When I run excel 2007 and try to record a macro, it will not record any commands for inserting a wordart or editting the text of the wordart if one is already created on the spreadsheet. I am at a loss to determine the right commands without the recorder, and I can't figure out why it will record...

Horizontal to vertical

how do you change a horizontal excel 2003 spreadsheet with qty breaks to a vertical speadsheet with quantitiy break or is there a marco

What is the Excel VBScript for the following...

Avatar I put a value in cell B1 and a value in cell C1. Then, when I put a value in A1, I need both B1 and C1 to over-write themselves and become the product of A1*B1 and A1*C1. The same for A2,B2,C2 and A3,B3,C3, etc

How to Create "Are you sure you want to ...." MsgBox

I am creating a userform at the bottom of which there are various commands including "Save". When you click on this I ahve written in a series of checks to make sure that all the fields are filled in correctly but after that I want an "Are you sure you want to save" box with the options Yes and...

how to assign a numerical value to a word in excel

I want to be able to select a material from a drop down list in column A, then type in the time in Column B and in a third column have the cost appear. What I need is to associate eg. VHS as having a rate card of £30. I can make lists and I can write the simple equation in the cost column to...

VB Active Cell problem

I am a vb problem. On an excel sheet, I am trying to have a macro run when the user selects a changing column's active cell. For columns F to I on Sheet!Data, if you choose any cell in range (F9:I65000), then take the value of Column B in the selected row and make as my "Dept" Value. Can...

UNC alternative

I have many excel worksheets that link to other worksheets. Some link by drive letter mappings and others have a UNC name. Is there a way to link without using the UNC name? Concern is what to do if the linked server is changed. Do we have to go through each spreadsheet and change the link? Or...

excel table to text flat

Hello, I am not an IT expert to start with! I have a series of tables in excel made of 3 dimensions. Two dimensions are vertical (indicator and country), one is horizontal (years). The different tables contain data for a variable number of years and for a variable number of countries and...

Excel macros - code does not execute

I have written the following macro. I do not really see it necessary to explain ehat it does, I only need help with a problem - for some reason it does not reach the code after the loop. It does everything exactly as I want it until and into the loop, but does not execute the code after the loop at...

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

Help with a macro for linking a data entry form spreadsheet to the results spreadsheet

I am entering seminar selection data for 600 students and i have a spreadsheet with names and id numbers. there are 20 seminars that they may attend and they have "ranked" them 1-20. I would i have a data entry sheet with a VLOOKUP that will find the student (on the second sheet) and display the...

Linking a checkbox to another checkbox - Excel 2003

In Excel 2003, I have a spreadsheet with multiple sheets (including a detailed page and summary page). Each sheet has about 20 subjects that contain YES / NO / N/A answer checkboxes. I need to be able to link corresponding summary and detailed checkbox's with each other. EXP: When you check the...

How to send a mail to multiple recipients from Microsoft Excel sheet?

I have an excel sheet . This excel sheet has data for many receipnts. every row has an email address(lotus/outlook) and then the next four cell in the saem row has the data for the same recipant. I want a macro to be created so that when i run this marco a new mail is drafted for each receipant...

Macros in a drop down list

How can I get macros into a data validation list so I can select a macro to run from that list.

Excel Macro to password protect

I have this spread sheet that I want to be able to protect from distrubution when given to one person. Is there a way of writing in a macro that will ask for a new password that is in a hidden list at the end of say 30 days and if not entered in the program will not be usable? I hope that my...

Microsoft Excel - I need to find rows that match a user entered entries and sum results of column b

I have a spread sheet that looks like this Project Well Hours Lewis 1 12 Lewis 2 3 Lewis 1 9 I want to find all the rows that match a user inputed name (in this case 'Lewis'), then add the numbers in column c labeled 'hours', if the sum equals 24 then no problem,...