Automatically modifying imported reports
I want to import a file from crystal (E2 Shop Systems) into an Excel file. I
then manually resize fonts, hide the unneeded columns,blank rows, and sort the data for other users. Is it possible to have excel "do" all this to the file upon opening it? |
Automatically modifying imported reports
The simple bit is "yes" excel can do it. next time you do it switch on record macro when you start. Then you have three choices: 1. the code all looks too scary so get a professional to help 2. You understand bits - so start chopping it up to do bits of the work. then over time experience and confidence will enable you to extend the functionality 3. you carry on doing what you are doing! -- tony h ------------------------------------------------------------------------ tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074 View this thread: http://www.excelforum.com/showthread...hreadid=491403 |
All times are GMT +1. The time now is 12:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com