IF and then statement in query
I’m having issues with an if statement in a query. Basically I need to know how to get the following: If field 1 is > 0% then field 2 = 25. I don’t know VBA

Answer Question   |  May 15, 2013  6:03 PM
Microsoft Access 2007, VBA

Find and replace text in PPT
I have a project to find and replace words in PowerPoint from Excel and then save the PowerPoint. My code is working fine. But when PPT has mp3 then it giving errors. Please see the code and tell me what change I should do. Sub pptopen()Dim a AsIntegerFor a =2To4Dim pptApp As PowerPoint.Application Dim pptPres [...]

Answer Question   |  April 11, 2013  11:00 AM
Microsoft Excel, Microsoft PowerPoint, VBA

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

Answer Question   |  March 11, 2013  3:19 PM
Microsoft Word, VBA

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

Answer Question   |  March 4, 2013  8:13 PM
Microsoft Excel, VBA

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

Answer Question   |  February 14, 2013  11:20 PM
Microsoft Excel, PDF, VBA

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, the video was excellent and very informative, and the [...]

Answer Question   |  January 17, 2013  3:25 PM
Microsoft Excel 2010, VBA

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

Answer Question   |  October 30, 2012  9:49 PM
VBA

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?

Answer Question   |  October 23, 2012  4:28 PM
Excel 2003, Excel 2003 macros, VBA, Visual Basic

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

Answer Question   |  October 19, 2012  3:15 PM
CorelDRAW, Macros, outlook2010, outloook 2007, VBA

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.

Answer Question   |  August 31, 2012  1:51 AM
adding, tables, VBA

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…

Answer Question   |  July 20, 2012  2:18 PM
Array, FORALL loop, loop, VBA

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

Answer Question   |  July 19, 2012  9:50 PM
VBA, VBA functions

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

Answer Question   |  June 19, 2012  3:59 PM
VBA, VBA functions

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 is [...]

Answer Question   |  April 26, 2012  6:28 PM
listview, Microsoft Access 2003, VBA

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

Answer Question   |  April 5, 2012  3:19 PM
Microsoft Office VBA, VBA

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        .Function = xlSum        .NumberFormat = “#,##0″        .Caption = “Sum Of Ventas”              End With               ActiveSheet.PivotTables(PivotTable5).PivotField(“Category”) _      .AutoSort xlDescending, “Sum Of Ventas” [...]

Answer Question   |  March 28, 2012  7:15 PM
Microsoft Excel 2007, VBA

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:

Answer Question   |  February 28, 2012  11:07 AM
VBA

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 information [...]

Answer Question   |  March 17, 2012  9:55 AM
Access, AS/400, excel, VBA

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 types of errors – data mismacth, byval required, etc.. [...]

Answer Question   |  March 31, 2012  3:56 AM
Access 2003, Acess 2003 forms, VBA, Visual Basic

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 OfficeOFFICE11STARTUP problem disappears because there are no [...]

Answer Question   |  March 31, 2012  5:26 PM
VBA, VBA macro, Visual Basic, Windows XP