"Save as" Macro to Network share

Wanted to see if I could get some assistance. I'm trying to create a Macro that will Save my worksheet to a network share as a Macro Enabled worksheet with a file name based on the contents of Cell Value C5.

I'm relatively new to VB so be easy...I've searched around a little but can't really find what I'm looking for. Any ideas. I was originally trying to work with the below code, but keep getting compile errors.

Please Login or Register  to view this content.

hi pjw23 and welcome to the forum. Please take a moment or two to read the forum rules located here. Specifically, read rule #3 and use code tags around your code. Thanks.

Thanks! A couple of things to start with.
1. Does the value in C5 have an extension like .xls or xlsx?The following code assumes that it does not have an extension.

Please Login or Register  to view this content.

This code declares Sheet 1 as the sheet to use for the C5 value. If it differs from yours, change it accordingly. Also, notice the filename after wb.SaveAs, you have to declare the drive (in my case it is G:\) and then also notice the "&" that is used twice. Depending on your version, you have to declare the proper extension. If your version is 2003, us .xls. I am using 2010 so that is why I used .xlsm

Regards: