macro 2007

Hello, after fooling around with coding for awhile I have realized that I need to get an Excel Macro book to understand all of this. I have realized that just "hitting the record button" doesnt work. you have to actually know how to code in order to get your macro to do exactly what you want...

I have a pivot chart that displays the last 3 months of data onto a bar graph (eg, Since it is currently October, the graph shows Jul-Sep data). Instead of selecting the desired months manually , I would like to create a macro that will show the desired months every time the calender month...

Hi All, I have 23 Charts on a sheet which I place into a MS Word Doc. ATM all charts have borders, which is what one of my Managers like, however another Manger likes these charts without borders. I tried to record a macro so I could have this done by VBA (excel 2007) but it did not record the...

I am using Ecel 2007. In the workbook I am having a problem with, the users need to be able to send just the one sheet to our purchaser instead of having to send the entire (and rather large) workbook. I've been using the following code Sub Email3() ' ' Email3 Macro ' ' Sheets("Quote...

Hi all, I am new to coding on excel using VB. I have created a drop-down macro by referring to many codes available online. However, my user may want to put a choice outside the options provided in the drop down. Any idea how to allow for user input? Would really appreciate some help.

Hi Team, I have one macro I want to integrate as add-in file because I can't use this code every time into master file because everyday I download file from my database and need to copy my code into that file and then need to run the macro. Please suggest me how can I make use my macro in...

I have problem in making this. format in a text file Note: The text is only on A1, separated by a delimiter indicator which is "^" https://docs.google.com/file/d/0B_eArBbGfxv4OTJ2YTlDaFBnZDA/edit?usp=sharing To this . . . after text file multiple import to excel As you can see in the image...

I have a workbook containing downloaded Emails and I now need to identify a particular code appearing somewhere in the Subject field. I am using Excel 2007. The code will always be 8-numbers and should start and end with a space, unless at start or end of Subject Line (but often people put...

Hello, Very new to VBA writing but am catching on fast. Below is the link to a macro enabled spreadsheet that I have been working on. So far all that I have written works but now I am down to the last part where I essentially would like to take the names from a list and assign them to the rows...

Hello, I need some help with a problem at work. I need to create a macro (or combination of formulas) to match columns a,b, and d in sheet 1 & 2 and replace data in column c from sheet 2 with sheet 1's column c. Below is what I'm trying to do: Sheet 1 <tbody> a b c d 1 John Smith 9 123...

I want to create a Workbook which expires at a certain date and deletes itself. I'm creating a macro and using the .KILL function in the Workbook_Open procedure. However, is it possible for someone to open the Workbook and bypass running the macro in Excel 2007 ?

I'm trying to write a macro that will hide all rows where there is text in column B AND where the values in columns C through P are zero (not where the values sum to zero, but where each cell in those columns is zero). I've written a macro that will hide the rows where the values in the cells...

Hi, Can't seem to find the answer to this one. I have a workbook in EX2007 with 2 sheets. I need something that will do the following. If Sheet 1 Column A = Sheet 2 Column A AND Sheet 2 Column B > Sheet 1 Column B Then Copy Sheet 1 Column B to Sheet 2 Column B This could potentially be in...

Hello, I hope somebody can help. I have a template I need to send out to multiple users (most of whom are NOT excel savvy). One of the items they need to complete is a dropdown with 10 choices. I have the data validation set for this and defaulted to choice of "NA" which they will change to...

I am given a spreadsheet with a column of item numbers that changes each week. I need to take those item numbers and compare them to the same data in another database. I can connect to the database AS400(DB2) fine and return single rows of data. Rather than using the three options from the query...

I have an Excel 2007 spreadsheet where I need to reorder the columns. The column headings are as follows: <TABLE style="WIDTH: 530pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=700><COLGROUP><COL style="WIDTH: 53pt" span=3 width=70><COL style="WIDTH: 53pt"...

Hi Folks, I'm attempting to find the last row with data in it. The following code works EXCEPT that on the last row in column e it replaces the cell text with the row number. I can't work out why its doing it. Here is the code: lastrownumber = Range("A65536").End(xlUp).Row Before...

Hi, I am a chemical engineer, and working on a plant which generate results after an hour. It generates two excel sheets from which I convert the results in different units. Then I need to paste these values in another template I have created which combines the data from the last two excel...

I have a macro that automates the saving of a master file with a new version with today's date. Sub SaveFileAs() Dim file As String file = "ClientData_" & Format(Now, "ddmmmyy") & ".xls" ActiveWorkbook.SaveAs file End Sub If there is already an existing file I get the standard...