Đã hoàn thành

VBA project

I have a workbook that captures certain data throughout the day. I'd like to capture the data in cells a1 and b1 on sheet 5 every minutes starting at 09:30:00 and ending at 16:00:00 for purposes of creating a daily chart. This data can be posted in cells c1:c?? and d1:d??. I currently run the below macro in this workbook.

Private Sub Workbook_BeforeClose(Cancel As Boolean)

On Error Resume Next

[login to view URL] dTime, "SortItOut", , False

On Error GoTo 0

End Sub

Private Sub Workbook_Open()

dTime = Time + TimeValue("00:00:05")

[login to view URL] dTime, "SortItOut"

End Sub

Public dTime As Date

Sub SortItOut()

dTime = Time + TimeValue("00:00:05")

[login to view URL] dTime, "SortItOut"

On Error Resume Next

With [login to view URL]

.Sort Key1:=.Range("B2"), Order1:=xlAscending, Header:=xlYes

.[login to view URL]

End With

With [login to view URL]

.Sort Key1:=.Range("B2"), Order1:=xlAscending, Header:=xlYes

.[login to view URL]

End With

With [login to view URL]

.Sort Key1:=.Range("B2"), Order1:=xlAscending, Header:=xlYes

.[login to view URL]

End With

On Error GoTo 0

End Sub

Kĩ năng: Lập trình C#, Excel, VB.NET, Visual Basic, Visual Basic cho Ứng dụng

Xem nhiều hơn: excel vba project 2007, lost vba project cognos, project status spreadsheet excel chart, vba project download, vba project ideas, vba project password, vba project word, vba project access, vba project references, this document cannot be closed because it is referenced by an open vba project, excel vba projects for practice, excel, visual basic, visual basic for apps, microsoft excel, excel vba project plan, simpl vba project, create vba project iports data csv, excel vba project search engine, find access vba project

Về Bên Thuê:
( 0 nhận xét ) Scotch Plains, United States

ID dự án: #17075793

Được trao cho:

sloker18

I am proficient with excel macro/VBA development, I can write the macro to read and populate the data at 5 minute interval, if possible, I would like to know more what changes do you want above your current macro, I am Thêm

$25 USD trong 1 ngày
(23 Đánh Giá)
4.0

9 freelancer chào giá trung bình$30 cho công việc này

cgullapalli

HI, I am good at Excel and vba. I have referred the requirement. Please share the file. Looking forward to work on the project. I can create button to start the process and stop the process. or automatically, the Thêm

$30 USD trong 0 ngày
(694 Nhận xét)
7.7
$25 USD trong 0 ngày
(332 Nhận xét)
7.7
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards

$25 USD trong 0 ngày
(198 Nhận xét)
6.8
abhinovpankaj

Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat Thêm

$35 USD trong 1 ngày
(61 Nhận xét)
5.7
carlosperezit

Hi there My name is Carlos and I'm an expert in .Net and sql server. I have been working in software developement for the last 20 years. I have many experience in desktop and web development. Regards

$35 USD trong 1 ngày
(47 Nhận xét)
5.5
FLinCanada

Love to give this a whirl! I have quoted 2 days to allow you to 'eyeball' an initial solution, and me to tweak the code as required. I can see a couple of approaches that may work, while allowing you to use the outpu Thêm

$19 USD trong 2 ngày
(20 Nhận xét)
4.1
$25 USD trong 1 ngày
(9 Nhận xét)
3.3
ibrahimder0

I have 6 year experience Freelancer,up work,Fiverr & 99design market place I have seen your project that i can to do easily because I have many experience to Graphic Design,Webdesign,Web Develop & programming .So I cou Thêm

$50 USD trong 1 ngày
(0 Nhận xét)
0.0