How to generate multiple worksheets from a list

[#1]

for each code a seller need to export a spreadsheet.

So I do not have to filtar each vendor in order to export the result of the selling of it.

[#2]

Hi,

By using macro-See the attached QVW,

Regards,

Yigal.

[#3]

Good morning Yigal,

qvw in this macro is giving the line: "Set xlApp = CreateObject (" Excel.Application ")"

Error: The componete ActiveX can not create object: 'Excel.Application'

I do not have Excel on my machine it affects in any way?

according to your qvw I would 3 files each with the product code, product code where is his name and content is the worksheet that contains the values​​.

Sincerely,

Gleybson Fernandes

[#4]

Hi Franandes,

You are right, the export using Excel,

Wich platform you want to export with?

Regards

Yigal

[#5]

Yigal,

I made some changes in QVW file you sent me and now we just need to make the second time I generate the files he subscribes existing ones.

Can you help me with that?

follows the attached file.

thankful,

Gleybson