2007

Working in Excel 2007 I am trying to determine how to write a formula for a scenarios when a date is greater than (1/1/2013) another date in same row, but a different cell. So for example if date in Column C is occours(ed) before date in Column B then I want to enter a zero in Column D to...

I am trying to get a calendar control to work on a UserForm, but I can't even find it under other controls. I am using excel 2007 and Windows 7. I have tried using the MSCAL.OSX file, but can't seem to get that to work either. I am open to suggestions about what is the best way to go as far as...

I have searched the forum for a couple of days and have not quite found an answer to this question or maybe I did and didn't understand it (I am a ultra noob), but I am looking to write code to filter out rows that contain certain words in them. The code I am using is ActiveSheet.Range("$A$1"...

I am using Excel 2007 / Windows 7 Home Premium / PC not a MAC I have a tab where I use a pull down to select from a list (there are 80 of them) and based on the resulting position in the database, it pulls data from various locations (using index) to display the info. It works for ALL of...

hey all, I am going to be linking some excel tables to word. I am using Office 2007. The issue is there is a high likelihood that my tables will be changing and I do not want to have to relink all of them from excel again. Any ideas on how I can link excel to word and if there's a change in...

I need to create a list of mail held in a MS Outlook 2007 Inbox plus any subfolders and store it in an MS Excel 2007 workbook. Straight row for each mail with columns showing data relating to the mail - to from cc subject attachments (Y/N) attachments name sent date/time replied date/time etc...

I created a data validation formula for an Excel 2010 workbook that would only display client names who were assigned to the manager that they selected. The formula works fine in Excel 2010. However, when I open the same workbook in Excel 2007, the data validation type is reset to "Any value"...

I know that a cell has to be in the text format to be able to subscript the value. Here is my issue: I have an excel workbook that sheet 1 pulls a value from sheet 2. The value in sheet 1 needs to have a subscript $ sign on it. If I make it a text format the only thing that shows up is the...

Hi everyone, I'd like to explain what this table needs to provide. We have the monthly revenues by product, but the billing time for that revenue is a number of months away. How many months, depends on the product. So, what I need is for example move January revenue of Product A (let's...

I have a workbook (excel 2007) that has many worksheets in it. I print different variations of them (usually to PDF). Is there a script that works off a sheet where I can tell it what worksheets to print together and what to call it. Thanks for all your help in the past and going foward. JV

I found this code on the below website and I am getting a syntax error.Any idea? Saving Excel Worksheets as PDFs Using MacrosSub RDB_Worksheet_Or_Worksheets_To_PDF() Dim FileName As String If ActiveWindow.SelectedSheets.Count > 1 Then MsgBox "There is more than one sheet...

I have a macro that duplicates a template several times. I turn off calculations and when I'm about 100 of 800 worksheets in it gets VERY slow. Any advice? Anything I can do? Thanks, John

So I have a macro button in my worksheet that sends a specific range of cells as an email, I also have another button that resets the fields of those cells when the email has been sent. I was wondering if there’s a way I could combine those two functions to just one button. So in essence, I want...

How do I make columns auto expand without having to double click the column? JV

Hello, I have a 3D Pie Chart with 6 slices and one of the slices, when rotating, appears below/behind the others at a specific degree of rotation (usually when it is in the front). The Pie Chart is linked via a drop down menu which consists of 60 cities to reset the chart's data. This issue...

Good morning, I have created a form with serveral userforms. Essentially it performs a costing calculation then gives the user the option to log the results in a table on the same page, looking for the next available empty row. Nothing in the code asks to save or close the workbook at any...

Hello, Can anyone recommend a previous post/thread to help me get started creating the code for the following scenario: -Email a specific 'report' from an Access Database to multiple users as a PDF file Thanks, Haffy311

Hi Experts. This could be standard functionality that I'm missing rather than VBA or some wonderful macro and therefore I apologise in advance if I've missed something. I have a worksheet... In row 1 I have my column headers. In row 1 I have column filters. The standard ones in Excel 2007...

I recently migrated from Excel 2003 to 2007... what a difference! I felt that I was a power user in 2003, and like a newbie in 2007 -- it will definitely take some getting used to. In 2003 I used the Customize option to create menu buttons to run macros. The macros are called by pressing the...

I got this VB script last time here. And it works great in 2003. But now we have 2007 and it does not work can you help me. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$3" And Target.Value = "HideDues" Then ActiveSheet.Unprotect ("cover")...