H
hce
Dear All
Firstly, is it possible to use VB code to create a macro that allows m
to save multiple worksheets in a workbook as csv files and the name o
the csv files to be defined by the tab names... for example UK(Sheet1
would be saved as UK.csv... and so on...
Secondly, is it possible to create a macro that prints define
worksheets... I only want to print 5 pages of data if there's more tha
5 pages of data and if there's less than 5 pages of data, then prin
all... hence all print outs should not be more than 5 pages... Also, a
my vb knowledge is limited, i only know how to define my macro to prin
by using this command... Sheet1.Select... i currently has a macro t
help me print but it will print 5 pages of all defined worksheets whic
is a waste of paper because there's some worksheets that has no data..
or not much data... this is my command... Sheet1.Select then cal
printmacro...
I would really appreciate if anyone could suggest a better way for m
to do all these stuff...
cheer
Firstly, is it possible to use VB code to create a macro that allows m
to save multiple worksheets in a workbook as csv files and the name o
the csv files to be defined by the tab names... for example UK(Sheet1
would be saved as UK.csv... and so on...
Secondly, is it possible to create a macro that prints define
worksheets... I only want to print 5 pages of data if there's more tha
5 pages of data and if there's less than 5 pages of data, then prin
all... hence all print outs should not be more than 5 pages... Also, a
my vb knowledge is limited, i only know how to define my macro to prin
by using this command... Sheet1.Select... i currently has a macro t
help me print but it will print 5 pages of all defined worksheets whic
is a waste of paper because there's some worksheets that has no data..
or not much data... this is my command... Sheet1.Select then cal
printmacro...
I would really appreciate if anyone could suggest a better way for m
to do all these stuff...
cheer