• Import MS Word document to Window’s Journal .jnt file from within Word VBA

    Windows Journal can import a MS Word file. It imports as an image that can then be written on top of with ink. Does anyone know if I can import the Word document into Windows Journal automatically from VBA code in the Word document? Or is there a way to create the .jnt file in MS Word that can then...

    thenelson5 pointsBadges:
  • Claculate slope & Intercept from line drawn in chart (Excel)

    Is there a way to compute the slope & intercept of a line (object) drawn on a chart in Excel using VBA? I have an X-Y chart with data and I want to have the flexibility of drawing my own "best-fit" line through the data. Thanks, Frank

    falfra10 pointsBadges:
  • Drop down menu’s in PDFs saved from Excel files

    Is there any straightforward way to save an Excel file as a PDF while retaining the functionality of the drop down menus? I have a few drop downs that I've added to an excel file and I want to save this file as a PDF to the point that I can open the PDF and change the drop down menus. Can this be...

    Duester5 pointsBadges:
  • 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:

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