|XML to CSV conversion using Excel VBA macro
||...is to convert an xml file which has been created in a Linux environment to a CSV file which will be imported...MYOB.
The application will be a VBA macro which runs in Excel 2007
This finished project is to...in the environment and want to keep it simple. Excel 2007 is already installed and will most likely already
||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
|create macro automation in excel file
||1. Use a signin sheet to automatically create a blank form in a new tab
2. Automate Count of tab
3...3. Record current time and date by using a shortcut key or icon
4. Auto generate name for each tab
||Jul 5, 2015
||Jul 5, 2015Ended
|Create Excel Macro or Add in which will be distributed to users in .exe file
||...the following :
1- Create a Excel Macro or Add in:
-When clicked on the Macro or add in. It will popup...table ID
-When hit submit, the Macro or add in will do a Restlet call using the username and password and...Restlet will return a XML Obj which will contain the table info.
-The Macro or add in will read the
||Perl, C Programming, Visual Basic, .NET, Excel
||Dec 15, 2014
||Dec 15, 2014Ended
|xls csv xml conversion macro
||...envision your solutions to function:
1. Detect new file creation
a. I am capturing data and can export...HTML
3. SQL insert
ii. SQL drop/create
2. Using excel services/access services (of whatever...whatever you find best) I need to detect when a new file has been created and this should be the trigger
||PHP, XML, Data Processing, Excel, Microsoft Access
||Apr 29, 2011
||Apr 29, 2011Ended
|Macro for Excel
I am looking to create a simple VBA macro for Excel but have no programming skills beyond simple...previously populated remains unchanged.
The macro needs to look for 2 scenarios and return a flag...Deliverables
I am looking to create a simple VBA macro for Excel but have no programming skills beyond
||Software Architecture, Visual Basic for Apps
||Sep 13, 2012
||Sep 13, 2012Ended
|336902 Create Excel Macro or Add-In
||I need an Excel 2003 Macro or add-in or VBA program code that will do the following: There are two parts...parts included in this bid.
This can be a macro/program that is run or some other way of achieving...same results. Finished product will be an Excel 2003 file.
1. There are two pdf files
||Visual Basic, Anything Goes
||Jul 22, 2009
||Jul 22, 2009Ended
|Converting HTML and XML special characters into excel with a Macro
||...the website, most likely HTML or XML. When I copied them into excel, some special characters arose; e...that are supposed to be.
The task is to create a macro that can convert these special characters into...the text I have. The real file will have around 20,000 lines, but I want a macro I can use in the future
||Oct 11, 2012
||Oct 11, 2012Ended
|Excel VBA Macro to Service
||...convert Excel Macros into a "SERVICE" i.e.
- Create WSDL
- Convert Excel Macro to a format...can pass data to calling program in XML format
About the Macro
- Accept responses submitted by a user...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
|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....fieldthe attached, I need to create a .dat file for every row. Data is in excel or open Office spreadsheet...data
B: File name
D: concatenation of path and file name
I already have a macro to write
||Visual Basic, Excel, Visual Foxpro
||Apr 5, 2011
||Apr 5, 2011Ended
||...into excel format, I need a macro which will format the data the way i want it to and then a macro for...for linking the excel table with Access and export to XML from there. Below is the process which I have...have to follow. Please look at the attached excel files to get a beter understanding:
1) I get the data
||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
|Excel Macro File
||I am looking for someone to create me a simple excel file with Macros. Essentially, I have a list of...list of emails from these new clients and press a macro that generates a list of clients i don't already
||Feb 23, 2013
||Feb 23, 2013Ended
|Paxton TX Excel Macro
||...to create a simple repeatable Excel Macro that will do the following to the attached Master Excel file...Master Xcel spread sheet? I need to pull data and create two separate spread sheets,? with the detail I...spreadsheet only has 17 columns.? So the data you will be using is minimal.**
||PHP, Project Management, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL
||Oct 13, 2008
||Oct 13, 2008Ended
|Excel Macro project
||...Import the .crm file into the Main Sheet using the button and selecting the correct file - Import the ....rno file into the Main Sheet using the button and selecting the correct file - using the reciept num/...in 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
||Jul 9, 2008
||Jul 9, 2008Ended
|Creating a macro in Excel
||I need a macro created for extracting, sorting and formatting data. There is a file attached for steps...created in a macro. Also attached is a raw data that you will be using to create the macro. This raw...raw data is very simple, but the macro needs to be able to work with small and large amount of data. You
||Data Processing, Excel, Data Mining
||Aug 14, 2015
||Aug 14, 2015Ended
|XML files from excel data
||Create a macro for Excel 2007 that will create XML files based on the information in the file
the attached zip file has the specifications and sample files.
||PHP, Engineering, Software Architecture, Software Testing, MySQL, Visual Basic for Apps
||Feb 23, 2010
||Feb 23, 2010Ended
|Create macro to parse XML into human readable form in Excel
||...other things) an XML output (attached in file)
I wish to parse this output into an excel sheet with the...many XML files, but they will all be the same format as the one attached.
The version of excel most
||Script Install, Windows Desktop, Software Architecture, Shell Script
||Oct 30, 2012
||Oct 30, 2012Ended
|Excel 2003 macro setup
||...someone who is a Microsoft Excel Guru.
I am using Excel 2003.
I need a macro that does the following...following.
- On the file (sampledata.xls),the first sheet "Sheet1" holds all the data that i need filtered...2 are fixed and always together.
I need the macro to do the following by checking the template and
||Data Processing, Data Entry, Excel
||Feb 21, 2011
||Feb 21, 2011Ended
|Create macro in excel to create a *.xml file for Endicia / Dazzle Postage printing routine
We need a excel macro that creates a “xml” file in the back ground for Endicia “Dazzle” program...description I will refer to attached files by the file names you can lookup to view more details.
=...clarifying details are found in the winzip file via word file and pics etc...
Thank you very much.
||PHP, Software Architecture
||Mar 20, 2014
||Mar 20, 2014Ended
|EXCEL MACRO NEEDED
||...DESCRIPTION: Use an EXCEL MACRO to create a new excel file from 2 existing excel files. File1: Generated...File2: Existing file named item_eq.xls Consists of many fields, however we are only using ITEMNO and EQ_CODE...This is the New file that will be generated from File 1 and File 2 above. Name of this file mus...
||PHP, Engineering, SQL, Software Architecture, Software Testing, MySQL, Database Administration
||Nov 2, 2005
||Nov 2, 2005Ended