Stuck with VBA Code. Creating a unique reference number with each macro click

[blackburnsexcel]

Hi,

I have an export to Word macro. I want to achieve more with is but my skills are limited so if you could help I'd be forever grateful.

The code is below.

Please Login or Register  to view this content.

What I would like to achieve is a unique reference number (URN) generated each time the macro button is clicked, that number entered in a specified cell within the sheet and then the file saved as that reference number.

Can anyone help me achieve that?

Also, how would I specify what needs to be exported? For example, I currently have to select the area I want to export and then click the button. I need it to export columns A to J and Rows 1 to 50.

Thanks in advance.

Edit: Apologies for not complying with the rules.

[Pepe Le Mokko]

Tags added

[Pepe Le Mokko]

Title much more clear

[blackburnsexcel]

I've found another piece of code that may acheive what I'm looking for but I wouldn't know how to integrate it.

Please Login or Register  to view this content.