Đã Trao

Quick Excel VBA routine

I need a quick VBA routine written into a spreadsheet. Functionality as follows:

1. Read a certain column cell by cell downwards till the end of the data and copy all the values into a variable as a single string. (This is a SQL statement per screen shot)

2. Execute the SQL statement against an Oracle database (connection string to be hardcoded)

3. Put the resulting recordset, row by row, into sheet 1 from a predefined starting row.

I anticipate this is a quick 2hr task for someone who has the right skillset.

Kĩ năng: Nhập liệu, Xử lí dữ liệu, Excel, Visual Basic, Visual Basic cho Ứng dụng

Xem nhiều hơn: vba excel 2016, vba excel download, useful vba codes for excel, vba excel functions, vba excel pdf, vba excel examples, excel vba programming pdf, vba excel 2013, excel vba and pivot table 2, excel vba and pivot table -- 2, excel vba xml file, excel vba cut paste cells, excel vba dashboard, excel vba macro paste adjacent column, simple excel vba

Về Bên Thuê:
( 0 nhận xét ) Benfleet, Vietnam

ID dự án: #16718502

1 freelancer đang chào giá trung bình $20 cho công việc này


Hired by the Employer

$20 USD trong 1 ngày
(247 Nhận xét)