Free for PREMIUM members
Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium
Dim wks As Object 'DOES NOT WORK
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
objExcel.DisplayAlerts = True
Set wbk = objExcel.Workbooks.Add
Set wks = wbk.Sheets.Add
.Name = "ProjectData"
.Range("A1").Value = "WorkDate"
.Range("B1").Value = "LastName"
.Range("C1").Value = "FirstName"
.Range("D1").Value = "ProjectName"
.Range("E1").Value = "WorkTime"
.Range("F1").Value = "PayRate"
.Range("G1").Value = "PayTotal"
.Range("H1").Value = "Notes"
Open in new window
Author Closing Comment
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
If you are experiencing a similar issue, please ask a related question
Join the community of 500,000 technology professionals and ask your questions.
Join & Ask a Question
Join our community for more solutions or to ask questions.
For immediate help use Live now!