||I need to create a spreadsheet in excel and by clicking on a button it should prompt me for a date and...when l enter the date, data should be displayed on the spreadsheet from an oracle database.
very basic...basic spreadsheet with connection to oracle db using the data to populate the speadsheet.
||PHP, Windows Desktop, Project Management, Engineering, Software Architecture, Oracle, Software Testing, Microsoft, MySQL, Visual Basic for Apps
||Aug 20, 2008
||Aug 20, 2008Ended
|526236 Excel VBA + 2 batch files
||We need two Excel VBA files, each of which creates a batch file, runs the batch file and then deletes...deletes the batch file after the batch file has completed its run.
Batch file #1 uses the inputs (source...the new CSV file to the destination directory.
Batch file #2 uses the inputs (source directory, destination
||Visual Basic, Excel, Anything Goes
||Sep 27, 2011
||Sep 27, 2011Ended
|Data scrubbing in excel using VBA
||Have a report in excel that needs to be scrubbed to be easily readable. Vision clicking a command button...button in a main tab that once clicked using vba, scrubs the entire file and outputs in a new tab, or
||Visual Basic, Data Processing, Data Entry, Excel
||Feb 17, 2012
||Feb 17, 2012Ended
|Advance Reporting in excel/Access using VBA/Add Ins and DBMS
||...UI will be excel and access. Data source is oracle and MS Sql Server.
Report include Data table/Pivot
||Excel, Oracle, Microsoft Access, Microsoft SQL Server, VB.NET
||Sep 13, 2014
||Sep 13, 2014Ended
|populating excel template using VBA
||Transfering data into an excel template using VBA for Excel from 2 monthly files.
let me know if you
||Visual Basic, Excel, Microsoft Access, C++ Programming, , Visual Basic for Apps
||Apr 4, 2015
||Apr 4, 2015Ended
|Web scraping using excel and VBA
||I have prepared an excel spreadsheet for monitoring of stocks in Australia. I have prepared a couple...couple of macros to scrape data from the web but I think they could be improved by an experienced web scraper...macros which I am hoping to perfect:
1. Uses excel web data to draw information from a website, and then
||PHP, Visual Basic, Excel, Software Architecture
||Mar 23, 2015
||Mar 23, 2015Ended
|AdWords reports using Excel VBA
||...Google AdWords reports using Excel VBA.
I just want to define type of report and data range to download basic...search query).
Reports should be downloaded into Excel spreadsheets.
||Excel, Google Adwords
||Apr 27, 2013
||Apr 27, 2013Ended
|VBA Macros and Data Conversion
||Need someone with solid VBA / Macro skills to setup workbooks with macros for finance users.
Over...Over the next few weeks I will have excel work on an hourly rate - good performers will be rewarded with...setup a macro that converts 12 monthly columns of data to 12 separate csv files.
I will use this as a
||Oct 7, 2011
||Oct 7, 2011Ended
|Excel cell data to Access Table using VBA
||Need VBA module code to open multiple Excel Spreadsheets, collect cell values from one or more sheets...3 Books to make a single records from each book using specified fields then append to existing table in...closing. No modification to spreadsheets only read data elements from cells and add to table in access.
||PHP, Visual Basic, Engineering, Software Architecture, Microsoft Access, Software Testing, MySQL
||Jul 29, 2004
||Jul 29, 2004Ended
|Batch operations on Excel files
||I would like to do some 'coloring' of Excel columns based on certain criteria, as well as some multiple...working on Excel files and have been wasting considerable time 'coloring' the columns of these Excel files...smaller than B' etc etc and finally choose a color in Excel to color each with.
Note: You must also include
||Apr 20, 2012
||Apr 20, 2012Ended
|Excel - Manipulate Columns using an Excel VBA Form
||...all the data fields from various tables extracted from a database. The users are not excel literate...macro to list all the columns in the sheet via an VBA Form (Utilizing a Listbox and/or other combinations...the same order as they are in the original source data.
The output should be in a new sheet in the
||Visual Basic, Excel
||Apr 10, 2015
||Apr 10, 2015Ended
|Get data into Excel using vba (SOAP)
||I want an example of how to use SOAP in Excel 2013 (vba) by reading http://www.trainingpeaks.com/tpwebservices/service
||PHP, Software Architecture
||Nov 25, 2014
||Nov 25, 2014Ended
||...procedure is still widely used, as in PL/SQL in Oracle.
**This research will focus on the issues and...(monolithic) approach to a functional approach using modular software with macro and micro functions...language using transactions, procedures and other functions. We can write a function in Oracle for instance
||PHP, Project Management, Engineering, Technical Writing, Software Architecture, Software Testing, MySQL
||Aug 25, 2008
||Aug 25, 2008Ended
|VBA Excel Macro
||...tree and copy files according to an excel list of paths.
- a tree structure containing...and files and the path to this structure.
- an excel sheet listing all the files of the tree structures...rtf
The excel contain several columns. Two are important in this project: the path and a batch number
||PHP, Perl, Java, Visual Basic, Excel
||May 17, 2009
||May 17, 2009Ended
|Zulutrade.com CSV-Export in Excel 2003 using VBA
||...provider historic data to Excel 2003 using vba. Zulutrade.com provides it as csv data. Step1: Extract from...structure, Step2: Import it in Excel using vba, similar to a Yahoo data query. Sample filename: Trade
||Data Entry, Excel, Visual Basic for Apps
||Jan 27, 2015
||Jan 27, 2015Ended
|EXCEL VBA and OCR
||Take picture using windows 8 tablet
Extract data from photo and transfer to excel
||Data Processing, Data Entry, Excel
||Oct 28, 2013
||Oct 28, 2013Ended
|expert in excel macros vba
||import data invoice from different excel files into 1 Master Sheet
create and saveToPdf separate invoices...invoices using 3 different templates
using excel macro vb
||Apr 11, 2015
||Apr 11, 2015Ended
|LINK GIVEN DATABASE (ORACLE) TO ACCESS INTERFACE (VBA)
||...about linking your oracle tables from assigment 1 to an access interface. The oracle database and the design...everything in access mostly using the wizard and then i tried to link it to the oracle. Ofcourse it didn´t work...teacher wants all the forms implemented in vba WITHOUT using the wizard. Also told me something about unbound
||PHP, Visual Basic, Copywriting, Project Management, Engineering, Technical Writing, Software Architecture, Oracle, Microsoft Access, Software Testing, Academic Writing, Article Rewriting, MySQL, Anything Goes
||May 27, 2005
||May 27, 2005Ended
|378884 Excel + some VBA
||...I have an Excel file to be designed, which would contain 2 sheets with tables of some data (see example...it will change corresponding column/row values using some formula.
As a test task here's a small table
||Visual Basic, Anything Goes
||Jan 3, 2010
||Jan 3, 2010Ended
|Integrate Oracle Application with Excel using Java
||...JAVA MVC architecture
2. Good understanding of Excel Macro
3. Basic SQL knowledge
The candidate will...responsible to build integration between Microsoft Excel and Oracle Application. Below are the work highlights:
...push data from Excel SpreadSheeet to a table in Oracle Apps.
2. Develop sample code to read data from
||Java, Excel, Oracle
||Mar 13, 2014
||Mar 13, 2014Ended