Copying cells from one workbook to another and saving an individual file for each cell

[Andyg666]

Hi,
I am new to macros but hope you can help me.
I have a list of items and related information (model, serial number etc) and I need a macro so that I can press a button and export the item name and serial number of each item into another workbook for each item on the original list including a pop up option of where these new workbooks would be saved.

I hope this makes sense, please help

 

[Andyg666]

Thanks ........ however it works for the first for lines but then gives an error
Run-time error '1004':
Method 'saveAs' of object '_Workbook' failed

What is this then? As you can tell I am clueless

 

[mumps]

Make sure that the data in C3 & C4 & C5 & H3 does not reproduce duplicate file names.

 

[Andyg666]

Thanks ........ however it works for the first for lines but then gives an error
Run-time error '1004':
Method 'saveAs' of object '_Workbook' failed
View attachment 114593
What is this then? As you can tell I am clueless

Hi,
I think the file name is to long and i gives this error and then stops

Make sure that the data in C3 & C4 & C5 & H3 does not reproduce duplicate file names.

Hi,
I'm thinking the file name is to long and it gives this error and then stops

 

[mumps]

You can have up to 260 characters including the extension so I don't think that's the problem. Did you delete the question marks? Are any files being saved?

 

[Andyg666]

You can have up to 260 characters including the extension so I don't think that's the problem. Did you delete the question marks? Are any files being saved?

It is the file name length
If I change the name in the data file so its no as long it works until it gets to the next error.

I don't think the file name would of been 260 characters long but I would need to check but if I go to the file it created and rename to put the longer file name in manually it works. ????

Yes I have removed all the question marks.

 

[mumps]

I removed all the question marks and ran the macro and it created all 7 files correctly using the 2 files you posted. Are you using the macro on different files?

 

[Andyg666]

I removed all the question marks and ran the macro and it created all 7 files correctly using the 2 files you posted. Are you using the macro on different files?

it works but then has an issue with the filename length as when I reuse the text in the data then it works and moves on to the next.

The file length is about 99 characters????

 

[mumps]

It should accept up to 260 characters.

 

[Andyg666]

It should accept up to 260 characters.

I removed one of the cells (c5) and its busy doing its thing now.
Not 100% I have done that correctly but I will update

 

[Andyg666]

I removed one of the cells (c5) and its busy doing its thing now.
Not 100% I have done that correctly but I will update

It may be because it includes the file path name in the character limit?