2007

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

When I mouseover a cell in a 2007 pivot table, it shows up some handy details about the cell. How do I dump those Row and Column variables into VBA strings? (Is there an easy way or do I have to extract each element piecemeal?) For the purpose of clarity, the last 3 columns are not part of...

Hi I have a folder called \\data\ underneath it I have 30+ directories each containing 300+ word documents. \\data\TestGroup01\ \\data\TestGroup02\ ... \\data\TestGroup31\ I need to place an excel spreadsheet in \\data\ It should contain a macro that loops through \\data\TestGroupXX\ For...

Hello. I have not been able to figure out a way to set up a second chart which is linked to the same pivot table, without it being the same exact chart. I work in Excel 2007. Here is a link to the document. https://docs.google.com/open?id=0B8rs9OQkod0qTmF5cU85QnZMV2c I want to make two...

I've created a web service that generates a dynamic Excel file that has charts and images, and converts it to pdf using ExportAsFixedFormat. I've managed to get it working perfectly on my development machine. Installed is Excel 2007 (v12.0.6661.5000) SP3 MSO (12.0.6607.1000) on Windows 7 Pro...

Hi, I have a datasource with some 140,000 rows in Access. In Excel I have a total of 17 pivot tables, all using the same connection, to run multiple analyses on the dataset. If I update the connection in Excel 2010 (with Access 2010), the update runs once and takes 8 seconds - so far so good...

Hi, I run a macro everyday and have been using 2003 until just recently. Our office has switched over to 2007 and now the macro is erroring out. I have tried a few things but nothing seems to work. I'm receiving a "Run-time-error' -2147417848 (80010108)' Method 'Sort' of object 'Range'...

Hi all, New poster here, and I was hoping to get some help with a macro for Excel 2007. I have a working understanding of programming in Java and C++, but teaching myself how to write macros in Excel is apparently beyond me. I want to write a macro that would be able to 1. Take the contents...

Hello All, Using Excel 2007 I've come accross this issue. I've got many (10+) conditional formats on a certain range. As the range changes occasionally I need to update each condition manual. I thought to make things easier by creating a named range for this, and use that in the CF. But...

Hi, I made a formula that works: =SUMPRODUCT(Answer!U2:U65535,Answer!AD2:AD65535)/SUM(Answer!AD2:AD65535) however, I need to update it for multiple conditions and I'm having some trouble with the specifics. Referencing sheet "Answer", I want to perform the same calculation as above but for the...

Dear all, I have a question. Please see below image. I have the Item names in D drive folder named Images. Over 27000 Images are in there. I want when I write the image name in cells (B2 to B2000), Images should appear itself in front of them in (A2 to A2000). Please help. All Images are in...

Hello I have a workbook (excel 2007) and would like to make sure that users need to enter a password when they open the file to be able to edit certain cells. Currently without a macro, if someone has the password, they can unlock the cells and edit the document, but if they forget to...

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

Hello XL2007 I think the best way to explain what I'm trying to achieve is with an explanation... I'd like to, with the following data; Apple - Good Apple - Good Banana - Bad Banana - Bad Banana - Bad Banana - Bad Orange - Good Carrot - Good Carrot - Good Carrot - Good Carrot - Good Carrot -...

I have a very unique situation here... I have a utility at work that generates a spreadsheet. It is an excel 2003 spreadsheet, which is "Book1" and unsaved. The user needs to run my code to grab some data from this spreadsheet and not have to save the excel 2003 workbook to their machine...

Hello I will be emailing excel docs to different people who may or may not have the same color palettes as I do. I want them to see the doc in the same colors as I do but I don't want them to have to do any work to make that happen. Is there a way to email the color palette with the doc and the...

Hi all, Need some help with this code, few problems i did have are that it use to get to the point where it asked for permission to send, you would click yes and it would look like it had sent but then wouldnt have sent (nothing in sent items) new problem is that it does not seem to work in...

Hi guys Excel 2007, able to use VBA within this document. Excel WorkbookABCDEFGHIJ1Logged Time2TM NameChordiant ID11/11/201112/11/201113/11/201114/11/201115/11/201116/11/201117/11/2011Total3Name 1id1123456784Name 2id2123456785Name 1id3123456786Name 2id4123456787Name 1id5123456788Name...

Some users still have 2003 loaded and don't want to upgrade. I tried having them open the .xlsx file, it converts fine, but opens as read only to "protect the original document". They can't save anything. Is there any fix short of giving them only .xls files ? Mike

Hello, First, thank you for reading my question and offering any help! I would like to have a button that shows/hides a particular field in the row section of my pivot table. For example, say I have a small PT with State, County, City, Population. I might just want the row State to just see...