?
Solved

Transfer spreadsheet error

Posted on 2014-01-21
2
Medium Priority
?
459 Views
Last Modified: 2014-01-21
Hi,
I have been transferring query results for the past year using the transfer spreadsheet routine. I have written a new one for a new query and all of a sudden it wont let me transfer the data saying that the destination folder is not available or already open! Not true. I even simplified the destination to my desktop on my laptop to see if that solved it but to no avail. the code is this;

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryProdRprt", "C:\Users\StevieB\Desktop"

DoCmd.OutputTo acOutputReport, "rptShiftRptNow", acFormatPDF, "C:\Users\StevieB\Desktop"

it stops at the transfer spreadsheet line saying it cannot write to the file "C:\Users\StevieB\Desktop" it is already opened exclusively by another user, or I need permission to view and write it's data.
???

Any help as always is much appreciated.
Thanks
0
Comment
Question by:Stephen Byrom
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 39797855
add the file name


DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryProdRprt", "C:\Users\StevieB\Desktop\myExcel.xls"
0
 
LVL 1

Author Closing Comment

by:Stephen Byrom
ID: 39798227
Bloody ell!
Silly me.
Thanks for your time
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question