Results 1 to 8 of 8

Save active workbook to other drive error

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-05-2007
    Location
    Falmouth, VA now, Palm Bay, FL for 2 yrs, was Colorado Springs, CO for ten years; Cedark Park, TX; Zeeland, MI; Wilmette, IL; Princeton Junction, NJ; NY, NY
    MS-Off Ver
    365
    Posts
    615

    Save active workbook to other drive error

    Well, i'm back, and unfortunately with the lapse of time have forgot most of which i once knew, but not the fact that you folks saved me countless times. Thank you, once again, for considering my issue-

    I bought a new computer and hooked it up early this week - the previous was almost 14 years old and had too many bandaids to keep it going. I copied my main spreadsheet to the new computer and now am running into a problem trying to save the workbook to an alternate location, as i keep two operationally ready copies. The main difference in my configuration as far as i know is that the program is regularly run from a location on my D: drive, whereas the alternate save is to my C: drive.

    The code line i am using is:
    ActiveWorkbook.SaveAs "C:\Program Files (x86)\Kraken\Kraken.xlsm"
    and the error message as is attached hereto, a runtime error 1004.

    Am i doing something wrong? Is there another method or workaround?

    The code used to work fine when both were on the same drive though in different folders, but that might not be the issue-

    Once again, so many thanks for all of your help over the years-
    -Bruce
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Auto-save workbook without prompt on a network drive
    By kc0259 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-27-2019, 03:05 AM
  2. Save as active workbook with module & macro code in (this workbook)
    By nisshaheen76 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-07-2019, 10:24 AM
  3. Macro save workbook to network shared drive folder / curdir not working
    By transporterpilot in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-08-2016, 12:43 AM
  4. [SOLVED] Save Active Sheet As New Workbook in same folder of the original workbook
    By Taislin in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-19-2012, 07:03 PM
  5. Replies: 2
    Last Post: 06-20-2012, 09:08 PM
  6. Automatically Save Workbook From One Drive To Another
    By SEOT in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-03-2010, 09:58 PM
  7. [SOLVED] Excel 2k3: Workbook on network drive, when save creates new file
    By AVCCTech in forum Excel General
    Replies: 1
    Last Post: 07-07-2005, 04:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1