Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    tkosel is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2014
    Posts
    33

    I would also be willing to bet that the documentation issues are due to not testing/updating when modifications are made to office. I know that the omission of a filename argument used to cause access to automatically open a browser to specify the file location and filename on both the export and import method of TransferSpreadsheet. I would guess that they changed functionality without updating the related documentation.

    Such is our world of way to much information. Impossible to keep it all current and accurate.

  2. #17
    ssanfu is offline Master of Nothing
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Quote Originally Posted by tkosel View Post
    I got that to work except for one thing. I want the user to be prompted for the file location and name.
    Here is one option....


    EDIT:
    But be aware that any existing file will be overwritten without notice if the newfile name is the same as an existing filename.
    Attached Files Attached Files
    Last edited by ssanfu; 04-25-2022 at 05:53 PM. Reason: added warning

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 26
    Last Post: 04-07-2020, 02:29 AM
  2. Large Dataset Export to Excel Form
    By hawkdriver in forum Programming
    Replies: 5
    Last Post: 03-11-2020, 05:20 PM
  3. large excel data
    By stech786 in forum Macros
    Replies: 4
    Last Post: 12-09-2017, 07:06 PM
  4. Adding large amount of Excel data into Access
    By gbmarlysis in forum Access
    Replies: 4
    Last Post: 06-16-2015, 02:34 PM
  5. Excel file that I export from Access is extremely large
    By Ronald Mcdonald in forum Access
    Replies: 1
    Last Post: 05-25-2012, 03:32 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums