VBA, i want to import a txt file to excel and I want it to be reorganized to a specific format [on hold]

Multi tool use
Multi tool use


VBA, i want to import a txt file to excel and I want it to be reorganized to a specific format [on hold]



I have a txt file in the format below ,I want to import it to excel and I want it to be reorganized using Vba code.




Timestamp : ##/##/## ##:##:## ## PM
File # : ####
Type : LLLLLL
Range : #####:#####-#####/#(#-###) #####:#####-#####/#(#-###) #####:#####-#####/#(#-###) #####:#####-#####/#(#-###) #####:#####-#####/#(#-###)
Stat : N/A
________________________________________________________________________
Timestamp : ##/##/## ##:##:## ## AM
File # : ####
Type : LLLLLL
Range : #####:#####-#####/#(#-###) #####:#####-#####/#(#-###) #####:#####-#####/#(#-###) #####:#####-#####/#(#-###) #####:#####-#####/#(#-###) #####:#####-#####/#(#-###) #####:#####-#####/#(#-###) #####:#####-#####/#(#-###)
Stat : N/A
________________________________________________________________________
.
.
n



Repeated "n" times , "n" changes daily



and I would like to import it to excel reorganized to the following format using VBA;




Col1 Col2 Col3 Col4. . . .etc
Row1 Time Stamp File # Type Range
Row2 ##/##/## ##:##:## ## PM #### LLLL .................etc
Row3 ##/##/## ##:##:## ## AM #### LLLL .................etc
.
.
etc



Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.





Welcome to Stack Overflow! This is a site where programmers write their own code and share issues with a specific problem after trying to solve it on their own. If, after doing more research, you have a specific problem, please edit your post to share examples of your code and relevant data and some background info. Some good reading to get you started: "How to Ask" as well as tips here and here.
– ashleedawg
Jun 30 at 17:32




utr2yLRWnLZ8gWhy
-
d,FANR5 j1miqPdv ZRMWNr

Popular posts from this blog

PySpark - SparkContext: Error initializing SparkContext File does not exist

Image
PySpark - SparkContext: Error initializing SparkContext File does not exist I have small piece code in PySpark, but I keep getting errors. I'm new to this so im not sure where to start. from pyspark import SparkContext, SparkConf conf = SparkConf().setAppName("Open json").setMaster("local[3]") sc = SparkContext(conf = conf) print("Done") I ran this in cmd with the command : spark-submit .PySparkOpen.py I then get the following error statement: C:UsersAbdullahDocumentsMaster Thesis>spark-submit .PySparkOpen.py 18/06/30 15:21:58 WARN NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-Java classes where applicable 18/06/30 15:22:01 ERROR SparkContext: Error initializing SparkContext. java.io.FileNotFoundException: File file:/C:/Users/Abdullah/Documents/Master%20Thesis/PySpark/Open.py does not exist at org.apache.hadoop.fs.RawLocalFileSystem.deprecatedGetFileStatus(RawLocalFileSystem.java:611) at...
Read more

django NoReverseMatch Exception

django NoReverseMatch Exception I'm getting the following error while using hyperlink in Django. Error : django.urls.exceptions.NoReverseMatch: 'mywebapp' is not a registered namespace django.urls.exceptions.NoReverseMatch: 'mywebapp' is not a registered namespace mywebapp/template/about.html .. <body> <a href="{% url 'mywebapp:home' %}">Click here</a> Hello World!!!<p>Today is {{today}}</p> mywebapp/template/home.html .. <h4>Homepage.</h4> settings.py .. INSTALLED_APPS = [ ... 'mywebapp'#new ... ] Make sure you have app_name='home' in your mywebapp/urls.py . If that doesn’t solve the problem, then you need to show your urls.py . – Alasdair Jun 30 at 20:20 app_name='home' mywebapp/urls.py urls.py ...
Read more

List of Kim Possible characters

Image
From left to right: Wade (on monitor screen), Dr. James Timothy Possible, Mrs. Dr. Ann Possible, Ron, Rufus, Kim Possible, Shego, Dr. Drakken, Monkey Fist, Señor Senior Sr., Adrena Lynn, and Señor Senior Jr. This is a list of characters appearing in the animated series Kim Possible . Team Possible Kim Possible Main article: Kim Possible (character) Voiced by: Christy Carlson Romano and Dakota Fanning (Preschool Kim; Kim Possible: A Sitch In Time ) Kimberly Ann “Kim” Possible is a crime fighter and high school cheerleading captain who saves the world on a regular basis while dealing with the normal challenges of being a teenager, such as winning cheer competitions, turning in her homework on time, and maintaining a love life. Her name is a play on the word “impossible.” Kim has known Ron Stoppable, her sidekick for most missions, since preschool. She has also completed missions with Wade, Monique, her brothers, and even her mother. In season four, Kim and Ron end up developing romanti...
Read more