Dear Forum,
I am wondering what's the best way to write Excel VB codes for to accompolish the following tasks?
I have an excel file (book1.xls) which consist of 1 master worksheet. I created a Form to trigger a bunch of macro buttons to do auto filters. Then my codes will copy and paste these filtered records into a new sheets (Sheet1, Sheet2, Sheet3..etc). My problem is that after I created these sheets, I can NOT figure out the codes for button1 to export Sheet1 onto a NEW FILE, and it will allow user SAVE the whatever file name or directory they desire (say file name is book2.xls). Back on the user form of book1.xls, I also would like to click on the button2 to COPY Sheet2 and append it onto any workbook or to the book2.xls as well. I think I have to declare some type of global variable, so the user would be able to map Sheet2 onto any excel work book they desire as appending the worksheet. I am very new to any programing. Please be so kind to provide some insightful advise. Thank you very much. Your advise will make my day! =)
Zabrina from the SF BayARea
Just another humble analyst & VBA newbie~
I am wondering what's the best way to write Excel VB codes for to accompolish the following tasks?
I have an excel file (book1.xls) which consist of 1 master worksheet. I created a Form to trigger a bunch of macro buttons to do auto filters. Then my codes will copy and paste these filtered records into a new sheets (Sheet1, Sheet2, Sheet3..etc). My problem is that after I created these sheets, I can NOT figure out the codes for button1 to export Sheet1 onto a NEW FILE, and it will allow user SAVE the whatever file name or directory they desire (say file name is book2.xls). Back on the user form of book1.xls, I also would like to click on the button2 to COPY Sheet2 and append it onto any workbook or to the book2.xls as well. I think I have to declare some type of global variable, so the user would be able to map Sheet2 onto any excel work book they desire as appending the worksheet. I am very new to any programing. Please be so kind to provide some insightful advise. Thank you very much. Your advise will make my day! =)
Zabrina from the SF BayARea
Just another humble analyst & VBA newbie~