+ Reply to Thread
Results 1 to 4 of 4

VBA Save As Error 1004

  1. #1
    Registered User
    Join Date
    07-25-2019
    Location
    San Diego, CA
    MS-Off Ver
    16.0.11727.20222
    Posts
    34

    VBA Save As Error 1004

    Hey all!

    I'm getting an error thrown in this code because my filename from cell E1 contains a "/" in it. This is data that I can't change manually, as it's an autofill reference from another table. Is there something I can add to my code as a contingency in case my filename ends up trying to include a "/">

    Thank you!

    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: VBA Save As Error 1004

    How about
    Please Login or Register  to view this content.
    Change the _ to whatever you prefer

  3. #3
    Registered User
    Join Date
    07-25-2019
    Location
    San Diego, CA
    MS-Off Ver
    16.0.11727.20222
    Posts
    34

    Re: VBA Save As Error 1004

    Perfect!

    Thank you!

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: VBA Save As Error 1004

    You're welcome & thanks for the feedback

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Error 1004 while save as file
    By sajnica89bg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-27-2019, 08:48 AM
  2. [SOLVED] error 1004 - unable to save file
    By rickmeister in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-08-2017, 07:16 AM
  3. Run-time error 1004 error on Mac only Application.Get.Save.AsFilename
    By Carpinteria Al in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-04-2016, 11:20 AM
  4. Run time error 1004 save excel as pdf
    By mertian in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-27-2016, 06:11 AM
  5. Runtime error 1004 when trying to save file via VBA
    By avh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-09-2015, 03:20 AM
  6. Error 1004 with save button
    By koconn in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-04-2013, 09:55 AM
  7. Runtime error 1004/ Save As method help
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-17-2006, 12:00 AM

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