|SQL/ VBA Data Manipulation
||I have an excel file with some data and I want to perform some operations on it and then produce an output...job can be easily done in SQL Server or VBA. I would prefer SQL Server but VBA is also ok.
||PHP, Software Architecture, Software Testing, Visual Basic for Apps
||Feb 20, 2012
||Feb 20, 2012Ended
|SQL SERVER AND VBA ACCESS FUNCTION
||...millions of records (900 million rows)
Write SQL function and VBA function to do the following:
1. Sort Ascending...Actual_Datetime
3. In the Geography_Name_From Column, copy the second value B3 to the Geography_Name_To Column...See example in the sample data attached.
When I run the function in SQL Server 2010, it should do the above
||SQL, Microsoft Access
||Aug 21, 2013
||Aug 21, 2013Ended
|Excel VBA Conversion To .Net
||We have an Excel Spreadsheet that has VBA programming in it. It is a data validator and formatter. It...with a form, and prompts you to choose what type of data file validation and conversion.
1. NextGen to...either operation spits out 3 files.
We want this Excel spreadsheet to be converted to a .Net v2 compliant
||Visual Basic, .NET, Excel, SQL, Visual Basic for Apps
||Feb 22, 2013
||Feb 22, 2013Ended
|VB/VBA and SQL
||...The content in some of the files is caculated in excel via macroes before they are imported to access....to display the data in various ways. This does not have to be in Access. Some sort of SQL would be ok.... We already have MS SQL so this would be a preffered solution.The reporting and management should be
||PHP, Engineering, SQL, Software Architecture, Microsoft Access, Software Testing, Website Testing, MySQL, Visual Foxpro, Website Management, Web Hosting
||Dec 7, 2006
||Dec 7, 2006Ended
|Excel addin to copy data from Excel to SQL DB
||...familiar with COM Excel addin programming in C# (not VBA)
The addin will sync data from Excel spreadsheet...spreadsheet to an SQL database (one way).
Detailed requirements located in an attached file.
||C# Programming, Software Architecture
||Nov 29, 2011
||Nov 29, 2011Ended
||Data Processing, Excel
||Aug 27, 2014
||Aug 27, 2014Ended
|SQL SERVER AND VBA ACCESS FUNCTION - Rehire
||...I love your work and I need a similar code in SQL SERVER 2010 and MS Access.nnPlease see requirements...Sort by Rec_ID Ascendingn4. In Direction_01 Column, copy the D4 to Direction_02 Column E3, n5. D5 to E4,...again. See row 141. The value of row E141 must not copy to D140 because the equip_no is different. The processes
||SQL, Microsoft Access,
||Aug 26, 2013
||Aug 26, 2013Ended
|Copy SQL Server Data
||...to make a copy of a database if both are on the server). What I need is to be able to copy a database...one source to another and either the source is a server file or the source is a file attached but being
||Visual Basic, .NET
||May 26, 2011
||May 26, 2011Ended
| Excel VBA : lookup and copy data
* EXCEL VBA script
'wait 3 minutes for data to process
'select the 'Export search results o excel' link
( this code is not accurate)
||PHP, Project Management, Engineering, Software Architecture, Software Testing, MySQL
||Feb 23, 2010
||Feb 23, 2010Ended
|control mouse with vba/excel
||...some help getting data into excel from another application. Would like to have excel/vba macro change focus...to select/copy data to paste into an Excel Worksheet. Then loop & do again, etc. The data in the other...select/copy it. The other application is not a Microsoft application. I can work with VBA/Excel OK bu...
||PHP, Visual Basic, Engineering, Software Architecture, Software Testing, MySQL
||Oct 9, 2004
||Oct 9, 2004Ended
|Excel VBA: HTTP and Charts
||...exploratory project to download data and chart setting from a web-server.
Please consider bidding...experience of the needed VBA techniques.
**VBA Excel: HTTP Downloads and...a chart whose specification and data are downloaded from a web-server.
The user is given a workbook
||Windows Desktop, Software Architecture
||Nov 5, 2012
||Nov 5, 2012Ended
|VBA Excel Macro
||...create a folder tree and copy files according to an excel list of paths.
- a tree structure...and files and the path to this structure.
- an excel sheet listing all the files of the tree structures...for instance: c:myfolderpathfile1.rtf
The excel contain several columns. Two are important in this
||PHP, Perl, Java, Visual Basic, Excel
||May 17, 2009
||May 17, 2009Ended
|Excel with VBA
||We need one excel file which should have many validations and many sheets, which will get the information...log and image upload in the server and image rename functionality and SQL update in the database
||Visual Basic, Data Processing, Excel, Visual Basic for Apps
||Mar 22, 2015
||Mar 22, 2015Ended
||...a lot of data and some columns are calcs (a1:cc12000).
Need someone to create a few VBA macros/forms...macros/forms that will sort this data and output into a few variations into? new worksheet in same file as well...well as different excel file.
Addendum (8/10/08) -
Specifically on sheet data! for any row where
||PHP, Engineering, Software Architecture, Software Testing, MySQL
||Aug 8, 2008
||Aug 8, 2008Ended
|VBA Excel with SQL - Near Kerala
||...be reviewed and components written in VBA connecting to SQL server. We need the programmer to be located
||Jun 22, 2011
||Jun 22, 2011Ended
|Excel VBA Project
||We need a VBA pro to write a fairly simple macro for us. It will basically open an external spreadsheet...spreadsheet and copy a range of cells (actual values, not formulas) into the current spreadsheet.
It will...this for (5) separate spreadsheets. The retrieved data will be stacked on the current spreadsheet and a
||PHP, Engineering, Software Architecture, Software Testing, Website Testing, MySQL, Website Management, Web Hosting
||Feb 2, 2005
||Feb 2, 2005Ended
|Excel Spreadsheet - Insert/Update SQL Server Not dBase
||...have an Excel Spreadsheet which reads cells, then checks a foxpro dBase database if the data exists and...REPLACED with a SQL Server 2005 instance and so the VBA must be adjusted to read the SQL Server Database.
The changed VBA must therefor:
1) Setup the Connection to the SQL Server
2) Check is the reco...
||Visual Basic, .NET
||Mar 29, 2011
||Mar 29, 2011Ended
|VBA expert in Excel
||...does the following:
- Uses certain cells in an Excel workbook as merge fields to populate into Outlook...certain files referenced in the Excel workbook, and upload them to an FTP server.
Our current developer...To apply, you MUST be:
- An expert with VBA in Excel
- Fluent in English and open to talking by
||Visual Basic for Apps
||Aug 22, 2014
||Aug 22, 2014Ended
|VBA in excel
||...individualized invoices for a retail sales company. The input data will consist of a customer database file which contains...orders data file with customer ordering information (item number and amount); and a products data file...information and will be captured and saved to an Excel databases that will be displayed at user request
||Visual Basic, Excel
||Apr 5, 2014
||Apr 5, 2014Ended
|Excel VBA coder required
I want a Excel VBA coder to create a copy of the spreadsheet attached. You will need to use a...the text as it is.
You will need to create vba code so that users can customize it with their own...coming up. It must work on all versions of Excel
All vba code must be documented very well and in
||PHP, Windows Desktop, Engineering, Software Architecture, Software Testing, Microsoft, MySQL, Visual Basic for Apps
||Oct 15, 2008
||Oct 15, 2008Ended