I have an Access database from which I export a query (using VBA) as a new Excel Spreadsheet each day. The employees in the department to which the sheet is sent are not familiar with Excel (!) so they are demanding the sheet be formatted when they receive it.
I'm trying to make the process easy for my co-workers and have already automated the creation of the spreadsheet and have figured out how to autofit all the columns, but I need help with some additional tasks.
I'd like to get the sheet formatted as landscape on legal size paper and print the gridlines. My attempts at doing this so far with PageSetup functions in VBA have failed.
Any advice would be greatly appreciated. Much thanks!
I'm trying to make the process easy for my co-workers and have already automated the creation of the spreadsheet and have figured out how to autofit all the columns, but I need help with some additional tasks.
I'd like to get the sheet formatted as landscape on legal size paper and print the gridlines. My attempts at doing this so far with PageSetup functions in VBA have failed.
Any advice would be greatly appreciated. Much thanks!