Specifying range of values to save to excel vb6 environment

Hellow Christine Cummings,

I have got the point of your interest.

I have researched implicitly about the matter and finally I have reached to the correct approach.

You have to create an excel workbook by importing a text file and separating the file into cells in worksheet 1. You should have two additional worksheets which contain information which has been obtained from different databases. The last worksheet is a column of values which you used the concatenate function to create. Each row within the column will be separated by commas and a semicolon at the end for the record delimiter.

Ideally, I would like to recommend to do the following:

1. Copy a range of cells based on all of the concatenated cells.You have a cell which counts all of the cells which have actual data.
2. Open a text file
3. Paste the information into the text file.
4. Save the text file to a shared drive with a file name indicating where it came from and what date it was completed.

Techyv is one of the leading solution providers covering different aspects of Computers and Information Technology. We have a hardworking team of professionals in different areas that can provide you with guaranteed solutions to a blend of your problems. We have a dedicated and devoted team of professional writers with multi-dimensional experience of several years. As a result, we produce quality content on a variety of subjects.