Solved

have a comment inserted into an excel spreadsheet using VB

Posted on 2007-11-27
2
760 Views
Last Modified: 2012-08-13
I want to insert a comment into a file that instructs the user to click on insert and then function/standard deviation.
The code as it is:

Set objExcel = CreateObject("Excel.Application")
 

objExcel.Visible = True

objExcel.Workbooks.Add

objExcel.Comment.Add "My comment"

objExcel.Cells(1, 1).Value = "Date"

objExcel.Cells(1,2).Value = "Student"

objExcel.Cells(1,3).Value = "Wk1"

objExcel.Cells(1,4).Value = "Wk2"

objExcel.Cells(1,5).Value = "Wk3"

objExcel.Cells(1,6).Value = "Wk4"

objExcel.Cells(1,7).Value = "Wk5"

objExcel.Cells(1,8).Value = "Wk6"

objExcel.Cells(1,9).Value = "Wk7"

objExcel.Cells(1,10).Value = "Wk8"

objExcel.Cells(1,11).Value = "Mean"

objExcel.Cells(2,11).Value = "=SUM(A3:A10)/8"

objExcel.Cells(1,13).Value = "Click on insert on taskbar then choose function and add the formula for the standard deviation and then copy and paste into the cells below"

objExcel.Cells(3,11).Value = "=SUM(A3:A10)/8"

objExcel.Cells(4,11).Value = "=SUM(A3:A10)/8"

objExcel.Cells(5,11).Value = "=SUM(A3:A10)/8"

objExcel.Cells(6,11).Value = "=SUM(A3:A10)/8"

objExcel.Cells(7,11).Value = "=SUM(A3:A10)/8"

objExcel.Cells(8,11).Value = "=SUM(A3:A10)/8"

objExcel.Cells(9,11).Value = "=SUM(A3:A10)/8"

objExcel.Cells(10,11).Value = "=SUM(A3:A10)/8"

objExcel.Cells(11,11).Value = "=SUM(A3:A10)/8"

objExcel.Cells(12,11).Value = "=SUM(A3:A10)/8"

objExcel.Cells(13,11).Value = "=SUM(A3:A10)/8"

objExcel.Cells(14,11).Value = "=SUM(A3:A10)/8"

objExcel.Cells(15,11).Value = "=SUM(A3:A10)/8"

objExcel.Cells(16,11).Value = "=SUM(A3:A10)/8"

objExcel.Cells(17,11).Value = "=SUM(A3:A10)/8"

objExcel.Cells(18,11).Value = "=SUM(A3:A10)/8"

objExcel.Cells(19,11).Value = "=SUM(A3:A10)/8"

objExcel.Cells(20,11).Value = "=SUM(A3:A10)/8"

objExcel.Cells(21,11).Value = "=SUM(A3:A10)/8"

objExcel.Cells(22,11).Value = "=SUM(A3:A10)/8"

objExcel.Cells(23,11).Value = "=SUM(A3:A10)/8"

objExcel.Cells(24,11).Value = "=SUM(A3:A10)/8"

objExcel.Cells(25,11).Value = "=SUM(A3:A10)/8"

objExcel.Cells(26,11).Value = "=SUM(A3:A10)/8"

objExcel.Cells(27,11).Value = "=SUM(A3:A10)/8"

objExcel.Cells(28,11).Value = "=SUM(A3:A10)/8"
 

objExcel.Cells(1,12).Value = "S.D"

Open in new window

0
Comment
Question by:Dier02
2 Comments
 
LVL 26

Accepted Solution

by:
EDDYKT earned 500 total points
Comment Utility
change
objExcel.Comment.Add "My comment"

to

objExcel.range("a1").addcomment
objExcel.range("a1").comment.Text Text:="My Comment"
0
 

Author Comment

by:Dier02
Comment Utility
comes up with error if I copy it into notepad as save as a .vbs file then double click on it to run.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now