Data Import into Cell comment from text file import/query?

[limester]

Hi All,

I have many text files that contain data from many workstations that I would like to Import into Excel as a cell comment due to its long worded format.

I have prepared a directory called 'workstations' within this directory I created a batch that would connect to all workstations, create a folder based on the IP, and drop the files into this folder. Since this format is consistent, could I also create some type of batch that could do many imports this way?

I have made some progress so far, but I am in need of some assistance.

I have turned on the Macro recorder to see what VBA code is created when adding a comment, and also when Importing data from a text file.

I have attempted to add the .AddComment to the code from the import but this is not working.

If anyone can provide some pointers I would greatly appreciate it. I want to do the work, but I am afraid I do not have the level of knowledge to complete the task. If anyone would be willing to give a small level of guidance I would be very grateful.

Cheers.

 

[SkipVought]

Hi,

The Data Import feature puts the data on a SHEET.

Just read the rows into a string variable in a loop, and then assign it to the Comment Box.


Skip,

_{[red]Be Advised![/red]
A wee deranged psychic may be runnin' around out there!
SMALL MEDUIM @ LARGE}

 

[limester]

Hi SkipVought,

Thank you for your reply. I am afraid I am probably way out of my league to attempt this. My level of knowledge in this area is very basic.

Do you know of any online resources that could bring up to speed to create these options you mentioned.

Cheers