Generate PDF files based on the content

[chathuranga]

Hi everyone,
I have no idea whatsoever about macro or vba and I think the problem I have faced maybe solved with macro in excel.
OK, here it is,

I have a growing list with a unique code consists of numbers and letters in column A and in column B a description about the item in column A code.

ex.

A____________________B
BY8EMCT01___________Bracelet in 18K Yellow Gold with an Emarald and Citrines
BY4CTXX01___________Bracelet in 14K Yellow Gold with a Citrine
BY8AMXX01___________Bracelet in 18K Yellow Gold with Amethysts

I need to generate a PDF file based on the items in column A and if possible the description should be written on that particular pdf generated (this is not a must though).

I should be able to come back again when the list is grown and generate the pdf files again without over writing the previously generated pdf files.

Thanks every in advance for taking your time to help.

[rcm]

Hi, the needed outcome is not clear to me, is it the same as the input?

Assuming it is, the PDF creation can be done by saving the excel file (use SAVE AS) and choose PDF as its extension..

[chathuranga]

Hi, the needed outcome is not clear to me, is it the same as the input?

Assuming it is, the PDF creation can be done by saving the excel file (use SAVE AS) and choose PDF as its extension..

Hi, Sorry for not being so clear.

No, I am not trying to save the sheet as a pdf.
The Column A items keep growing from time to time. In the example Ive given above have only three entries. I need a pdf file for each entry at the column A. So I need a method to generate three pdf files on these items. For example i need these three pdf files to be generated into a folder.
BY8EMCT01.pdf
BY4CTXX01.pdf
BY8AMXX0.pdf

[Logit]

You can place the following macro into a routine module and call with a Command Button:

Please Login or Register  to view this content.

[chathuranga]

Hi Logit,
Thank you for taking your time. But this gives me all the data in sheet 1 to a pdf file (I'm not sure if I'm doing this correctly though). I need separate pdf file for each and every row with data.

[Logit]

The following code will do what you are seeking :

Please Login or Register  to view this content.

The only thing I don't understand with this macro ... If your data begins in A1, for some reason this code will delete the contents of A1 when it finishes.
There is nothing in the code that creates that action, so it's confusing to me. Let me know if it does the same thing for you - maybe it's just a quirk
on my system.

A simple solution is to make certain your data begins in A2.

If anyone has an edit to the code that will prevent the deletion of data from A1 (as the code is presently written) ... please contribute.

Hope this helps.

[chathuranga]

Hi Logit,
I have tried your. Seems the command is running but I cant find where the pdf files are saved. :-)
And yes the problem with A1 cell is there and its going to be a problem.

Thanks a lot for taking your valuable time. i have attached a file found in the internet which does the job. However, this have a problem overwriting the existing files.

Please have a look if you have time.

Thanks again.

[bakerman2]

@ chathuranga

Please stop quoting when you give a direct answer to the previous post. It just clutters this thread.

generate the pdf files again without over writing the previously generated pdf files.

How do you plan to keep 2 files with the same name in 1 directory.

[chathuranga]

Hi bakerman2,
Sorry about the quoting.
I wont be needing to keep 2 files with same name in one directory. I just want the command to write new pdf files for the next additional row values.

For example, if i have three values in the rows of column A like this
BY8EMCT01
BY4CTXX01
BY8AMXX0
and when i first run the command I should get these files
BY8EMCT01.pdf
BY4CTXX01.pdf
BY8AMXX0.pdf

Then When I have another value in the next row of column A, (eg BY4RMCT01) and when I run the command it should not overwrite the previously generated PDF files but generate only the new file BY4RMCT01.pdf

The file I have attached to the above reply does the job, However it overwrites the previously generated files as well.

[bakerman2]

Then use the Dir-function in your loop to check wether the file already exists before exporting it as pdf.
Something like

Please Login or Register  to view this content.

[chathuranga]

But then I will have to modify the code each time I have a new row addition, right ?
That will be a PIA. :-)

[bakerman2]

No, because you know the filename previous to exporting place that in the Dir-function and check.
Like this.

Please Login or Register  to view this content.

[chathuranga]

Ok this is the code I have, Could you please let me know to where I should include yours ?

Please Login or Register  to view this content.

[chathuranga]

Sorry about that, Edited.

[bakerman2]

Gave you solution in my previous post.

Please Login or Register  to view this content.

[chathuranga]

OK.
It works. Thank you so much for all the help.
I have spent days trying to figure this out.

Thanks again.

[bakerman2]

You're welcome.