new file generation

[HanSam]

Hi,

Can you guys check on the attached file. The Generate Reports button when clicked should generate 3 different files and get data from the original file with autofilter criteria.

The files are being generated and saved, however the data is not being copied.


▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !

​

 

[vletm]

I didn't verify my idea, but ...
You (code) should tell 'from which workbook' it would make a copy'!
You could test to show any range before make copy ...
Is the range from correct workbook?

 

[PCosta87]

Hi,

Remove quotation marks from Workbooks("WeeklyName") (and the other 2 workbooks)... it should be:

Workbooks(WeeklyName)
Workbooks(ApprovalName)
Workbooks(RejectName)

Otherwise you are referring to a workbook with the name "WeeklyName" which isn't the case... WeeklyName is a variable and should be used without ""

See attached...