2010

Help! Im using Excel 2010 and want to create a macro that allows me to cut the cells A:S and U in the current active row and paste in the same locations on the next page, at the bottom of a growing list. I would like formulas to be copied also. Alternatively, cut and paste the entire row, but...

Hello Excel and VBAers, I wrote a macro that works great in 2010. A colleague needs to use it and it breaks on his 2007 workbook. I call a file that's 97-2003 format or ".xls", this works great in 2010, but when I try running the exact same macro on his 2007 excel, it breaks. It seems like it...

Hi - cant get this to work.. Firstly though I have put in the folder location as below to the desktop the workbook copy keeps only going to "my documents"?..also I want to add the date & time to the copied workbook to stop it over-riding previous copies - any ideas? Sub...

Hello, I have been searching for many hours for a VBA-code in Excel for 2010 for the following. I want to open the last saved closed Excel-file that can be found in a folder and its subfolders. It has to open just one file in the folder or in one of its subfolders. It should find and open e.g...

I have a value on one sheet that when I change it, I would like it to hide a number of columns on another sheet. This is what I have so far Private Sub Worksheet_Change(ByVal Target As Range) Dim i As Integer If Target.Address = "$C$34" Then i = Target.Value Sheets("Cost...

Hi there, I have a really bizarre problem with a macro I've written which appears to simply stop executing at a certain point in the code. I am using a 64-bit install of Excel (part of Office Pro Plus edition). This is the code I've written: Sub prepBudget2013forFDM() Debug.Print...

Hello all Excel users! I'm gonna start by apologizing for my poor explanation, if anything is unclear, please let me know. I work at a hospital and I'm writing lots of patient data in excel, this process can be quite time consuming and I've been looking for a quicker solution. I'm quite new...

I have an Excel 2003 spreadsheet which communicates with an Access 2003 database, which works in Windows XP / Office 2003, and I'm trying to get it to work in Windows 7 / Office 2010. This is out in production, so ideally I'd like to make no changes to either one of these files. The problem is...

I have an Excel 2003 spreadsheet which communicates with an Access 2003 database, which works in WIndows XP / Office 2003, and I'm trying to get it to work in Windows 7 / Office 2010. This is out in production, so ideally I'd like to make no changes to either one of these files. The problems...

Hi everyone I would like to seek your help in doing a macro. I have four sheets: The first one is a list of all members and their score. Sheet 2 is populated as users fill a optin form on our website. They'll be registering for a free gift which will be sent to them on scoring more than 100...

Using Excel 2010 I want to set the connection of a ListObjects.QueryTable to and ADO source. Under MSDN's info on QueryTable.Connection property they say that "Alternatively, you may choose to access a data source directly by using the Microsoft ActiveX Data objects (ADO) library Instead" of...

Hi all, i can´t get this code to work correctly in Excel 2010. It is used to make simple organization charts, by pasting a Autoshape circle and connecting it with a line to another circle, this works fine. The macro can also be used to remove the circle and line again by using the same...

In Microsoft's infinite wisdom of fixing something that wasn't broken, I no longer know how to add multiple groups of Option Buttons (Radio buttons) easily. In 2003: I would add an Option button, remove the stupid "Option Button 1" text caption, and copy/paste however many buttons I would...

Hopefully this isn't too difficult to explain what I'm looking to do. Pretty Much I am making an interface to deal with all the databasing of my construction jobs. This interface is on a separate Sheet from the database. My Goal is to create User Forms that will fill the relative database...

I'm reading the contexture web site regarding dynamic named ranges, and it refers to : insert | name | define , problem is this is for 2007, I have 2010 and I can't seem to locate similar options / commands, any suggestions where I can find these or guidance on how to in 2010

I'm using Excel 2010. I'm also a first-time poster on this forum, so I may amend or post clarification, later, if needed. And I welcome comments on forum protocol or requirements. I use VBA code extensively in the application. There is a "trigger" (on the down arrow of the Combo) to a...

I have several spreadsheets that import DB2 records that include a time column (hh:mm:ss). The spreadsheets work in Excel 2003 & 2007. In Excel 2010, the time entries appear valid on the MS Query page. They are all 00:00:00 when brought over to the Excel page. The column gets automatically...

greetings, i just finished working on a custom toolbar within a workbook for excel 2010. however, when i tried to add multiple buttons and open the file, i got an error message saying: "Multiple custom UI parts were found in the file. Only one part is expected." Is there any way to fix...

I just wanted to pass along that the version of Excel 2010 on my new Macbook pro has Visual Basic available.

Hello I've searched all over to and tried everything to get my code to filter a range of cells based on an input into a text box. I want the range to filter on every keystroke in the box and also want there to be a wildcard before and after the text box text. I can get the code to work fine if...