vba 2007

Good Afternoon, I'm still new to VBA, so bear with me as I try and explain my problem... I am using a VBA in Word to pull information from an Excel file to populate my document. The Excel file is the result of a process that I have no control over and don't have the ability to change but a few...

Hi, I am new to excel, so please bare with me as I try to explain my problem =) I made a userform where the user adds in their Name, ID Number, and Age. Those data are then saved into a table, named Table1, with three columns (Name, ID, Age) in a spreadsheet which I called Data Sheet. So...

I am writing a VBA function that will search for a value in a column(say column B) in a table. This column can have duplicates. So my search needs to get all the records that match the value (including duplicates) and from these records i need to return only one value among records fetched that...

Hi guys, I have a sheet with following data: <colgroup><col><col></colgroup><tbody> <colgroup><col><col></colgroup><tbody> Item name Sheet Subject 1 1 Subject 2 2 Subject 3 3 Subject 4 4 Subject 5 1,2,3 Subject 6 1,4 Subject 7 4 Subject 8 1,3,4 Subject 9 2,3 Subject 10 3...

I have an Access Data base with a given form that creates a new recorded with the Prime Key called (MDR#). I want to add a command button to the bottom of the form so when they click on it, it will create a folder in a given location (On the network) with the folder labeled with the "MDR# (MDR#...

Hi Gurus, May I ask if is it possible to search in a two dimensional array in memory in MS Excel 2007? What I mean is that my array table values were searched cells which are scattered in the Excel sheet (just one worksheet). Or I need to print the array table then VLOOKUP on it? To elaborate...

Hello there, I have the following code written up in a userform: Private Sub UserForm_Initialize() Const MasterData As String = "MASTER Data.xlsx" Dim AsNames As Variant Dim Counter As Long 'CHECK IF FILE IS ALREADY OPEN OR NOT, IsFileOpen is Function that returns True or False If Not...

Hi VBA Gurus, First of all, great website! It really helps newbie Excel-VBA users like me. I am currently using MS Excel 2007. Is there a way in VBA to automatically insert missing columns based on a defined series or range of values? For example, we have a report that displays columns of...

I am using VBA 2007 and making a form to use for a database. The information I am putting into the database is from a survey and many questions have check boxed answers. I have made a working code that inputs the data accurately, but I am wondering if there is a way to change the output which is...

Hi Everyone, I'm very new to VBA usage of excel. I would like to make a form that uses text boxes, combo boxes, drop down lists and check boxes. I would like this information to then populate a spreadsheet using a command button. Can anyone help push me in the right direction in how to do...

Hi guys, Hopefully this is a quick answer. I have a range of values in column I starting from I2. I usually select all on this column, right click, select Properties, and apply a Custom format of dd:hh:mm Is there any way i can create a small piece of VBA to add to my existing code. For...

Hi guys, I think this is a fairly simple issue, or so i hope. Column D of my spreadsheet, contains between 400-500+ records in format: dd\/mm\/yyyy hh\:mm What i would like to do is write a piece of VBA code that loops through the values in Column D, and add a specified amount of time to it...

Hi Guys, I am trying to select multiple pivotitems in an OLAP cube pivot based on a dynamic list. The code is below. when I run the macro and loop is completed, one the last item on the list is selected. I want all the items on the list to be visible. Was wondering if anyone can please fix the...

I'm using the following VBA code in excel 2007 to change the font color & bold when a word occurs within a range (rng). The range is column "L" over 618 rows. On its own it works great! it finds the word in each occurrence within range & changes the properties. Sub Bold_Stone() Dim rng As...

I try to conditionally select rows from 3 groups. I have a table that can be divided in 3 groups (defined by 3 values of column B) as shown in attachment. I would need to find out the following: if group 1 (value '1G') appears, then if group 2 (value '3G') appears within 10 minutes, and then...

Hi guys, I have developed a piece of code that exports my entire worksheet to a .txt file. Rather than exporting the entire sheet, all i am looking to achieve is export Column A, B and J. Here's my current code: Sub csvfile() Dim fs As Object, a As Object, i As Integer, s As String...

I have the code below on a worksheet to modify a form based if it's a Purchase order or not. It works but it seems like it could be much shorter. I tried several different ways to write it but I can't get it to work any other way. I was hoping someone could tell me if there is a better way to...

Hi, I have an Excel table with different dates, times, etc. This table can be divided into 3 ranges or arrays, based on column 'C'. 'A' --- 'B' --- 'C' date - time - 1 date - time - 1 date - time - 2 date - time - 3 date - time - 3 date - time - 3 etc. I'd like to know how in <acronym...

Hi, I have an Excel table with different dates, times, etc. This table can be divided into 3 ranges or arrays, where I compare between the 3 on a time dimension. 'A' --- 'B' --- 'C' date - time - range 1 date - time - range 1 date - time - range 2 date - time - range 3 date - time - range...

Hello, I receive an error code 'compile error' on 'Sum' for the following code: d=5 (line 311) Range("M" & d + 1) = Sum("M2:M" & d) '** Test: this sum must be zero ; Compile error: sub or function not defined (Sum) (line 422) This seems to be standard code? The definition of 'd' is made...