tag:blogger.com,1999:blog-7176045.post115228275900935483..comments2008-07-31T20:46:41.565+04:00Alex Dybenkohttp://www.blogger.com/profile/16954512620659022712noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-7176045.post-10046374642389442212008-07-31T20:46:00.000+04:002008-07-31T20:46:00.000+04:002008-07-31T20:46:00.000+04:00Thank you Alex! I have been stuck on this for 2 days now and this worked perfectly!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7176045.post-39123841708345569592008-06-29T06:46:00.000+04:002008-06-29T06:46:00.000+04:002008-06-29T06:46:00.000+04:00Thanks Alex, I'll use this.<BR/><BR/>Bonnie<BR/>http://www.dataplus-svc.comDataPlus - Data Entry Servicehttp://www.blogger.com/profile/08436982049701752461noreply@blogger.comtag:blogger.com,1999:blog-7176045.post-3211462556697028252008-05-13T08:38:00.000+04:002008-05-13T08:38:00.000+04:002008-05-13T08:38:00.000+04:00Hi,<BR/>i think its better to use excel authomation then TransferSpreadsheet in this case. look at sample code at www.mvps.org/access and support.microsoft.comAlex Dybenkohttp://www.blogger.com/profile/16954512620659022712noreply@blogger.comtag:blogger.com,1999:blog-7176045.post-26902808125821058502008-05-13T00:33:00.000+04:002008-05-13T00:33:00.000+04:002008-05-13T00:33:00.000+04:00I have a problem which is related to this and was wondering if you had any suggestions.<BR/><BR/>I have a table which lists all the managers for various departments. I have twenty-five other tables which list users, user IDs and access levels in each of the departments.<BR/><BR/>I need to create a spreadsheet for each manager with tabs/workbooks for each of the twenty-five departments filtered only for their users.<BR/><BR/>Is there a way to do this in Access?<BR/><BR/>Thanks for any help you're able to offer!Nicohttp://www.plutonica.netnoreply@blogger.comtag:blogger.com,1999:blog-7176045.post-38258639940157825262007-03-25T12:40:00.000+04:002007-03-25T12:40:00.000+04:002007-03-25T12:40:00.000+04:00Also consider: DoCmd.RunCommand 175 with the source table/query open. It exports a more formatted spreadsheet, but doesn't offer the range capabilities.Cliff "Chibby"noreply@blogger.comtag:blogger.com,1999:blog-7176045.post-1165340787758775982006-12-05T20:46:00.000+03:002006-12-05T20:46:00.000+03:002006-12-05T20:46:00.000+03:00This works brilliantly. THANKS!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7176045.post-1156169036375498362006-08-21T18:03:00.000+04:002006-08-21T18:03:00.000+04:002006-08-21T18:03:00.000+04:00I've been using the TransferSpreadseet export to move data back to excel without using the range parameter. <BR/>What I've found is that Access uses the name of the Table/Query as the named range/worksheet if writing back to an existing workbook. All else is consistant with the article.<BR/>MoreyMoreyhttp://www.blogger.com/profile/13768724565467652897noreply@blogger.comtag:blogger.com,1999:blog-7176045.post-1152542583040370332006-07-10T18:43:00.000+04:002006-07-10T18:43:00.000+04:002006-07-10T18:43:00.000+04:00!@#$%^&*() is what I think of undocumented "Features". <BR/><BR/>Thank you for your research and analysis. It explains why I had to do the workaround that I installed. Frustrating that I have to do it. My memory (which is subject to random acts of forgetfullness) says it was not always this way. But since we need to work in the present, it does not matter.<BR/><BR/>Thank you again for your research.<BR/><BR/>RonRon2006 from Google Access NGnoreply@blogger.com