Results 1 to 4 of 4

"Save as" Macro to Network share

Threaded View

pjw23 "Save as" Macro to Network... 06-08-2011, 11:50 PM
Mordred Re: "Save as" Macro to... 06-08-2011, 11:58 PM
Mordred Re: "Save as" Macro to... 06-09-2011, 12:13 AM
pjw23 Re: "Save as" Macro to... 06-09-2011, 08:50 AM
  1. #1
    Registered User
    Join Date
    02-18-2004
    Posts
    55

    "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.
    Public Sub SaveAsC5()
        ThisFile = Range("C5").Value
        ActiveWorkbook.SaveAs Filename:="\\FileServ\Archive\" ThisFile
    End Sub
    Last edited by pjw23; 06-09-2011 at 12:01 AM.

Thread Information

Users Browsing this Thread

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

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