I am going to be creating excel spreadsheets directly from Access. The Access reports will get kicked off by a chron job in Unix.
I'm trying to keep the excel processing invisible but if I try to do anything like: application.visible = false application.screenupdating = false sheets.visible = false it breaks. What is especially wired is this, I'm running three access mdb/reports WTD,MTD,YTD In the WTD version, I create a new XL workbook. I never show the sheet that gets created in the first report that runs (WTD) with no error. This: theXLS.ScreenUpdating = False does not break it At the end of the WTD Acess/Excel, I save and close the WB which has only one sheet in it. When I run Access 2, Month to Date, I reopen the workbook and add a MTD sheet after the original WTD sheet. Then, if I try to hide anything, it breaks Is there a way around this? ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
