Comment Import
Mark,
Thank you for your answer. So, I can import comments also programmatically. But I want to ask you, whether you know a tool to do this ? Otherwise, I have to be bothered with it since I did not write code for excel. Thank You Omur Olmez |
Comment Import
Hello
About this topic, an idea comes to my mind : I will create an Excel VBA. In an event, I'll add some code like this : dim n as integer for n=1 to LastRowNumber Worksheets("Sheet1").Cells(n, 8).Value = _ Worksheets("Sheet1").Cells(n, 3).Comment.Text next What I want to do is retrieving comments into new cells. So, I can easily import them by using SQL's tools. But I have some problems about this method : * How can I check if there is a comment in a specific cell. I want to do this because, Error 91 occurs if there is no comment in the cell when I try to retrieve it. * How can I use the application/code on some other excel documents. I wonder this because as I know, the VBA code is inserted directly into working .xls file. By the way, the Mark's code did not run : strComment = Sheets(1).Cells(5, 3).Comment.Text I use this code instead of Mark's : Worksheets("Sheet1").Cells(n, 3).Comment.Text Thank You For Your Helps Omur Olmez |
All times are GMT +1. The time now is 10:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com