Hi everyone,
I'm struggling with this for several weeks now. I hope someone can help me out. I have a feeling it's possible but it's quite challenging.
For my job I must put article data in Excel file and enrich/adjust it. I have created a Template for this with several macro's. When this is done and it's complete I must upload it in our system. The system can only read macro files. But here is the thing: it only reads CSV's with the data still devided over the columns and rows. I know this is not really where CSV stands for (comma seperated) but there is now other way to read the data in the system. For that I call it "semi convert into CSV file"
I press after each completed file F12>select CSV divided by list seperation>input title (usually "UPLOAD" or "CSV")>save>then click "Yes".
For this step i really want to create a macro which does the same thing in the background and creates a (semi)CSV file in the same folder as the original Excel template. The folder of the Excel template is always different so the path must be dynamic. For example: when I have 3 brands to upload I create 3 folders for these brands for a certain season. I put a copy of the empty Excel template in each folder and then I edit and save them individually for importing in the system. The CSV file can stay closed. It would be nice if the original Excel file stays open.
I already saw a similar thread (I even think it's the only one) but unfortunately it's nog quite the thing I'm looking for.
Save excel macro file as .csv with date to same folder as original file (VBA)
Could someone please help me out to make this very difficult thing happen? I would be very grateful!
Thanks in advance.
I'm struggling with this for several weeks now. I hope someone can help me out. I have a feeling it's possible but it's quite challenging.
For my job I must put article data in Excel file and enrich/adjust it. I have created a Template for this with several macro's. When this is done and it's complete I must upload it in our system. The system can only read macro files. But here is the thing: it only reads CSV's with the data still devided over the columns and rows. I know this is not really where CSV stands for (comma seperated) but there is now other way to read the data in the system. For that I call it "semi convert into CSV file"
I press after each completed file F12>select CSV divided by list seperation>input title (usually "UPLOAD" or "CSV")>save>then click "Yes".
For this step i really want to create a macro which does the same thing in the background and creates a (semi)CSV file in the same folder as the original Excel template. The folder of the Excel template is always different so the path must be dynamic. For example: when I have 3 brands to upload I create 3 folders for these brands for a certain season. I put a copy of the empty Excel template in each folder and then I edit and save them individually for importing in the system. The CSV file can stay closed. It would be nice if the original Excel file stays open.
I already saw a similar thread (I even think it's the only one) but unfortunately it's nog quite the thing I'm looking for.
Save excel macro file as .csv with date to same folder as original file (VBA)
Could someone please help me out to make this very difficult thing happen? I would be very grateful!
Thanks in advance.
