I have a question about changing from a format of .csv to .xlsx.
First off maybe some advice would be helpful, too.
I have a directory with a bunch of .csv files that I would like some vba to quickly change these to .xlsx.
The reason is I want to run a script I have against the list of each one that I review to clean out text items that need to be removed.
Is there a best practice to have a vba macro available on every spreadsheet I open. Currently when I struggle and piece some working code together it only works on that one sheet. I would like it in some cases to be universal to all my excel sheets so I can do a keyboard command and quickly run it.
I know there is two question here but if I can get some direction I would greatly appreciate it
Thank you
First off maybe some advice would be helpful, too.
I have a directory with a bunch of .csv files that I would like some vba to quickly change these to .xlsx.
The reason is I want to run a script I have against the list of each one that I review to clean out text items that need to be removed.
Is there a best practice to have a vba macro available on every spreadsheet I open. Currently when I struggle and piece some working code together it only works on that one sheet. I would like it in some cases to be universal to all my excel sheets so I can do a keyboard command and quickly run it.
I know there is two question here but if I can get some direction I would greatly appreciate it
Thank you
