XML to CSV conversion using Excel VBA macro
||...convert an xml file which has been created in a Linux environment to a CSV file which will be imported into...a VBA macro which runs in Excel 2007
This finished project is to be run in Terminal Server environment...simple. Excel 2007 is already installed and will most likely already be running.
||PHP, Project Management, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL, Visual Basic for Apps
||Sep 4, 2008
||Sep 4, 2008Ended
Macro for Excel
||...looking to create a simple VBA macro for Excel but have no programming skills beyond simple formulae.
The macro needs to look for 2 scenarios and return a flag (different for each scenario). Full details...looking to create a simple VBA macro for Excel but have no programming skills beyond simple formulae.
||Software Architecture, Visual Basic for Apps
||Sep 13, 2012
||Sep 13, 2012Ended
xls csv xml conversion macro
||...Detect new file creation
a. I am capturing data and can export this data every 20-60 seconds into a local...SQL drop/create
2. Using excel services/access services (of whatever you find best) I need to...a new file has been created and this should be the trigger to this data conversion workflow
a. For the
||PHP, XML, Data Processing, Excel, Microsoft Access
||Apr 29, 2011
||Apr 29, 2011Ended
336902 Create Excel Macro or Add-In
||...need an Excel 2003 Macro or add-in or VBA program code that will do the following: There are two parts...can be a macro/program that is run or some other way of achieving the same results. Finished product will...be an Excel 2003 file.
1. There are two pdf files attached to this offer. Original.pdf
||Visual Basic, Anything Goes
||Jul 22, 2009
||Jul 22, 2009Ended
Write file create macro in Excel
||Create a macro or program that will loop through a list of data and create a .dat file for each row....need to create a .dat file for every row. Data is in excel or open Office spreadsheet.
B: File name
D: concatenation of path and file name
I already have a macro to write one
||Visual Basic, Excel, Visual Foxpro
||Apr 5, 2011
||Apr 5, 2011Ended
Excel VBA Macro to Service
||...convert Excel Macros into a "SERVICE" i.e.
- Create WSDL
- Convert Excel Macro to a format...program in XML format
About the Macro
- Accept responses submitted by a user in response to an online...written MS Excel)
- Generate raw data in XML format which will be formatted in a PDF file
||Excel, Visual Basic for Apps
||May 4, 2013
||May 4, 2013Ended
||...database into excel format, I need a macro which will format the data the way i want it to and then a macro for...linking the excel table with Access and export to XML from there. Below is the process which I have to follow...attached excel files to get a beter understanding:
1) I get the data from a database in the form of
||PHP, XML, Visual Basic, Project Management, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL, XSLT, Visual Basic for Apps
||Jan 20, 2009
||Jan 20, 2009Ended
Converting HTML and XML special characters into excel with a Macro
||...HTML or XML. When I copied them into excel, some special characters arose; e.g. . I know this are special...is to create a macro that can convert these special characters into the normal ones. I attach a sample...The real file will have around 20,000 lines, but I want a macro I can use in the future as well.
||Oct 11, 2012
||Oct 11, 2012Ended
Excel Macro project
||...the .crm file into the Main Sheet using the button and selecting the correct file - Import the .rno file...Sheet using the button and selecting the correct file - using the reciept num/ R/No link. Ignore any...the rno file which has no link in the .crm file - Total up the two amount fields - Create a pivot table
||PHP, Visual Basic, Engineering, Software Architecture, Software Testing, MySQL
||Jun 3, 2003
||Jun 3, 2003Ended
Excel 2003 macro setup
||...Microsoft Excel Guru.
I am using Excel 2003.
I need a macro that does the following.
- On the file...need the macro to do the following by checking the template and see what id 1 and id 2 are together, than...the data file sheet "Sheet1", the range will be product 1 or 2 or three (will be decided by me), finds those
||Data Processing, Data Entry, Excel
||Feb 21, 2011
||Feb 21, 2011Ended
Paxton TX Excel Macro
||...need to create a simple repeatable Excel Macro that will do the following to the attached Master Excel...Excel file. We will do this at the end of every day after inputing the days work.**
**From this Master Xcel...data and create two separate spread sheets,? with the detail I need. The Master spreadsheet only has 17
||PHP, Project Management, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL
||Oct 13, 2008
||Oct 13, 2008Ended
Excel Macro File
||...someone to create me a simple excel file with Macros. Essentially, I have a list of clients coming in all...press a macro that generates a list of clients i don't already have on one sheet and adds the new clients
||Feb 23, 2013
||Feb 23, 2013Ended
Create macro to parse XML into human readable form in Excel
||...things) an XML output (attached in file)
I wish to parse this output into an excel sheet with the following...for many XML files, but they will all be the same format as the one attached.
The version of excel
||Script Install, Windows Desktop, Software Architecture, Shell Script
||Oct 30, 2012
||Oct 30, 2012Ended
||To create an excel macro with the given data. Please see cell A3 B3 C3 and example in the file provided
||Jul 9, 2012
||Jul 9, 2012Ended
Private project or contest #794463
||Sep 13, 2010
||Sep 13, 2010Ended
Private project or contest #281081
||Jul 9, 2008
||Jul 9, 2008Ended
||Need an excel macro which takes each and every single row from a sheet in an excel file and puts in pre...data, the macro has to create 1,000 individual sheets and put the data in each sheet in the given format...working macro.
||Sep 16, 2013
||Sep 16, 2013Ended
Macro for Excel
||...require a macro for excel to do the following.
I will use Ctrl f to find the record or records I require...selected the macro will create a folder for each selected record and name it with the record name in a delimited...where the excel file resides.
Assign a function key or have a oneclick to create the folder(s). See
||Script Install, Windows Desktop, Engineering, Software Architecture, Software Testing, Shell Script
||Feb 16, 2011
||Feb 16, 2011Ended
||...advanced Excel VBA Macros knowledge. The project is the following:
There is an Excel file which is the..."Master file" and contains a menu with options (a form with check-boxes). The user, using the Master...Master file, should be able to do the following:
- display data from different files
- concatenate data
||Jan 10, 2013
||Jan 10, 2013Ended
EXCEL MACRO NEEDED
||...Use an EXCEL MACRO to create a new excel file from 2 existing excel files. File1: Generated on the fly...Existing file named item_eq.xls Consists of many fields, however we are only using ITEMNO and EQ_CODE File3:...the New file that will be generated from File 1 and File 2 above. Name of this file must be uniqu...
||PHP, Engineering, SQL, Software Architecture, Software Testing, MySQL, Database Administration
||Nov 2, 2005
||Nov 2, 2005Ended