Refer to attached zip file. The [url removed, login to view] file links to 2 Excel files, 1 Access file and 1 SQL Server database. The SQL database can be restored from the [url removed, login to view] file, then linked using ODBC, DSN name = 'Calendar' The [url removed, login to view] file has a local table (called 'Connection') which can be used to determine the pat...
...8. MVC and WEB API 9. responsive web applications 10. SSRS 11. MySql 12. business analysis 13. Silverlight 14. mobile applications 15. Magento 16. MSACCESS / VBA 17. visual studio team services Being available every day between Monday to Friday and the first 5 skills are critical to have, the remaining are a plus. Most of the
I have developed more than 200 automations, using different platforms supported by VBA, Automation such as Excel to Excel, Excel to Access, Excel to Powerpoint, Web clawring, Excel to Mainframe. Key projects I have developed are enumerated below: 1. Quality Report for Finance, where data is taken from 5 different files, into a single consolidated
...guidance in EXCEL and VBA. Since this involves no assignment currently due by any recognised University or Institute this is not [url removed, login to view] are small part of ongoing work for a Rural Placement Training Cell, to help students prepare for Job skills. If you are not an expert, please IGNORE!!! The solutions must contain a detailed write-up, and Code
The solutions must contain a detailed write-up, and Code with Proof of code if necessary (Screenshots etc.). ❶ Vba Case study 2 is about 3 csv files that need to be connected to Excel 64 bit using excel drivers. Then after doing the stated computations (eg. Join/ Merge etc), fetch the solution, load the data ❷ Second is Sql. Again need to solve this
I have an excel spreadsheet where we need to have our sales people update a specific field every week. I would like to have a notification sent out to the user to remind him that a field is required to be filed base on a date that would be found in another column. Once the sales rep has entered the info, a time stamp of the information would be found
Hello I need a VBA code to import data from Word into a Excel in a certain format to upload it into my app. Each Word file has a variable number of question with multiple choice, always from A) throw E) and the word file has text, equations and some images. If the answer of the choice is zero, in the excel must show " '0 " otherwise the app don't recognize
Hello, I am looking for coding help. I have historical data for financial assets and want to build backtest of investment strat...performance and risk calculations (some parts could be done in matlab eventually). This project could take a few weeks ideally starting around 20/02/2018. I can adjust the fee as needed depending on progress and output.
Hi, I have a Microsoft Access 2016 database that will automatically close if there has not been activity for a set number of minutes. It detects when the focus changes from one form to another, or from one field to another field. What I need is new code that will watch not only for focus changes but also keystrokes- the current code doesn't know when a user has been typing in a single field a...
...someone really excellent in Excel and particularly MACRO /VBA. I need to create a DATABASE for the Quotation I receive from my suppliers. Internally I receive "DEMANDS OF QUOTATION" from someone (in Excel Format). I need the DATABASE to have some kind of a system (a button for example) to IMPORT the demand I receive in Excel format. the DATABASE
...the ability to blindtransfer to a number using TAPI. Current Excel spreadsheet that needs to be updated/worked on will be provided to people who show they have experience using the technologies needed to complete this task. Please talk about experience you have had with TAPI / Excel. TAPI API: [url removed, login to view]
I have an Excel file that has to be converted in to a Name/Value JSON format. Each column has Name in the first row and the Value in the following rows. There are 9 columns and 250 rows. In the last column I have the output that I need in the JSON format. However; I also want the code or formula that you use to create the output. All work must