• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

new file generation

HanSam

Member
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 !
 

Attachments

  • CCDB Entry Form1.xlsm
    120.3 KB · Views: 2
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?
 
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...
 

Attachments

  • CCDB Entry Form1.xlsm
    110.3 KB · Views: 4
Back
Top