Build Me A Macro
Open "Most Populated US Cities" excel file for NEXT city to use.
Start at the bottom - work...cells and goes to next.
add keyword from text file (roofing|salons|etc.)
add location (City, State)
...excel files together. Remove DUPLICATES.
Create folder with same city name
Save in folder
||Excel, Software Testing, Test Automation, Machine Learning
||Feb 1, 2013
||Feb 1, 2013Ended
Excel Macro for comparing text files
||I need .xlsm Excel file that can import and process one or more TSV files (TAB separated values) and...variables.
- The files must be imported automatically, file names/paths will be listed in the Settings sheet
- The results will be exported into 2 text files: "Identical" and "Different" in a new folder
||Data Entry, Excel
||Mar 28, 2011
||Mar 28, 2011Ended
525829 Create a macro
||Create a macro which starts automatically when the .docm is opened and creates a mail merge using each...another directory.
The data source would be a .xlsx file which is created by a java application I have already...constructed.
1 x template word file with barcode macro inserted (you will need to install the
||PHP, ASP, Java, .NET, Templates, Anything Goes
||Sep 26, 2011
||Sep 26, 2011Ended
Create an Excel macro
||I'm in need of a macro that will combine 63 worksheets that are in one workbook into a master worksheet...worksheet.
I will also want this to be a general macro that can be reused for combining worksheets into...applicable to this particular task (see attached file).
||Visual Basic, Excel,
||Apr 25, 2014
||Apr 25, 2014Ended
Macro that will create two tabs in Microsoft Excel
||Macro Specifications for Shorefront Y LINKS import into Sage Fund Accounting
The Macro will be designed...designed as a button that, when pressed, will create two identical import tabs within Microsoft Excel based...original data file.
If the Payment Method column contains the text “Credit”, create an import tab
||Perl, Java, Visual Basic, C# Programming, C++ Programming
||Mar 28, 2012
||Mar 28, 2012Ended
.Bat (Batch File): Open Text File in Excel and Run Macro
||...a batch file (.bat) that will open a text file in Excel, run a predefined macro, save the file with the...the original name (still in text format), and close Excel. It should work with WatchDirectory, which means...Environment Variables used by the program to indicate the file name: http://www.watchdirectory.net/wdhelp/plug
||PHP, Engineering, Software Architecture, Software Testing, Website Testing, MySQL, Website Management, Web Hosting
||Jul 24, 2007
||Jul 24, 2007Ended
macro code for web site
Data Entry Automation
0. Macro runns and user gives 3 inputs an Xl File, a username a password. Nacro...an XL File tha has numbers and text messages
3. Macro copies number in one position
4. Macro copies...copies text in text position
5. Macro clicks on send a message
6. Macro clicks for new Mesage send
||Java, Visual Basic, Data Processing, Data Entry
||Apr 14, 2009
||Apr 14, 2009Ended
Create a macro for excel
I need to create a macro for excel. Every week I receive few price list from suppliers and I compare...I will like to create a macro to this automatic. The comparative it must be with a TEXT FIELD.
||Data Processing, Data Entry, Excel
||Oct 14, 2013
||Oct 14, 2013Ended
Excel Macro /VBA - repost
||...need to create 2D barcode (e.g. QR Codes or PDF417) in excel. I have attached a sample file and you... it should create a 2D barcode in cell "B1" of the text value of "A1". It can be a macro or addon.
||Visual Basic, Excel, Microsoft
||Jul 6, 2013
||Jul 6, 2013Ended
Windows project, text recognision / macro ...
||I need a macro that will be called every x minutes, the macro will
1 look for entries of a certian...the values on the menu, add them in a existing text file and click 2 other buttons
look for more entries
||Visual Basic, System Admin, Testing / QA
||Sep 26, 2009
||Sep 26, 2009Ended
Create Excel Macro
||...Aged Debtors file containing the data that needs to be extracted out of the original file. I've attached...attached this file to clarify exactly which totals are to be extracted, not as a working file.
Our client...to time. The Macro needs to take into account that although the structure of each file will remain consistent
||Visual Basic, Excel,
||Jan 27, 2014
||Jan 27, 2014Ended
Excel Macro/VBA Script
||Create Excel macro (VBA script) that checks for certain rules and/or makes changes to each column in...not be blank) or changes it requires (e.g. change text from X to Y). Cells that violate a rule for a column...should be highlighted in yellow.
I've attached a file that contains a table with full specs (i.e. lists
||Script Install, Windows Desktop, Excel, Powerpoint, Software Architecture, Microsoft Access, Word, Microsoft Exchange, Shell Script, Visual Basic for Apps
||Oct 13, 2011
||Oct 13, 2011Ended
398633 Create Excel Macro
Attached Mturk output file to test the macro.
The Macro needs to create new worksheet that will...will be named: "Spun Article" in the Mturk out file.
In this worksheet will contain five columns: "Sentence...3) in the order they appear in the Mturk output file. The next three columns will contain each one the
||Excel, Article Rewriting, Anything Goes
||Mar 14, 2010
||Mar 14, 2010Ended
Create a browser macro using something like imacros
8. Copy the new shortened url text.
9. Open twitter.com in 3rd tab.
10. Tweet that..."copy link location", save that link to a notepad file or csv.
13. Loop this endless or 20,000 times.
...link to that notepad or csv file.
15. In the end, I will have a notepad file, each of the 20,000 lines
||PHP, Software Architecture, Test Automation
||May 12, 2014
||May 12, 2014Ended
523123 Create a macro
||...dont know if this is possible, but I want to create a macro which starts automatically when the .docm is...printing including running a macro which is already installed to create barcodes in the merged document...document.
The data source would be a .csv file which is created by a java application I have already had
||PHP, Java, Anything Goes
||Sep 13, 2011
||Sep 13, 2011Ended
mega Excel macro to parse text
||...workfile.csv is a source text file that needs to be converted to look like the file called after.xls.
...be done to the text.
There are entire rows that need to be deleted if specific text appears in a cell...like this to be a single macro if possible which begins by pulling in the file c:workfile.csv and then
||PHP, Windows Desktop, Linux, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Mac OS, Software Testing, Word, Microsoft Exchange, Chrome OS, MySQL, UNIX
||Apr 27, 2004
||Apr 27, 2004Ended
Macro needed-Register accounts on 90 web 2.0 sites/post text
||...need a macro made for the Firefox iMacros plugin.
The macro needs to:
1. Automatically Create accounts...captchasniper
2. Pull from a list of 90 articles from a text file, post one article per web 2.0 site using the new
||Script Install, Shell Script
||Feb 3, 2012
||Feb 3, 2012Ended
Modification to Word 2007 macro
||...attached template contains a macro called "Gen Chart" that uses a wordlist (a txt file) as input, searches a...by specific rules relating to Headers (style and text).
I need this modified to do something a bit...search, but instead of using an input file, it needs to pull specific text from the document itself, and output
||PHP, Visual Basic, .NET, Engineering, Software Architecture, Software Testing, MySQL, Visual Basic for Apps
||Feb 10, 2009
||Feb 10, 2009Ended
Excel text manipulation macro needed
We need a Excel macro to execute some text manipulations on a opened spreadsheet. This will...should cause failure with no alterations to the file. User should be informed of the failure and the...tab-delimited text to the user's Desktop.
6. Should inform the user of the successful export of the file.
||PHP, Visual Basic, Script Install, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Mac OS, Software Testing, Word, Microsoft Exchange, MySQL, Visual Basic for Apps
||Apr 23, 2008
||Apr 23, 2008Ended
iMacros - create a macro
||...macros in iMacros.
I need a macro that will catch a certain image or text on the screen.
For example...have a timer counting down from 5 to 0. I want the macro to send a mouse click only when the number 3 is...I need the macro to wait until the counter displays the number 3, and then I need the macro to click on
||PHP, Windows Desktop, Engineering, Software Architecture, Software Testing, Microsoft, MySQL
||Sep 12, 2009
||Sep 12, 2009Ended