Please look at the following Put the semicolon character where I put &semicolon since s...create a test web page containing vbscript to do the following :- - Enter the url of the webpage or name of html file - it prompts for a macro name - when I click OK, it opens a excel file, creates a dynamic macro input by me and say "Hello" in a pop up window
Macro required to pull down mysql tables into an existing MS Access database. Table structures are identical in both mysql and the Access database. Only two tables need to be automatically inserted into the access database with new records from the mysql database being added to the access database. Shouldn't be overly complicated for someone with the
...much as possible a MS Word process for a client, I am pretty good with macro's but cannot get to do exactly what I need so I suspect its more VB based than basic macro. OK, what I need the macro to do ......in Word 2002/2003 1. Opens a new document based on a named template. 2. Initiates the mailmerge helper 3. Step 1 of 6 - selects Letters 4. Step 2
...bu the numbers are saved as letters. The Macro needs to convert the fiels to numbers so that standard calculations can be performed on the totals to provide some simple costs as %'s of sales. The firts being wages. Thi resulting info should be dropped into another tab of the extracted excel spreadsheet if possible so I can save the info on a monthly
I need an excel macro which collects the contents of selected cells and pastes the selected contents into the clipboard, delimited and in a specified font. The cells will be selected in a row and the row selected with a tick box object e.g. column b is tick boxes and column c is the desired data. The font will be specified and the delimiter will
...of a spreadsheet that takes data and decides if that data is higher or lower than a value range. Currently if it is higher it colors a cell green, if it is lower it colors it red. I want it to color it and play a sound for red and a different one for green or a third one for no change. The data is trading data and comes from an external data source
I have a single page excel form. I have a macro built into in that imports extracted email info (in a wrapped text .txt file) into their respected fileds (of which there are 20) or fills the indicated check boxes (of which there are 45). As I say, I have a macro in place, but the person who created it has other obligations and is unable to take
...item code, price, weight, etc. I need a macro written to be able to export each of these records into separate HTML files each with selected fields in certain places, similar to using an HTML template. I must be able to change the layout of the export file (ie set a different HTML template) and rerun the macro easily. The HTML files must also be default
We need an Excel Visual Basic macro that does the following: Given a spreadsheet with the two columns and any number of rows where the content of the two columns contains the following: column A column B row 1 . . . . n The macro would read the content of the spreadsheet and produce the following two files: One file would be a text file called .h and
“[accedi per visualizzare l'URL]? contains the macro I created to show you what I need done. I need the [accedi per visualizzare l'URL] converted into an excel file so I can grab information from it and copy it onto another sheet. The complication here is that I need a loop or some other vba function so I can do this for about 3000 files. [accedi per visualizzare l'...
I need Excel 2003 Macro developed, that will collect free financial data from two web sites. The input will be a single column in Excel spreadsheet, and the output will populate five columns of the same spreadsheet. The logic is very simple, the data is less than 1,000 rows. I will provide complete project details to the selected service provider
...adoption of the Euro by my country and the need to show both the currency existing currency as well as the Euro equivalent on all currency amounts. What I am looking for is a macro or code or whatever that at will do the following: 1. Allow users to indicate which numerical amounts need to be converted by highlighting the numerical amount, 'marking it'
...the other filename for value to be written to a tab delimited file(webserver_excel_import) 2)Payroll spreadsheet [accedi per visualizzare l'URL] the press of a button it must write the output to a file in the format as per the output 2nd tab in the attached spreadsheet. A max bid of $20 will be accepted for work on same day ## Deliverables 1) Complete and fully-functional
Write reusable Excel macro in Excel. Arrange rows and columns, sort, spaces.... Please see attached. Thanks! Jean ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature
I need a macro programmed that will go to a website run an extensive search for records that are returned to me in an Excel spreadsheet or in a document that can be run through a Monarch model to produce a spreadsheet. See attached files for more details include screen shots of website pages to access and data that must be returned.
...write a Macro which I could use in Microsoft Excel. I wish to backtest some financial market trading strategies. The end goal would be for me to have a spreadsheet where I can drop in the raw data in a standardised format and then run a macro which would calculate the profitability of my trading strategies. I would provide a sample of data which would
...excel file (Excel 2002 - english) and I want to convert it to CSV. I have problem with special characters in cells (Hex 0A - line break). I need someone writing a small macro that eliminates this special character, so we can save as CSV. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete
This interesting project involves creating an excel data entry macro. The attached file contains screen dumps of the proposed GUI, a specification, and a partial sample spreadsheet of data. IMPORTANT NOTE: MY APOLOGOY BUT I WILL NOT CONSIDER BIDS FROM ANY CODERS WHO HAVE LESS THAN FIVE (5) JOBS ON RAC AND A SCORE UNDER 9.0 SO PLEASE DO NOT
Need a simple macro that will run through a word doc file. The word doc file will have a title for each page in the document and will be terminated by a page break. The macro will need to split the doc into separate word docs. So, each page will be a new doc. The macro should take the first line i.e. the title and use it + the original file name to
Hi- I need my existing reports macro modified. If you can get this done, I have more modifications on this macro. So please, bid ONLY if you are very confident about this job. Review the requirements carefully. In the near future, I will need the XML portion of this modified also. the description is enclosed in the zip file since I am limited
I have a spreadsheet that contains data and periodically updates that data. All the data is in only one row of the spreadsheet. What I want you to program is a macro or application that saves this row of data every time the spreadsheet is refreshed (an app that does this at a variable interval will also be accepted) The final output after the...
...documents(10-15) that all require us to fill them in with Employees name,adress, contact details and so on. I would like a MS Word Macro or somthing similar that will enable us to enter the persons details into the macro/database/anything and all of the details are filled into the remaining 10-15 word documents. So 15 different documents, all with the
An excel macro is needed to run an automated task. A spreadsheet has data in it that is formatted like that show in the attached example file. Along each row there are Data cells, each of which is needed to fill out a separate row that is otherwise a clone of the initial row. Example, a row that contains the following where each comma denotes a column
...larger project, we need a combination of macros and functions to update a table in a Microsoft Excel spreadsheet when the user clicks an "Update" button. See the attached dummy spreadsheet for the general format. The date in the heading and the data in the table should be updated with the most recent yield curve rates from the U.S. Treasury web site:
I have manual process of entering data from txt files into excel. What I basically need is a macro to be able to open the text files extract the data put the data in the correct columns. The actual calculation is done by formulas already on the actual excel file. So its just basic data entry macro to save time that I wish to create. The number of
...excel VBA macro reads in a directory of .txt files. 2) It then creates 4 sheets and places different information from the files into these sheets. Some simple manipulation of the data is required. 3) It compiles several hyperlinks (some to a local disk and others to specific websites) and sorts each sheets by specific criteria. 4) The macro must is executed
...by first selecting the csv file with the data to be entered. E.g. transfering a list of employees and payments from a file imported from a payroll software package to another unrelated accounting package. So instead of the user having to type figures into a journal entry manually they can use this data transfer program to populate the form automaticlly
I have a price file that I receive updates for every three months. I need a macro or access written program that will compare the title in the NEW PRICE FILE and find it's match in the INVENTORY FILE and then run the price found in the NPF, run it through my wholesale to retail pricing formula, and plug in the new retail price into the IF. I also require
pRUEBA ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables ...
I need a macro written in Macro Express ( [accedi per visualizzare l'URL] ) to read and write to an excel file. Here is what I need to automate: 1) Download [accedi per visualizzare l'URL] and save on the C: drive ( or any specified path ) 2) Open excel, and start from row 2 and grab “keyx??, “dslnumber??, and “region??. Go to http://web-projects
...this code, I want to know if it is safe, and I’d like some debugging protections that will terminate the macro if it goes into some infinite loop or does some other bad thing . The code in question was produced in response to a request for a VBA macro for Outlook 2003 to execute the steps/option-selections set forth below. 1. File 2. Import and Export
...on the nature of the deliverables): a) For the desktop macros in MS Excel 2003 the buyer uses: A spreadsheet with all the macros included in it, and with "buttons" in the spreadsheet itself to run the macros and enter starting rows in case the macro crashes. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer
I need a quick macro or script that will take a folder of outlook files and save them all as .doc files or .txt with the file name and date created in the header, also the script or program needs to take the attachment off and save it to a seperate folder such as 'Attachemnts'. I need this macro in 3 hours, it is 9:03 EST here and i need it before 11:03
Hello- I need assistance in modifying the VB macro in this excel. I don't have all the details yet. But if you look at the VB code, and you are very very confident that you can modify it, then please bid for this project. we will pretty much keep the code the way it is. only some modifications here and there. I need this done this week
A block of text in a Microsoft Word document needs to be user selectable from a list of about 400 named blocks i.e. the user selects a name from a drop down list, and Word inserts the associated block at a single bookmarked position within a table. In view of the large number of blocks, the drop down should work like the font selection drop down on the formatting toolbar (i.e. type a few letters ...
Hi, We have a Excel workbook, known as a 'Comps Template', that contains several macros that we have cobbled together to do some data analysis, report and exhibit generation. We are looking to re-create and improve upon the functionality of this workbook by re-engineering the macros from scratch. This project requres not only intimate understanding
This is an Import and Export function from an Excel spreadsheet "Gantt Chart" to MS Project and vice versa. Requirements are contained in the attached .zip file with the spreadsheet. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be
An excel macro to fill in an incrementing number-character combo through a worksheet the first number needs to be like this 2201a second 2201b third 2201c and every time a parenthesis is found in a certain field of that record, it should increment the 01 to 02 and set the letter back to 'a' to look like: 2202a that's it. ##
I want a VBA macro (which does not rely on sendkeys) for Outlook 2003 that would execute the following steps/option-selections: File Import and Export Export to a file Personal folder file (.pst) Contacts for Ofc (public folder address book) Insert a filename [strVar] (After i get your code, I will modify it to create a strVar that
For MS EXCEL we need a seperate application or a macro written that can output a line of text to a specified text file. The output of the line of text will be triggered when a value in a specified cell is changed (to a specified new value such as from 0 to 1 or 1 to -1) as the result of a calculation only there will be no worksheet event at all ( the
I need someone to write a web based macro for an existing website to automate data entry and image uploads. The process generally involves uploading images, adding tags, creating sections, inserting other text from a db. It will all be done from a mysgl db and interact with another web site. Please provide your experience and details of previous macros
...code in the attached spreadsheet. I followed the example in Mr Excels book on selecting page fields on a pivot table outside the pivot table using a macro but the From and To requirement I have is not to be found. [img][accedi per visualizzare l'URL][/img] Here is the sample excel spreadsheet where I have a pivot
...links. The links take the user to a web page that displays the individuals address. I want to copy/paste the address of each one into the excel file. I tried to write a macro, but it only selects the specific link that was selected when I was recording and I can't figure how to have it go down the list on the spread sheet and select each specific
**Overview: **We need enchancements and bug fixes made to our Application This application is an event macro recorder. It opens up a window, listens for events, then writes out DOM statements that can be fed back in and replayed. It also allows for checking values on existing elements. This is a test tool. Other application that are like
...Excel code that will step through rows on Sheet 2, comparing and updating rows on Sheet 1. General Idea: If a row exists in Sheet 2 and Sheet 1, update Sheet 1 with Sheet 2 data. If the row exists in Sheet 2 but not in Sheet 1, append the row to Sheet 1. For a row to 'exist' a certain number of columns from Sheet 2 must match a certain combination
I use an automated software system (channel advisor merchant) that output my customers delivery data into an excel file. At present I manually enter that data into Australia Posts eParcel Software. This is very time consuming. I want a Macro or small program that can convert the file created by Channel Advisor (excel file attached as report
...email and will be waiting for me and all the questions will need to be answer within 1.30 min period the questions will be: Convert IEEE --> Real , Real --> IEEE Astro Macro C CObol subroutine to write Fragment code using Fcom (floating Point) if you confident with this topics please bid it and please check this bid within 6 hours from
We have a mail merge document that we are building for a client. It involves merging "Yes/No" data from a 3rd party data source ([accedi per visualizzare l'URL]). We transform these "Yes/No" fields into checkboxes using an IF field in Word. However, when the merge first runs, the checkbox field does not update until the user highlights it and presses &qu...