VBA Assistance - Export CSV with Version number

Hello Excel Experts,

I have a bit of a problem - and I have 75% of the solution.

I have an excel sheet that I am using to save certain values when entered into a CSV and I am using a formula in the cells to produce the sheet only if a cell has a value.

I actually have 2 VB Macros that I found and both seem to work but give different results. The first VB script works great for the version counting but it displays many ,,,,,, at the end of the file.

That VB looks like this

Please Login or Register  to view this content.

The second which is a much simpler script gets me the output I am looking for and only looks to the cells that actually have values entered and skips over the ones with the formula =IF(ISBLANK(...) etc.

That code is

Please Login or Register  to view this content.

My question is how can I get the best of both worlds here and get the script to just pull the values like in VB 2 but still save using the _Vx version counting saving.

Thank you so much as always in advance.

Thank you for your reply and help with this.

I tested out your macro, and it seems to work only on the sheet where the user enters the data that they want to configure. On the 2nd sheet where I have my formula, when I run the macro, it does not see the formula values (which is good) but it also does not see the values being added from where the user enters the data.

Secondly, your script does not present the user with a popup displaying the version number that was created.

And how can the file be saved to the same directory that the .xlsm is being launched from?

I inserted the macro code as a new module and when I run it on sheet 1 - it exports sheet 1 with that data on sheet 1 (in correct format for my csv).

When I run the macro and I am on sheet 2 - the export is blank.

Thank you for this! 99.99% of the way there.

This does give me the export of the data in csv with the correct format- but is there any way to not have all the enters or extra lines at the bottom- so if one were to enter 4 or 5 items, the csv is showing 100 lines.

Hi- no that's not exactly what I meant.

For example, in the 1st post, the 2nd script does the export of data into CSV but will only export the rows that actually have values. So, if there are 4 rows, then the CSV has only 4 rows.

In the working script you provided, it works similar where the 4 rows are the only ones to print, and the ,,,, is correctly left off of the rest of the rows following, but I end up with 96 blank lines in the CSV instead of only 4 or 5 lines in the CSV.

AH HA! "NOTEPAD"

So, I was looking at all these csv files in Notepad++

If I open up the exported CSV in plain-old-windows-lame Notepad, then I can verify that I do see the expected output of 4 lines only.

Thank you so much for all your help with this. I think I should be good to go with my file transfer.

I had notepad++ open because I have some dos batch file scripts I was running and I like the use of the tabbed interface vs. notepad (no tabs, no format, nothing)

Last (quick) question- say I wanted to start at V01 and count up instead of V1- is that an easy change ?

Thank you again so much. And good luck with your daughter's truck. If I had any mechanic skills I'd offer help to return the favor.