Save and close newly created CSV workbook

Hi,

I have a macro that currently extracts data from a workbook and creates a new workbook, which i would then like to save and close this newly created workbook as a csv.

I only need to set the save path once, so if i could include this path in the code, that would be great. I believe CSV's have pop ups when saving too with regards to saving and losing formatting etc, if they can be avoided to that would be great.

The current code i have for the creation is

Please Login or Register  to view this content.

Hopefully that makes sense and any help would be much appreciated.

Thanks in advance

Marcosis

try this: strP is the path where you want the file saved.

Please Login or Register  to view this content.

Originally Posted by cubangt

try this: strP is the path where you want the file saved.

Please Login or Register  to view this content.

Hey,

Thanks for responding. Where would that go? As good as the code looks that i put in my original post, i cant actually write code yet, so i take bits from this and that and hope everything works.

Im slowly learning, but currently quite the amateur!

Thanks again

put it between your save lines here:

Please Login or Register  to view this content.

Originally Posted by cubangt

put it between your save lines here:

Please Login or Register  to view this content.

Perfect! Ill test it out later and get back to you!


Cheers

No need to make it too complex.

Please Login or Register  to view this content.

Originally Posted by jindon

No need to make it too complex.

Please Login or Register  to view this content.

Hey jindon,

I know that that may have been simple for you, but i cant thank you enough! Thats perfect for what i need it for! Worked like a charm.

I have one more request if possible, I want to call another macro after the one were currently talking about that saves a copy of the current workbook with the name being "Main sheet" (i cant type the real name as its a company thing) and then the value of J4.

Ive tried using the below, but it ends with excel open with a blank area, no cells or worksheet, just empty and the main workbook closed. Its really strange. Is there another way?

Thanks again

Please Login or Register  to view this content.

Not really sure about what you are trying to do...
Perhaps

Please Login or Register  to view this content.

Originally Posted by jindon

Not really sure about what you are trying to do...
Perhaps

Please Login or Register  to view this content.

Hey,

So i want the macro to do 2 things.

The first is the CSV that you have sorted for me perfectly.

The second would be saving a copy of the main original sheet with the filename being the the words "Main sheet " and then the value of J4 which is the PO Number.

So you fill out all the details in the first, main sheet. You run the macro, it creates and saves the csv, then saves a copy of itself titled, for example, "Main Sheet 1234"

Hopefully that makes more sense.

Cheers

Originally Posted by marcosis

The second would be saving a copy of the main original sheet with the filename being the the words "Main sheet " and then the value of J4 which is the PO Number.

What is "main original sheet"?

Originally Posted by jindon

What is "main original sheet"?

Sorry the sheet that runs the macro.

Its basically a blank Purchase order form, they fill out the PO order details, run the macro that will extra the data to the CSV, then save the Purchase order again as a seperate file excel file, with the filename of the PO, but with the PO number, written in J4 on the end of the file name, So "Purchase Order 123"

Is that "UploadSheetTemplate" or other sheet or workbook ?

Originally Posted by jindon

Is that "UploadSheetTemplate" or other sheet or workbook ?

UploadSheetTemplate is a sheet in the PO workbook which is hidden and pulls the data, just with a simple formula needed from the PO to the template and that’s what the CSV is actually made from.

The reason I have that sheet hidden is because the CSV has to have specific headers, so it pulls the data and pastes it starting on row 2, so as to leave the headers alone.

If that makes no sense haha, I’ll try and block out company details and send a copy.

Let me know

I'm asking which worksheet do you want to save as a new workbook?
Or is it a workbook itself, not a single worksheet, that the code is running from?

Originally Posted by jindon

I'm asking which worksheet do you want to save as a new workbook?
Or is it a workbook itself, not a single worksheet, that the code is running from?

My bad.

UploadSheetTemplate is the single worksheet from the workbook running the code that needs to be it’s own CSV workbook