• 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:
  • VBA copying a range from Excel and pasting to a text file

    Do you know how to copy from excel and paste to a text file using VBA?

    TBone555 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:
  • PDF save as TXT file (VBA)

    HI EXPERTS PLEASE SOLVE IT I WANT TO SAVE AS TXT FILE FROM PDF FILE THROUGH VBA (XLS) CODING; I WANT TO GET THE DATAs AS TEXT MODE FROM A SPECIFIC PDF FILE IN EXCEL SHEET PLEASE ANSWER IT ANANDA DEBNATH DELHI, INDIA

    AnandaDebnath280 pointsBadges:
  • Printer Orientation Control using VBA Code

    I want to print excel UserForms automatically using VBA proceedures.Some should print in Portrait and others in Landscape. How can I control the printer page orientation from VBA code?

    KingsITI50 pointsBadges:
  • “Automation Error Invalid Advise Tags” What is an advise tag?

    I have a visual basic module within Access that seems to compile fine; when I select the Debug function in the visual basic editor, I receive no errors or messages.  However, within my Access form, when I try to click the button associated with this module, I receive the error message, "Automation...

    Siggy5 pointsBadges:
  • DoCmd.OpenReport not working right with WHERE clause

    I have looked all over and seen hundreds of questions about this command, but no answers. It seems like the most basic thing you can do with combo boxes, so I'm baffled that it doesn't work. Here is my VBA Code: Option Compare Database Private Sub cboFundNumbers_AfterUpdate() Const strFormName As...

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

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following