in
All Tags » VBA » Excel 2007 (RSS)

Browse by Tags

  • More Efficient way to Copy and Paste Filtered Data

    The below code is desgiend to copy and paste a data set, while skipping blanks based on the filtered selection ("7"). This method WORKS but it takes a long time as more criteria is selected. Is there a modification that can be done to the code to create a more efficient method to copy and paste...
    Posted to Microsoft Office (Forum) by microsoft on 05-25-2010

  • How does user of my template DELETE the code modules?

    Hello Experts: I have an Excel template (.xlt) file with VBA code, and one user is somehow managing to delete the VBA code modules despite the fact that I have: - a file password for "modify" - a password protecting the code in VB When I try to duplicate this, I can't get the same results...
    Posted to Visual Interdev (Forum) by microsoft on 05-16-2010

  • Excel 2007 VBA charts ScaleType and MinimumScale causing error

    I've come across another error in converting VBA code for charts between Excel 2003 and 2007. The code below worked in 2003 (I've cut down the first routine so that I just show you how the FormatAxes routine is called). It falls over for the category axis on the line: If a(-i + 1).MinimumScale...
    Posted to Excel (Forum) by microsoft on 05-07-2010

  • Excel 1-2 digit to 4 digit date macro

    I have a spreadsheet exported from another program and the date column is outputted as 1 or 2 digit depending on year (e.g 1999 = 99 or 2007= 7). I have modified a simple formula to correct the date but I would rather have it as a macro that as non-technical people will be using this. Formula is: =IF...
    Posted to Visual Interdev (Forum) by microsoft on 05-04-2010

  • Search and retrieve data from Pivot Table using VBA

    Hello, I would like to search a pivot table and retrieve information from the table using a VBA macro. The attached file shows the layout of the pivot table. As an example, I'd like to search the date column for 1/31/2009 then retrieve the Bicycle value in column B = 1,632. Thanks, Ron
    Posted to Visual Interdev (Forum) by microsoft on 04-26-2010

  • Copying Charts from Excel 2007 to PPT 2007 - How to bring in Entire WorkbookCode?

    Hi, Experts: I've got a VBA macro that cuts a chart from Excel 2007 and pastes it into an active PowerPoint 2007 slide. It's working fine, except I want my code to replicate the behavior you get when you manually Paste, then choose Paste Options and select "Excel Chart (entire workbook)...
    Posted to Powerpoint (Forum) by microsoft on 04-25-2010

  • Why is my excel macro so slow?

    I am just getting into vba scripting in Excel 2007, and I'm just mucking around to see if its useful. So I created this basic script for filling a bunch of cells with values. And at the same time it loops through each worksheet. I have approx 10 worksheets in the excel document. The script runs takes...
    Posted to Excel (Forum) by microsoft on 04-25-2010

  • Delet objects on All relevant sheets

    The code below goes to each tab in a workbook and deletes the objects (specifically bipmaps). Currently, I have to assign each sheet I want it to delete. Can the code be adjusted to loop and go to all sheets with the word "sheet" in the TABNAME and delete? Currently, I may have to add tab names...
    Posted to Visual Interdev (Forum) by microsoft on 04-23-2010

  • Excel 2007 & VBA: Need to select and delete columns based on header

    I have a data set with redundant columns. I want to search though row 1 and all columns which have data in them and select and delete columns based on what is in the first cell (i.e. the column header)
    Posted to Excel (Forum) by microsoft on 04-05-2010

  • Open PDF file and goto a specific page

    Hello From VBA in Excel 2007 I want to open a pdf file in Adobe Reader (outside Excel). That work ok. But when I try to use parameter to specify a page number, zoom etc. it does not do what I expect. From shell the following work successful: AcroRd32.exe /A "page=2,zoom=100" "C:\Tmp\manual...
    Posted to Other (Forum) by microsoft on 03-13-2010
Page 1 of 4 (40 items) 1 2 3 4 Next >