Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a Little Help
I'm not sure if this is the right forum, but here goes:
I have an excel file that runs several macros (lets call it File1). need to create another file that will have "text" information tha depends on the day of the month (lets call it File2). I'd like to create macro or VB script that will copy data from File and put it in File1. Even better and heres my ultimate dream: when the data in file2 goes t file1 it is in 'Comment' form... Can anyone help -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a Little Help
File1 exists
File2 needs to be created (but what it will or could contain is not stated) but you want a macro that copies from File2 (which doesn't exist). Not sure what comment format is unless you mean you want your data to all be text. For me at least, you problem is too ill defined to attempt to suggest anything. -- Regards, Tom Ogilvy "alexm999 " wrote in message ... I'm not sure if this is the right forum, but here goes: I have an excel file that runs several macros (lets call it File1). I need to create another file that will have "text" information that depends on the day of the month (lets call it File2). I'd like to create macro or VB script that will copy data from File2 and put it in File1. Even better and heres my ultimate dream: when the data in file2 goes to file1 it is in 'Comment' form... Can anyone help? --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a Little Help
File2 exists and is called 'Deviation' and file1 is called 'Evaluation'
In cell A1 from file2, i'd like anything in that cell to be copied o moved to cell B2 in file1. Both workbooks will be open -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a Little Help
workbooks("Evaluation").worksheets("Sheet1").Range ("B2").Value = _
workbooks("Deviation").Worksheets("Sheet2").Range( "A1").Value -- Regards, Tom Ogilvy "alexm999 " wrote in message ... File2 exists and is called 'Deviation' and file1 is called 'Evaluation' In cell A1 from file2, i'd like anything in that cell to be copied or moved to cell B2 in file1. Both workbooks will be open. --- Message posted from http://www.ExcelForum.com/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a Little Help
OK, thats the step in the right direction.
Now, i'm almost there... When you right click on a cell, you are given an option to enter 'Comment' for that cell. Im trying to copy something from one workboo into another workbook comment. ANy help -- Message posted from http://www.ExcelForum.com |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a Little Help
Here's My Code:
Windows("Deviation.xls").Activate Range("C1").Activate Selection.Copy Windows("EVALUATION.xls").Activate Application.CutCopyMode = False Range("M9").AddComment Range("M9").Comment.Visible = False Range("M9").Comment.Text Text:="Alex:" & Chr(10) & "" I'm having dificuly copying and pasting into the comment field.. Can you help -- Message posted from http://www.ExcelForum.com |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a Little Help
Dim sVal as String
Windows("Deviation.xls").Activate Range("C1").Select sVal = Selection.Text Windows("EVALUATION.xls").Activate Range("M9").AddComment Range("M9").Comment.Visible = False Range("M9").Comment.Text Text:="Alex:" & Chr(10) _ & "" & sVal -- Regards, Tom Ogilvy "alexm999 " wrote in message ... Here's My Code: Windows("Deviation.xls").Activate Range("C1").Activate Selection.Copy Windows("EVALUATION.xls").Activate Application.CutCopyMode = False Range("M9").AddComment Range("M9").Comment.Visible = False Range("M9").Comment.Text Text:="Alex:" & Chr(10) & "" I'm having dificuly copying and pasting into the comment field.. Can you help? --- Message posted from http://www.ExcelForum.com/ |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a Little Help
See one more response at your other post.
"alexm999 <" wrote: I'm not sure if this is the right forum, but here goes: I have an excel file that runs several macros (lets call it File1). I need to create another file that will have "text" information that depends on the day of the month (lets call it File2). I'd like to create macro or VB script that will copy data from File2 and put it in File1. Even better and heres my ultimate dream: when the data in file2 goes to file1 it is in 'Comment' form... Can anyone help? --- Message posted from http://www.ExcelForum.com/ -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|