Notes tests, text files, manipulation of text files in Excel and with Excel VBA CSV stuff

[DocAElstein]

In support of this Thread
https://www.ozgrid.com/forum/index.p...23#post1241623

Before
_____ Workbook: Sample excel file.xls ( Using Excel 2007 32 bit )

Row\Col	A	B	P	Q	R	S	T	U	V	W	X	Y
2			15	16	17	18	19	20	21			27
3		SLA	Su	M	T	W	Th	F	S	Su	M	T
4	RunbookBCompletionTime	6:00AM
5	ActiveProducts	N/A
6	ActiveSKUs	N/A
7	Pending	N/A
8	Completed	N/A
9	CompletedOrderCount	N/A
10	PendingOrderCount	N/A
11
12
13	Active
14

Worksheet: Sheet1
http://i.imgur.com/jrBBlXT.jpg

text file: Sample.txt

---------------------------------------------------- 
This is a  report for last week 
---------------------------------------------------- 
 
Date,RunbookBCompletionTime 
20201116,05:44 AM
20201117,05:47 AM
20201118,05:39 AM
20201119,06:10 AM
20201120,05:49 AM
20201121,07:13 AM
20201122,06:01 AM
 
Date,ActiveProducts 
20201116,24
20201117,244
20201118,245 
20201119,24 
20201120,249 
20201121,250 
20201122,250 
 
Date,ActiveSKUs  
20201116,137
20201117,13
20201118,13
20201119,1368
20201120,13
20201121,1381
20201122,13
 
Date,CompletedOrderCount 
20201116,24
20201117,24
20201118,3
20201119,24
20201120,63
20201121,69
20201122,8
20201123,9
 
Date,PendingOrderCount 
20201116,18
20201117,5405
20201118,6114
20201119,6
20201120,6482
20201121,74
20201122,128
20201123,4

After runningSub LookInAndImportTextStringSample()
https://i.imgur.com/0m881xs.jpg
_____ Workbook: Sample excel file.xls ( Using Excel 2007 32 bit )

Row\Col	P	Q	R	S	T	U	V	W	X	Y
2	15	16	17	18	19	20	21			27
3	Su	M	T	W	Th	F	S	Su	M	T
4		05:44	05:47	05:39	06:10	05:49	07:13	06:01
5		24	244	245	24	249	250	250
6		137	13	13	1368	13	1381	13
7
8
9		24	24	3	24	63	69	8	9
10		18	5405	6114	6	6482	74	128	4
11
12

Worksheet: Sheet1

---

Share ‘Sample excel file.xls’ : https://app.box.com/s/hw4uxwjlm8t8zty17kc07xihq0bfhifs
Share ‘Sample excel file.xlsm’ : https://app.box.com/s/ccmk5sgazueejb4dc0eqw6yex0zhjar2