Jump to content
Can't remember your login details? Read more... ×
Sign in to follow this  
twinair

VB script request

Recommended Posts

I have an Excel spreadsheet where I want the data from each row to be exported into a folder\file called C:\%USER_NAME%\filename.cfg where username is a folder with a unique username

 

For example, this is the data in the rows. All I want is each row to be extracted and put inside a separate txt file and then be renamed to filename.cfg.

 

Row1 - #;s=mobile.gateway;p=5001;c=0;u=user1;a=6z6;#

Row2 - #;s=mobile.gateway;p=5001;c=0;u=user2;a=2T9;#

Etc etc

 

Is this possible?

I assume it would only be a few lines worth of code?

Is VB even the right way to do this?

Suggestions?

I suck at teh programming, I just know what I need as the end result, not sure how to get there though.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×