Results 1 to 5 of 5

Open Excel and SavingAs

  1. #1
    MaxQTime is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Apr 2019
    Location
    Kelowna, B.C.
    Posts
    40

    Open Excel and SavingAs

    Hi everyone, another question I'm sure has an easy answer, but I just can't figure it out. I"m opening an excel file from Access, and I want it to pop up with the Save As. This is so the master template file doesn't get saved with a bunch of information in it. Is there another command I'm unaware of that I should be using instead? I'm using;




    Code:
     oXL.getsaveasfilename

  2. #2
    Ajax is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    7,547
    perhaps open your template file readonly - then user will be forced to save as something else. e.g.

    Workbooks.Open Filename:=filepath,ReadOnly:=True

  3. #3
    MaxQTime is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Apr 2019
    Location
    Kelowna, B.C.
    Posts
    40
    The problem with that is that I have it filling in a bunch of cells with the information stored in a particular record.

  4. #4
    Ajax is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    7,547
    readonly does not mean you can't make changes. It means you can't save the file with the same name.

  5. #5
    MaxQTime is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Apr 2019
    Location
    Kelowna, B.C.
    Posts
    40
    Good to know, thank you.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 07-10-2019, 07:34 PM
  2. Replies: 1
    Last Post: 03-11-2014, 09:29 AM
  3. Excel code not working with Excel open
    By jgelpi16 in forum Programming
    Replies: 1
    Last Post: 07-11-2011, 12:12 PM
  4. Open excel 2007
    By spqr in forum Access
    Replies: 14
    Last Post: 03-26-2010, 07:48 AM
  5. VBA to open excel, import on close of excel
    By bdaniel in forum Programming
    Replies: 0
    Last Post: 03-20-2010, 02:45 PM

Posting Permissions

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