Multiple printing

[Alfalah1]

Hi! Please I'm a newbie to excel vba, so there's this report card I'm trying to do for my school, so if I put a reg number in a cell the details of the student will display if I press generate, then I can now print it. But I want a vba micro that will be changing the reg no. And generate the details and then print automatically. Please I need help. Thanks.

 

[Logit]

Click the upper left corner of your image and change the setting to FULL IMAGE. Presently, your pic is too small to understand the details.

 

[Alfalah1]

Thanks. Please may I have your mail address so as to forward the original documents. I want the forms to print automatically while the roll number also change. Thanks a lot.

 

[Logit]

Ok ... now that we have a clearer understanding of what you are seeking ... please post your workbook to a download site such as DropBox.com or similar. Then post the link to download
here.

Thanks.

 

[Alfalah1]

Ok ... now that we have a clearer understanding of what you are seeking ... please post your workbook to a download site such as DropBox.com or similar. Then post the link to download
here.

Thanks.

Institute Management System.xlsx

Shared with Dropbox

www.dropbox.com

 

[Alfalah1]

Ok ... now that we have a clearer understanding of what you are seeking ... please post your workbook to a download site such as DropBox.com or similar. Then post the link to download
here.

Thanks.

Thanks for the quick response. I really appreciate. So from the workbook, if you go to the print form, instead of inputing the reg no. One by one and printing, I want the reg no. to be changing automatically and at the same time printing. Thanks a lot.

 

[Logit]

Unable to open the workbook. Excel says the workbook is corrupted and has the wrong file type extension.

 

[Alfalah1]

Unable to open the workbook. Excel says the workbook is corrupted and has the wrong file type extension.

Sorry for that pls. Check this, it should open

C-M-S.xlsm

Shared with Dropbox

www.dropbox.com

 

[Alfalah1]

Sorry for that pls. Check this, it should open

C-M-S.xlsm

Shared with Dropbox

www.dropbox.com

C-M-S.xlsm

Shared with Dropbox

www.dropbox.com

 

[Alfalah1]

Unable to open the workbook. Excel says the workbook is corrupted and has the wrong file type extension.

So if you go to the print admission form, I want the forms to be printing automatically one after the other, instead of printing one by one.

C-M-S.xlsm

Shared with Dropbox

www.dropbox.com

Unable to open the workbook. Excel says the workbook is corrupted and has the wrong file type extension.