excel 07 vba code

I am looking to use excel 07 vba to find and replace into word and apply bullet point formatting to specified text. Here is an example of my code: Dim wrdApp As Word.Application Dim wrdDoc As Word.Document Set wrdApp = CreateObject("Word.Application") wrdApp.Visible = True Set wrdDoc =...

Hello, I'm starting out on VBA and have been looking for a solution online, but have not found what can help my question. I try to build a table with various formulas in Excel 2007 using VBA. The base data are in 2 different spreadsheets and I will build the table in a 3rd sheet of the same...

Hello, I try to build a table with various formulas in Excel 2007 using VBA. The input data are in 2 different spreadsheets and I will build the table in a 3rd sheet of the same file. In my sample case, I use about 10 rows even though later on that number will increase significantly. I give...

Hey all, I am looking to find text in word and replace it will a cell in excel. That i am able to do perfectly. However I would like to format the data into bullet points. Currently i am using a variable in word to perform the find/replace. That variable maps over as such...

Hey all, I am running into this error which is making things difficult when trying to find and replace. The error is: Run-time error '5854': String parameter too long I take it there is a character limit when using the find and replace and if there is a way around it, it would be GREAT...

Hey all, I am able to find in excel and replace a variable in word perfectly fine. A new issue i just ran into is when trying to find and replace a variable that is in either a header/footer or a text box (i.e. Title box) Here is my current code that will not find/replace variables in...

Hey all, I'm new to the forums but have found many solutions through your great forum so thanks! I am having trouble with an excel formula that hopefully someone can help me with. Here's the scenario: Sheet1 contains questions in column A and answers in column B. The location/order of these...

I need help please. I would like to create a macro that marks and "X" if the number (99,98, and 2) under lot cell f Charlee match to the number on the column 4,5, 7 in this case and after that delete the blank cell rows. and continue with next name. Please see sample below: Name Location...

Hello Guys: I need help.... a bit urgent so I will reallllyyyy appreciate a quick response. I have attached 2 files. RawData & Report. What I want a Macro which can pick up certain fields from RawData & put them in a certain format in Report & give me a simple bar graph. I want Macro to...

I have an unbelievably slow opening excel 2007 macro-enabled workbook that is only 950kb in file size. It’s got 2 worksheets, one is empty, and the other has about 1,000 records spanning 10 columns. The file also contains 3 short macros, one of them being a web data query. I’m trying to figure...

I am having a lot of difficulty trying to make this spreadsheet run as smoothly as possible. I needed to add some columns to automate much of the repetitive data entry and this caused much of the conditional formatting to not work properly. I know the formulas should be an easy fix, but i can't...

I have attached my code below, I found an example and made it fit what I needed to do. The code works but I was wondering if there is a way of simplifying it. As you can see below if it finds say 106 1/2 IRF i want it to put those four values on the same row in the specified column numbers. I...

Hi Guys, I need a code that will perform below requirements. Excel VBA Concatenate Columns from A1 to AZ1 and so on.. then it will loop untill it reaches to last row e.g A10000 to B10000 and so on.. refer to below: A1 = ABC B1 = DEF C1 = GHI A2 = 123 B2 = 456 C2 = 789 result in the other...

I am creating a spreadsheet that I need to represent every calendar day of the year. Example when A2 is selected it will show an input message of 1/1/2011 when B2 is selected it will show an input message of 1/2/2011 When C2 is selected it will show an input message of 1/3/2011 and so on and...

hiii, Anyone please help me with this...I am pretty new to Excel macros. I have two different workboooks with approx 15 columns and 50k rows in one workbook and 10columns and 1000 rows in another workbook and only 2 columns(partnumber, changelevel)are in common. So i want to pull two reports...

Hi, I need a macro which can help me split a set of data on a particular criteria. The file is actually very large with 399327 entries of which the sample data is given below. Time (milliseconds) Length of packet 0 ,,,,,,, 60 0.435 ...

I have a lot of trouble using Excel 2007 together with SQL server 2008 R2. I need to share data between two or more workbooks, and I want to do this through a SQL database (placed in SQL Server 2008 R2) on a remote server. I use VBA with ADO and SQL Server Native Client OLE DB provider as data...

Hi, i'm still REALLY novice in this field and needs your help to solve my problem. i want to create system that can search and open 1 excel file from multiple excel file.Since there are too many excel file, i create a database(using excel) which list all the excel file and sorting it by...

Hi, I have this file like: Column1 Column2 Column3 111 A11 011 111 A11 012 111 A11 013 ---------------------------- 111 B11 012 ---------------------------- --------------------------- 14213 XXX1 011 14213 XXX1...

Hello All, I'm new to the forum and haven't had a lot of time to scour the contents, so if this question has been answered before, I apologize. Background: I'm working a creating a spreadsheet as a classification system for certain documents. I realize Excel is not the most elegant solution...