wedd
02-15-2012, 07:09 AM
Hi experts,
Is it possible to automatically removes spaces, commas, and delimiters using visual basic code when data from a txt files, csv.files etc has been imported into Excel?
Once that is done I will like to devise a system for importing and reconfiguring the data automatically or semi-automatically (people running macros for example). Can this be done, if so how? Would you have any examples of code, strategies you may worked on in a similar project or websites? I am a beginner/intermediate user of visual basic, so the sources or information you display to me will be very useful...:friends:
Thanks for your contributions :friends:
Is it possible to automatically removes spaces, commas, and delimiters using visual basic code when data from a txt files, csv.files etc has been imported into Excel?
Once that is done I will like to devise a system for importing and reconfiguring the data automatically or semi-automatically (people running macros for example). Can this be done, if so how? Would you have any examples of code, strategies you may worked on in a similar project or websites? I am a beginner/intermediate user of visual basic, so the sources or information you display to me will be very useful...:friends:
Thanks for your contributions :friends: