Small VBA script

$10-30 USD

Completed

Posted

almost 7 years ago

$10-30 USD

Paid on delivery

write a small VBA script using the base code supplied to copy existing xls file to new xls file using time and date as file name Private Sub Trigger_Excel_Change() 'On Error GoTo ErrorHandler Dim ObjExcelApp As Object Dim Fname As String Fname = "C:\Access_DB\[login to view URL]" 'name of already created excel project Set ObjExcelApp = CreateObject("[login to view URL]") [login to view URL] = False 'make run in background [login to view URL] (Fname) [login to view URL] [login to view URL] Set ObjExcelApp = Nothing 'Error_handler 'LogDiagnosticsMessage [login to view URL] & " " & [login to view URL], ftDiagSeverityError End Sub

Programming

Project ID: 13837762

About the project

4 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@rumarahman

$20 USD in 1 day

0.0

(0 reviews)

0.0

4 freelancers are bidding on average $27 USD for this job

@asin1987

Bid Summary Dear Employer, I will automate the process for you using VBAs and MAcros. Please find attached my previous work samples. Please let me know if we can discuss further on this. Project Requirements I will do it dont worry .. I know how to do it Relevant Skills and Experience VBA macro excel C# Proposed Milestones $35 USD - VBA Project

$35 USD in 1 day

0.0

(0 reviews)

0.0

@expertatwork

simple!

$29 USD in 1 day

0.0

(0 reviews)

0.0

@Ibrahimy1975

Bid Summary Hello I want to know what do you want first in details from this function to work for it and if you want to just read file and put into new one by naming it using dat time , it may be done by another Project Requirements you want to make a new copy from excel file to a new one each time and rename the file using date time when copy Relevant Skills and Experience VB6, VB.net , C# , Access, sql server , mysql , DataReport in VB6 , Report Viewer, Crystal report . hospital, Civil Engineering software, pharmacy , stores & accounting, Pharma Stores , Employees Proposed Milestones $25 USD - work and deliver I want the details for this task

$25 USD in 1 day