excel 07 vba code

I am new to Excel VBA (using Excel 2007) and have been asked to create a macro to re-order a spreadsheet so that it will load into a new software package. The workbook is a download from our website cart which shows a list of all our orders. Here is a snapshot of the workbook (the workbook is...

I have 2 workbooks. One is a Work Order that I have programmed several user forms to populate different sheets. This document is set up using named ranges to make my coding easier for people to understand in my company. The second is a Custom Panel Log (Database in excel) that we use to track...

Hello, I have about 4 steps to execute with Excel files and I have 4 separate vba macros created for this. I'm wondering if I can create a vba macro that would execute those 4 macros consecutively? Thank you for your advice.

Hello everyone! this is my first post and was reffered here by friends! I am currently working on a project that requires me to export information from MS Project and copy it into excel. The biggest problem im getting is that the files in MS project are located on a server protected with a...

Hello everyone! this is my first post and was reffered here by friends! I am currently working on a project that requires me to export information from MS Project and copy it into excel. The biggest problem im getting is that the files in MS project are located on a server protected with a...

Hello, I have been looking on internet for a solution to this common error message, but have not found it. I open a file, and in the code activate that file before closing it. I give you the code below with the line where I get the error message. Select Case nStage...

Hi All, Need assistance and/or help from the team on one of my work. In a workbook dealing with huge data every day. In one of the columns lets say column K, cells containing data other than English Language (A-Z, a-Z, 0-9, / , . ! # % $ ^ & * ( ) _ + = ~ `| \ } { [ } / ? . > < also space)...

Hi, A worksheet base on Column I as criteria should be split into multiple worksheets and those sheets should be hidden and to assign a password to unhide. A worksheet called "Master" which has a text box entering a password and clicking on the submit button then that particular sheet should...

Hello, I would like to select data from 2 different columns in Excel, depending on the column selection in a drop down list (e.g. column A or B) defined in another named cell (e.g. Listcell). So I select the column from that list and then will make calculations on the chosen column. Can you...

I am looking to run a VLOOKUP or something to that effect that will use two references. Example worksheet: Sheet1 A B_____ 1| ref 1 2| ref 2 return this Sheet2 _A______B_____C 1| ref 2 2|ref 1 answer Sorry for the messiness, but what I am trying to do is...

Hello, I have a column in Excel with both positive and negative numbers. I would like to receive through VBA a notification on screen every time in the list a number switches sign from one row to the other. The notification is different with a change from positive to negative than from negative...

Hi, I am having 2 excels each with 50000 records. I am comparing both the excels by updating formula (Sheet1 data - Sheet2 data) in the first cell & then 'Autofill' the same formula to other cells using VBA code. Sample Code: ThisWorkbook.Worksheets(3).Cells(1, 1).Value =...

Hey all, What I would like to do is by use if excel VBA, I would like to have excel prompt word to enter in "todays date" where ever I have placed the respective variable. For instance, where ever I have [todays_date] located in my WordTemplate, then todays date will be inserted when I run my...

The following code gives me the "Run-time error '9': Subscript out of range" error on the last line, but only the first time it is run in a blank workbook. mypath = [windows network path]<WINDOWS Path Network> myfile = [text file name]<FILENAME extention without> With...

I'm trying to figure out how to proceed in calculating an average with following conditions: In column B, I'm looking for the average of variable length, defined by a Time value (e.g. 5 from cell 'Time') meaning this would be the average of the 5 first numbers from column A. The average...

I want to create an excel form in excel the first sheet will be the form and the second sheet will be the data Base, I need to Generate and automated document after filling the form to save separately in another folder with a new name... I need to show you guys the Excel worksheet but i don't...

This is new to me..so the terms may not always be correct. I have a list in a column in excel 2010. This list is in the thousands. Let's say that the list is in C1 and runs to C4036 each of the numbers are different too. Each of these numbers represent a electonic component number in our...

Hey all, I am using excel 07 vba to create a word doc. Currently when in my code I have it save as right away to make sure not to affect my template. What I need to do is add a count integer to the save as so if the file exists, it will save like this: fileexists (1).docx Dim wrdApp As...

I try to make the same calculation on every specifically named sheet of a file. The structure of every sheet is the same, only the length of rows varies. How can I write this in VBA? Thank you.

I receive an run-time error message 1004 "autofill method of range class failed" in the following setting, in the 2nd line. In this instance, I want to copy 1 cell from the cell 2 columns before. Range("M3").FormulaR1C1 = "=RC[-2]" Range("M3").AutoFill Destination:=Range("M3")...