Macro works on desktop but not Network environment

Hello, I recently had help from Logit getting a macro created that could save an Excel file - a daily shift attendance sheet - to a specified location on my desktop under a specified name as well as compose an email with the same file attached with pre-populated Subject, Body, and email recipients. That can be found here: https://www.excelforum.com/excel-pro...-and-exit.html. I presented this to the managers here at work and they all loved the idea because it would eliminate needless emails and phone calls when someone didn't receive the sheet that was supposed to and so they gave me to go ahead to get it implemented in the actual network drive where the attendance sheet templates are kept. Basically, they would be saved into a separate folder within that same network drive.Here is the macro for the desktop location to get an idea behind the coding:

Please Login or Register  to view this content.

This one is working fine. I had pasted this same macro in the file that is located in the network drive. I changed it to have the file pathway leading to the folder that I would need it saved in there. The coding for that looks like this:

Please Login or Register  to view this content.

I didn't realize that a network location would operate differently and that this code would not be valid. It was composing the email just fine, but not saving the file where I wanted it to go. I'm not even sure where it saved it if it even did - I just know it wasn't where intended. Is it completely different coding needed here in the case of network drives? Is something like this actually even possible?

Does everyone have the network location mapped the same? Because if they don't it won't work based off of yours. With our network it makes everyone use it as a Z drive shared nertwork so that everyone has the same one. Re read it seems its not even working for you based off your own parameters. Let me deepdive.

Edit: You are using the UNC file paths which is smarter than what I do to be fair.

Edit2: I am testing this on my network and getting the same error as you are as well as its totally locking me out further investigating.

Edit3: I got it working perfectly fine on the actual shared network we are using. The private side of the network that I can see (even my own private folder) I could not get it to work on. I have the private side of the network configured differently.

This may be an issue with your file path or your permissions on the shared drive I am the admin so I can read and write to any files on the "Shared" section I can only read what is in the individual private users folders (unless I go onto a different account that requires two upper management to access) Like I said I could not get it to work on my personal private folder on the shared drive because I do not have full perms on this account.

Can you right click drag the file path you want to a word document and create a hyperlink for it. Then copy and paste that into the actual code. This might also be an issue.

Your file path looks off to me to be honest.

If you can put a breakpoint on this line: ActiveSheet.SaveAs Filename:=Name, FileFormat:=52

Run the code and when it hits that breakpoint, mouse over or look at what your "Name" variable contains, copy that out and paste it into your windows explorer and see if you can access it or if its even valid. I agree that it looks a little off, but not clear on why..

Name = Environ("UserProfile") & "\\servername\Data\DNS\Group\Warehouse\Management\Absentee tracking\UNFI F21\Perishable 1st\" & _
Format(Now(), "mmddyy") & " " & "Perishable 1st Shift ABSENTEE BLANK (1ST SHIFT)" & ".xlsm"


I would copy that value into notepad, then i would manually navigate to the location you are expecting to save the file and manually copy that path into a line below in notepad and just compare and see what is different between your logic string and the actual string

Okay so I ended up talking with our IT person and we tried troubleshooting it. The very strange thing is that it works but not consistently. We can't figure out the pattern. He ended up changing the coding to this:

Please Login or Register  to view this content.

As you can see, he removed some of the coding in the upper portion where it is telling the file where to save it to and name it. I did leave him a message to call me so that we could take a look at both of these posts and try something out but I did at least want to post what we did. We just can't figure out why it doesn't consistently work.

Trying saving / overwriting the file, if there is a chance of revisions.

https://www.teachexcel.com/excel-tut...g-vba-in-excel

Originally Posted by cubangt

Trying saving / overwriting the file, if there is a chance of revisions.

https://www.teachexcel.com/excel-tut...g-vba-in-excel

So I was looking at this article and I saw how it says about having DisplayAlerts.False and DisplayAlerts.True.

Please Login or Register  to view this content.

But looking in this code, I see they are already there?

Here's something strange. I had created a button on the actual workbook for whoever to press it to save/email the sheet and of course assigned this macro to it. I have actually two macros listed that I can assign to it: Email WBAttached, and savesheet. I assigned Email WB attached doing step-by-step:

1. Open the Perishable 1st Shift Test File
2. Click the macro-assigned button - only email pops up
3. Click Developer tab then Visual Basic
4. Click Run - It saves the file and brings up the email.

EDIT: I see the problem now. This coding really in essence is two separate macros even though its pasted as one. I need to be able to assign two macros to one button. Is this possible?
EDIT 2: I created this macro:

Please Login or Register  to view this content.

This is running BOTH of these and I created a button and assigned macro2 to it. It is working perfectly!