Specifying range of values to save to excel vb6 environment

Asked By Christine Cummings 40 points N/A Posted on - 11/21/2012

When and how does one specify the range of values to save to excel vb6 without explicitly declaring the cell numbers in an order dictating the sequence to follow?

 

• Status: Open
• Question Views: 884
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Visual basic

Answered By Shifflett Laurel 0 points N/A #197886

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.

 

Best Wishes

 

Shifflet Laurel

About Shifflett Laurel

Questions
2

Answers
154

Best Answers
78

• Vote Up 0 Vote Down

• Posted on - 01/19/2013
• Question Category: Visual basic