• EmbeddedPivotChart: Drilldown-Class

    Hi Everyone Let me start off by saying I'm a complete Noob when it comes to this, so I hope my explanation makes sense... I've been trying to implement the Embedded Pivot Chart Drilldown Class as explained by Craig Hatmaker on the YouTube video :http://www.youtube.com/watch?v=-Uu2WqDxLdk Firstly,...

    BigJoe2350 pointsBadges:
  • VBA – same time stamp, different cell

    I have a macro that runs in the background to apply time stamp to the left of where I modify the cell. So column 2, 5, 8, 11, etc is where I have a dropdown for users to pick, I want the column to the left in the same row to input time stamp. Private Sub Worksheet_Change(ByVal Target As Range) On...

    SGTUjvari25 pointsBadges:
  • Macro using Visual Basic

    Using Visual Basic, I need to choose XYZ information in a cell, in Excel, and another cell must give me ABC predetermined information. How should I do that?

    JoyStrassacapa25 pointsBadges:
  • VBA to copy sent email subject and to fields

    We use a Corel X5 macro along with Outlook 2007&2010 here to send or "export" drawings from our art dept to the sales dept. The macro creates an email with the attached sketch and subject line filled in. I need to modify it to save the current sent email, subject and "TO" fields to a text file....

    swinehart68031,050 pointsBadges:
  • Showing progress bar form during QueryTables

    Hi, I'd like to add a form on my VBA Excel showing a progress bar during data downloading or during other DB process. I'm using VBA QueryTables to download from an Oracle db, PivotTableWizard to download it on a pivot table and ADODB Execute to execute stored procedures. Thanks for your help.

    webluca60 pointsBadges:
  • Adding from two tables in VBA

    Does anyone know how I can use VBA to take one value from one table and add to it a value from another table and then put that total into one field of the original table. I've been fighting with this for a couple of days so now i am looking for some help.

    Silverhawk10 pointsBadges:
  • VBA Array Loop

    Hello, Can anyone help me with VBA code that creates an array from a range of cells (A1:E1), loops through the array and performs a function. I already have the function now I need to create the array and loop. Thank you...

    ClaireJosie40 pointsBadges:
  • Selecting data to delete from column & rows

    I have a sheet that shows me supplier codes - example - these are four digit numbers like 1501 , 1524 , 1701 My problem is I only want to see data from certain suppliers. I have thousands on the sheet that runs daily, but I want to extract data from selected suppliers in column B and delete all...

    Mcgrath6910 pointsBadges:
  • Write a line in to a text file using VBA

    Hi, I want to write a line in to a existing text file. My file is divided in to a sections. There are 13 sections with headers as :  [Phase1]  ... some lines [Phase 2] ... some lines . . . . Now at the end of the each header section, I want to insert a line using VBA. Any suggestion would be...

    akashdktyagi5 pointsBadges:
  • Combobox puts selection in bookmark and triggers different text into second bookmark

    I have created a macro enabled template in Word 2010 for a form document. I need to get a combobox to return a value into a bookmark and then call different text based on the selection into a second bookmark. The comboboxes are created in VBA (Word 2010), not in the document. The document is...

    Ltrain215 pointsBadges:
  • Late Bound Listview in Access

    Not sure if this will make sense, but here goes: I have several forms built which include listview controls on them. I am currently using early binding to manipulate them, but one of my user's workstations is having an issue reading the ref lib. I'm assuming there is a program on that system that...

    McNitro255 pointsBadges:
  • VBA – Delete rows if they meet a certain criteria

    Hi, I am trying to write a code to delete rows that meet a certain criteria. I have a large amount of data in a spreasheet and all of the columns contain different metrics. I want the code to go through all of the rows and delete the rows that have a number in column H that is between - .3 and +...

    Sumcap5 pointsBadges:
  • Windows XP Word 2003 with macros takes a minute to open

    I have win xp. The problem with word 2003 usually starts occuring in couple of months of flowless operation. Then for whatever reason, word starts taking more then 1 minute to open. I know it has to do with macros, because if I remove word template files from c:Program FilesMicrosoft...

    Levinmik5 pointsBadges:
  • Passing a form to subroutine in Access 2003 (VBA)

    I have a function that recieves references to 2 forms and 2 controls. The sub looks like this Public Sub Not_In_List_Starting_Handler(vNewData as string,Not_in_list_form As Form, List_control As Control, Lookup_Form As Form, Lookup_Control As Control) when I try to call it from the form I get all...

    Nainey5 pointsBadges:
  • Order column in pivote table from vba

    I need help to make this, i try with PT4.PivotFields("Category").AutoSort xlDescending, "Ventas" but not sorting. Please helpme,          With ActiveSheet.PivotTables("PivotTable5").PivotFields("Ventas")        .Orientation = xlDataField        .Position = 1       ...

    Emoraleshn5 pointsBadges:
  • Download AS400 Physical File to Excel Using VBA

    I am in the process of developing an Access database with the intention of using it to control the download of AS/400 physical files into Excel. I am fine developing the Access / Excel side of the data, however I ahve no experience with the AS/400 side of things. The access database will contain...

    Martyjw5 pointsBadges:
  • VAB macro that iterates through all bookmarks in a word document with exception and allows user to change the value of the bookmark via input box

    A VBA macro that will work in MS Word 2003 and MS Word 2010 that will do the following:

    Astakeil35 pointsBadges:
  • VBA/VB code to edit hyperlinks in PDF files

    Hi, How do we read the content in a pdf file. I have some sample pdf where I have to edit already existing hyperlinks . Thanks in advance.

    Iamfromhyd20 pointsBadges:
  • how to create autonumber

    while press enter on cell (b1) the cell (a1)= 1 while press enter on cell (b2) the cell (a2)= 2 and so on i tried functions : =row() and =OFFSET(A2,-1,0)+1 i don't think its an autonumber because i used manualy so, hlp pls

    Army125 pointsBadges:
  • Access 2007: VB code to make a button press link to a specific record in another form

    The database is for a set of components. One of my forms shows details about each component on a separate record (the property "Default View" is Single Form). The other form is a list of all components by component number displayed all together (the property "Default View" is Continuous Forms). The...

    VinDibo5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following