Remote Network And System Administration Job In IT And Networking

EXCEL VBA SQL DATA WORK

Find more Network And System Administration remote jobs posted recently Worldwide

Hi,
I am looking for someone to build me a custom spreadsheet.
Should have a small section for:
Server Name:
ID & Password(should hide password) and checkbox to connect with Windows Credentials.
Drop down for what database on the server named above it should run query
Query Box or drop down for stored procedures with From & Two dates and box for extra criteria
Check box Ability to Run Query (Type in ) or Stored Procedure (Drop Down)
1 Text box to run query so If I wanted to type in the above it would work exec procRptMySP.....
2 Stored procedure drop down populate list from selected database From and Two dates extra criteria text box that will append on end of query so I could type 1, -1 in box.
Ability to click a checkbox to run stored procedure on all databases(or select if we make the databases checkable) and join by union since all fields should be the same.
About the recuiter
Member since Aug 30, 2017
Dylan
from Bergamo, Italy

Skills & Expertise Required

Excel Excel VBA sql VBA VBScript 

Candidate shortlisted and hiredHiring open till - Nov 17, 2021

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$173.72

Cost

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Similar Projects

Created and modify features in symfony

We need to update some features that we have in an application developed in Symfony.

Microsoft SQL Server and Access Developer needed

I need someone that is proficient in VBA for Access and Excel. The person also must also have experience in writing SQL code and installing SQL Server express edition on a server and make the database visible via odbc connections on clients machine...read more

Setup (MSI or similar) routine for an MS Office application

We have an MS Access based departmental application which needs to be installed and reinstalled on multiple workstations.
We are looking for automated routine to check requirements and install the application.
Requirements include:
Pre-Se...read more

R Developer

Im a data scientist and Im looking for an R developer (not an analyst or statistician).

You can write clear and efficient R code, you have experience with the tidyverse (primarily dplyr and purrr), and you know your way around relational d...read more