Okay i recently got my code to work very well, thanks to help here in my earlier thread.
And i want to advance it one step further.
I would like to run my script on every .csv file and then produce a text file from it.
I already have the code to do it on 1 file, the file i open up and run the script on.
But i would like to do it without Excel opening, and just from a script, which seems to work from my searching.
I am currently using:
Which i pretty much copied from the net, and changed to suit my needs.
But it canīt run the Sheet1.sync script, i get an error.
Now my script is pretty messed up, and uses Userform (GUI), which i guess may mess up the VBA script from running, though i am not sure.
I will copy the codes here, if you see things that can be improved (which you probably will) then please post it as well.
Sheet1
UserForm1
Module11
Bookmarks