Stuart McLachlan
stuart at lexacorp.com.pg
Sat Jun 9 19:21:02 CDT 2012
Hi Arthur, Not sure what you meann by " Within Access, I open a report (could be in Excel or Word) " Can you send me (off-list) a copy of a module where you are creating and populating an Excel object? -- Stuart On 9 Jun 2012 at 20:00, Arthur Fuller wrote: > Stuart, you are clearly a smart guy and I am not, so please forgive my > stupid question. Here is what I am trying to, so far without success. > Within Access, I open a report (could be in Excel or Word) and then I want > to bring up the FileSaveAs dialog. I have tried about 108 variations on the > code, and still no joy. You are the sharp knife in the drawer, please tell > me how to do this. Here's the scenario. I create an Excel object and add > stuff to it, all piped from Access. That part is cool, works perfectly. But > then I need to offer the user the chance to save said XLS file to anywhere > she wishes. I am flummoxed. I've looked at various snips from ADH etc. > without enlightenment. If you can tell me how to do this, I would be most > grateful. > > A. > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Stuart McLachlan Ph: +675 340 4392 Mob: +675 7100 2028 Web: http://www.lexacorp.com.pg