vba 2010

Hi, I come with a question involving excel VBA since I am no longer sure how I should proceed with this on Excel 2010. Right now I have : 1. a summary table that is summed from 2 different single cell columns 2. they come from different month worksheet (12 in total) 3. currently, there are...

Hello Everyone, I'm trying to write a module that selects a data range for my chart worksheet and changes the title, subtitle, a textbox, and axis labels dependant on button clicks. I have sub routines that select which named range to use based on button clicks and set some of my global...

Hello to You All, I want to write a code in VBA from Excel (part of the Office 2010 version). I will make a short describe to my problem: - In a column (eg: column "C") I have a different values (eg 30 values); - I want to multiple select (eg. from 5 to 5 values of cells corresponding) and...

Greetings! I have inherited a rather monsterous project in the form of an inventory database that is bumping into its storage ceiling due to some 3000+ images which are attached to the item entries. My task is to update the database so that it can continue to be used without archiving older...

I am trying to replace the the string "VALUE=" with "VALUE= (Excel cell data)" where it first appears after a certain position within a text file (this certain position being "SOURCE"). The issue I'm having is that when I specify the start position within the REPLACE function, the newly saved...

I'm sorry if there is a thread like this, but I have looked at a lot of thread and none of them have worked for me. I have two columns. the first column has names and the second column has information separated by a line break (Alt + Enter). It would look something like this: A1= Joe...

I hope someone can provide me with some help. I realize there are many variations on this question, but I am not finding an answer that suits my needs. My expertise with VBA is basically restricted to finding code in posts that does what I need. I am definitely a beginner when it comes to code...

Hi all, I am extremely new to VBA and have never posted before, as I have been able to get everything I needed from others' questions.However, I have come up with an issue that I have been unable to solve. Sorry if it has already been answered in another thread and I was unable to find it...

Hi! I need a macro to open a workbook (TimeSerierData.xlsm) and copy the data in the workbook into an array and then sum data by month and then put the result in another workbook called MonthSerierData.xlsm. here the data in TimeSerierData.xlsm Time Value 2013.01.01...

I am using Excel 2010 and would like to have the following code to protect and unprotect all worksheets in a command button with a password which is only required to unprotect the sheets. However, I am a novice and the code doesn't seem to work. Would you take a look at it? Private Sub...

I have two excel 2010 files that I want to run this on. Each one has about 10+ worksheets in them. I am looking to have a vba script that will look at columns D and E starting at row 4 and check if they are expiring in the next month or have already expired (before today's date). Then it would...

I found this code on a spreadsheet at work (a board displayed on a big screen which is on 24/7). Can't get an answer from the owner regarding what exactly it does. It suposedly saves the workbook (amongst other actions) by calling the "UpdateData" Sub at a determined time. I find the first...

Hey all, I think this should be pretty straight forward, but I'm struggling a little. (I'm still learning VBA.) I'm trying to protect a workbook, but leave a few ranges available for co-workers to edit. I have the ranges set up so I can go to: Review Ribbon: Changes Group: Allow Users to...

Hi all, I was wondering if someone knows how to do the following, or can refer to an implementation of such a thing. I have an excel file with many sheets and charts scattered in the various sheets. I'd like to export all charts to a folder as image files. I'd like the file names to be...

Hi to all. After searching for several days to find an answer I would like to post a question in this forum. I am searching to find the way to find a file based on characters in the filename. For example: In active workbook cel C6 I would manually fill in the name of the file I am looking for ...

I've searched on this and can't seem to find what I need. I've been working with an old script I found here that doesn't play well with 2010 and copies all the sheets in the current workbook. I'm looking for VBA code (Excel 2010) to copy all the data from my active sheet (it will always be...

Still learning vba, I have code to copy specific cells from one worksheet to another, currently coded for a specific worksheet. Need to have the code loop through all of the worksheets (to be named by users) that are not labeled Summary or Template. Could someone please, please help. Here is...

I'm a complete novice to VBA and Excel. I have a piece of VBA. I got this code from this forum. This VBA code records the date-time when when another cell has changed. OK, I get the code pasted into the code editor and saved the file. The data I change (e.g. manually is in A2) B2 should...

Hi all, been on here before and got some wonderful help. I'm working on a program that is used for invoicing and quoting and it's brill. I would now like to add a button that will run a macro that takes the workbooks current filename, converts it into a PDF and sets up an email with a subject...

Please help. I am trying to add a row to the last row in a named range, I have found the following code: Sub newRow() Dim target As Range Dim cell As Range Dim rowNr As Integer Set target = Range("FDrivers") If line <> -1 Then rowNr = line Else rowNr =...