I'm trying to create a macro in Excel 2003 that will go from one worksheet to another within a workbook and create a range name in each sheet that includes all the data within that sheet. Since the amount of data will change up and down, the macro needs to be able to create a name what will always include all the data without leaving any out and
My ideas:- 1) User enter the following numbers: a) Country Code b) Area Code c) Tel numbers 2) Redirect user to the following options: a) Member Page b) Member URL c) Private Message 3) Details on a) Member Page Template contains:- i)user Upload Member Photo ii)Latest News iii) Phot Gallery (2 pictures) iv) Stats
I have completed most of the projaect however, when I need to implement a function that computes integer powers of a rational number. Here is the prototype I was given. friend rat pow(const rat&, int); //computes integer powers of the rat One other problem I am having is that my program is not compiling and I get an internal compiler error. ## Deliverables 1) Complete and fully-...
(Please refer to the attached Excel spreadsheet). Looking for an Excel macro that would check to see if a sum of any combination of a specified range of cells (e.g. A2:A32) falls into a narrow range or values or is an exact match to a target cell value (B2). In this example, B3 represents the actual sum of A1, A4, A5, A8, A11, A13, A16 while B4
...make a macro button that cuts and pastes existing data into another worksheet. It must reference cells for which rows and columns it must place data into.. really a cut & paste button that references markers and pastes data accordingly... ## Deliverables excel button that executes the above macro correctly.... ## Platform Microsoft Excel, VB
I'm trying to make a button in my excel worksheet that cuts and pastes data that is in this sheet into another worksheet. It must be pasted into the correct columns and rows of this new worksheet, hence it needs has a reference it must lookup for which column to go to and a reference (by the first column that has field names) for which row it must
...include a macro and dont have one. ## Deliverables I have just a very simple excel macro i need help with. I need a macro that can take a list of percentages and highlight the row of data with a percetage higher than 95%. I also need to know how to put a button into my project to run the macro. ## Platform This is running on Windows XP with excel ...
...develop an excel spreadsheet that will contain a table of data with country codes and the cost of calling these countries per minute. We have all of this information available to us now. The spreadsheet will need to import a flat log file each day that contains information about all of the calls made and received by the phone system. The excel script
...a certain format. Currently his secretary enters all info by hand in WordPerfect. The office wants to use MS Outlook Calendar and all its features. The calendar is in a public folder. Solution: We created custom appointment form in Outlook that gathers all required info. It has 1 small coding bug to be fixed. We created a Macro connected
Please help me write a Macro that I can use in Excel/VBA that will Import an Excel worksheet from one file into another file's target worksheet. The Macro will: 1) Be invoked by a control button 2) Produce a window that will prompt the user for the location of the source file. (Standard file navigation) 3) Add TWO hard-coded alpha fields
I have a excel file that is doing financials for our company . I need a VBA excel programmer to write some macros for this excel spreadsheet. I want someone really professional and quick. Experienced VBA programmers only. The VBA macros will need to toal up columns in specified order. It needs to create rows and columns in a specific place based on
...open at a time. The data file opened is based on the work type. The data is always Window 2. The first macro should: a. Activate the data file. b. Purge any duplicate data in that file and save the text document. The second macro should: Using data entered by the user into the current section of the open document, search the data file
...-> 23 43 21 14 25 36 A Microsoft Office like column management. A column mixed with B column. On C column the mixed numbers. A column can have up to 7 numbers. B column can also have 8 numbers. C column can also have up to 15 numbers. A column should be stable; B column should match the whole list to A. Results saved to a different column perhaps also
EXCEL MACRO DEVELOPMENT In order to provide clients with a quick analysis of the information processed from our databases, we need to link the excel spreadsheet that is a standard output of our software to a macro that will automatically chart the information on different parameters. These outputs will vary according to specific client needs, so the
Please run the attached MS Excel Spreadsheet. What I would like is the following: 1.) If you run this macro investment spreadsheet (say 500 trials), you will see that it calculates average returns as a percentage of total trials and an average time frame of the investment. I would like to put in two fields in the spreadsheet area of (minimum investment
...writing a quick macro or however you feel you can do this project the easiest. This project is NOT to give me any code. All I want from you is the complete dealer archive (without duplicate entrees). I want the list delivered in MS Excel format with the following information columns: Name - Street Address - City - Zip code - Phone number - URL
...of this auction are somewhat confidential but here are the main aspects of what will be needed: 1. I will recieve an e-mail with customer information, including order numbers, payment amounts, etc.. 2. E-mail needs to be intercepted and information needs to be gathered (I can setup an e-mail forwarder to forward these e-mails to a new e-mail
...into Excel 2003. ## Deliverables 1) Excel 2003 macro that will execute from an icon in my toolbar 2) Explicit instructions on how to install and run your macro. 3) Assurance that your macro is virus free. 4) Macro should be able to batch process designated records within database. 5) I will want to test and confirm that your macro wo...
...Then there is a textbox in which the worksheet names show up so they know which worksheets they need to go to. An example of this is on the query tab. I started to write a macro, but got stuck. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation
I need a program (VB macro) does the following. 1. Opens a window so I can select certain text files. 2. Once I select the text file, I get asked two questions. 2a. (1) Is this text file a "x" or "y" 2b. (2) Is this text file a 1,2,3,4 or 5 3. Copy the text file to an "input" worksheet in Excel. *the text file contains a lot of data, only 2 rows of
**_This Macro will be used in MS Excel 2002_** 1. READ [login to view URL] in Zip folder "Test" 2. READ the README file ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s)
...project consists of **rewriting** an Excel VBA macro that I have already written. The macro works, but I do not have the experience to do the error handling or to make sure it works on many versions of Excel (PC Excel 97, 2000, 2002, 2003). Optionally, Mac versions of Excel. I have attached the current macro. Here is what it lacks: 1. O...
For my homework assignment, I need to be able to retrieve the number, when my ISDN number is called; I need to be able to read the caller ID from the ISDN and show this in a simple interface on my PC screen. This needs to be done in C#. ## Deliverables 1) Complete and fully-functional working program in executable form as well as complete source code of all work done. ## Platform Windo...
This site will be linked to another site wh...but we need to have a form which takes the customers details if they want us to help them sign up and connect their free numbers/paid numbers for them... so main site - fill out our form to receive/begin connecting your free numbers etc - something like this - but this has to be a very attractive site...
I need a program that will record the mouse movements and keyboard keys sessions and play them back too. The macros will be saved on the Hard disk. The program **must be stable**, **Least CPU usage** and must be in VB. ANy Questions..any queries...Feel free to ask me. Happy bidding. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well a...
...name and email address and then write that information to a text file. I have a series of emails that contain customer names and email addresses. I want to run a program/macro from with MS outlook to examine each email, one by one, and if it contains a customer name and email address, extract that information to a text file. ## Deliverables
Hi I need a small macro working in VBA to be included in MsWord document. It should do mostly 2 things : 1. ask for a file to be proceeded (a windows dialog box, use comdlg32 for that) 2. create a zip file of the indicated file with the same name and zip extention (use any zip compressing dll available for free) that's all thanks for
I need a program that will assist with quickly dialing phone numbers (telemarketing). I have a text file of phone numbers (one per line), followed by a note, like this: 14155551212,acme company 5558735,call back on friday 5559823,abc company 12125553235,xyz company The program should have buttons for: 1) scrolling the list (text box with up/down
...you will write a ClassifInt class that classifies a number as being Deficient, Perfect, or Abundant. Your main method should test your class for numbers between 20 and 30, numbers between 490 and 500 and numbers between 8120 and 8130 (inclusive in all three cases). Fo up to 10 points of Extra Credit, write a method to find the smallest odd abundant number
The macro I’m looking for is one that is designated for the F4 key to open attachments. Program and Operating system: Outlook XP on Windows XP Professional. When a message is highlighted that has an attachment, the user would then press the F4 key which starts the macro that does the following steps: The “Shift+F10 the “H?? key, for attac_h_ment
...It requires that a program be written to find all perfect numbers. A perfect number is a number that is equal to the sum of all of its positive factors excluding itself. for example 28 is a perfect number because 28 = 1+2+4+7+14 A program needs to be written to list all perfect numbers under 10,000 through an exaustive search. Implement the following
Random Integers are uniformly distributed within a range of values. Write a program that uses simulation to see whether the units digits of the random numbers are uniformly distributed. Begin by declaring count as a 10-element array of integers. Using a loop, generate one million random integers in the range from 0 to 99,999. For each value, extract
Very simple project that integrates a number of Excel "Sheets" into one Purchase Order Spreadsheet. We simply have a Purchases List (sheet1), that we enter data into. We have a Purchase Order Template (sheet2). We have a Suppliers address template (sheet3). We want to be able to hit a button and then get the system to automatically integrate
...randon numbers (N can be less than or equal to 10,000) from a uniform distribution on the interval from [0, 1). Store them in an Array and display them in a combo box. Perform the Goodness to Fit test to determine if the numbers do follow the uniform distribution. Using 10 intervals (0, 0.1, 0.2, ect.), determine the number of random numbers you generate
I need a visual keyboard and macro program to allow people to click on a visual representation of a keyboard and have the corresponding Unicode characters or diacritical marks appear in the Windows application. In addition, I need to be able to map diacritical characters to CTRL or ALT key combinations so the user can choose to input the diacritical
...(add 8x + 2x). Hence, the only hard part is the addition of two 64-bit numbers. Carry's must be checked and handled to get accurate results. Write a MIPS program to multiply two 64-bit unsigned numbers. You should use program 1 to read in your numbers. Once you have the numbers stored, you may use the algorithm we went over in class to multiply them
Looking for a outlook 2002 macro that will let me autoreply to emails with the original message sent by the sender. Also need to be able to autoreply to the same sender more than once. I have a pop3 client based spam filter called SAProxy. It gives a score to all emails comming into an account. So when the email arrives in the email client (outlook
...required Macro is to read, convert and organize text-based RealNetworks’ server log files into MS Excel workbooks, which in turn should be manipulated into Pivot Tables and Charts. I have created a starting point Excel Macro (ImportLog) where the text-based input files are converted into Excel format and columns are detected. I now need the m...
Problem Description: In this assignment, you have to develop a mechanism to carry out arithmetic for very large numbers, say around 40 digits long using stack operations on an [login to view URL] numbers can be positive or negative numbers. Your program should operate in the following way: When your program starts it should ask the user to press 1 for addition
This java program is just missing part of the code. I am sending the zip file of the program and class. The missing data to be done is: Using a for-loop, find the sum of the entries in the salesQuantity array. Using sum and the value of the counter variable, assign the correct value to the average variable. Assign the value true to the variable statsUpToDate. I'd like to get this as...
I have an excel file with a number of macros. One of the macros has stopped working due to changes that were made to the excel file. I need someone to figure out what is wrong with the macro and make it work. Not a complicated assignment and could be done in five minutes by someone with the right experience. The code itself is five lines long.
I need a macro for Oultook 2002 that enables me to do the following: Sometimes I receive 30-40 messages related to one topic. I would need a macro that, after selecting the emails, with one click enables me to send a reply message to all of the client message, saying something like: ---------------------------------- Dear Sir. We confirm
Is there a way to write a macro from my Desktop that opens: CProgram FilesPersoftSTOfficeSessions and then enters: 1. “Paul?? [enter] 2. “Paul?? [enter] 3. [Enter] 4. [Enter] 5. “8?? [enter] 6. “22??[enter] 7. “1?? [enter] Steps 1-7 are the applications steps to get to the desired screen.
I would like a macro for excel 2002 windows 98 that takes a web query and saves each refresh in sequence on a scroll to a second sheet for processing. The macro should be able to adjust to changes in web query. I have attached a sample file for general appearance. ## Deliverables 1) Complete and fully-functional working program(s) in executable form
...log files into Microsoft Excel files with well defined columns. The resulting Excel files must then be used to produce audio/video file usage reports using the Pivot Table Chart feature. The required Excel Macro must receive as input a variable number of individual log files, and produce one or more consolidated Excel files. Consolidation must
...tell. They only support running filters when mail is received. I need a macro that will go thru my inbox and file my mail by moving it into the appropriate folder based on who sent it to me - the FROM: field. If a folder doesn't exist, just leave it in the inbox. The macro should also be able to go thru my outbox and file my sent mail by moving it
Im after a macro that allows to do the following functions -Create a macro that has keylogging ability/mouse location point/click -The macro program will run through a certain server for validation in order to function -The macro can save the different files and open them upon request. -I will have complete ownership and rights over
This is a variation on a previous request. This must be done as a macro for Outlook (VB) as no combination of rules can do it. I have VB6 and [login to view URL] if necessary. I used to use Eudora. It had a feature to Manually run filters, run filters on incoming mail, run filters on outgoing mail or any combination thereof. There is no such feature in Outlook