Tom Jones
06-21-2015, 02:10 PM
I have an excel file with 2 sheets (one visible, Sheet1, and a hidden sheet, Sheet2) and I like using VBA code, to create 3 files on the desktop:
- .PDF File to copy data from Sheet1 (range A1: G30)
- .xlsx File to copy data from Sheet1 (range A1: G30), but delete button that acts VBA code
- .xls file (in which there are no Sheet1 and in Sheet2, to delete columns A:K, also would like to remove VBA code)
Can you help me?
Thanks.
- .PDF File to copy data from Sheet1 (range A1: G30)
- .xlsx File to copy data from Sheet1 (range A1: G30), but delete button that acts VBA code
- .xls file (in which there are no Sheet1 and in Sheet2, to delete columns A:K, also would like to remove VBA code)
Can you help me?
Thanks.