Saving worksheet

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • hunter1978
    New Member
    • May 2006
    • 8
    #1

    Saving worksheet

    Hi there,

    I wonder if somebody can help me.

    I'm after some code that will allow me to save a worksheet to a network location that is specified in a cell (A1) and also call the worksheet a name that is specified in another cell (B8).

    I know you need to use the 'ActiveWorkbook .SaveAs Filename' command but I just can't seem to get it right.

    Many thanks in advance.
    Tags: None
    • willakawill
      Top Contributor
      • Oct 2006
      • 1646
      #2
      Originally posted by hunter1978
      Hi there,

      I wonder if somebody can help me.

      I'm after some code that will allow me to save a worksheet to a network location that is specified in a cell (A1) and also call the worksheet a name that is specified in another cell (B8).

      I know you need to use the 'ActiveWorkbook .SaveAs Filename' command but I just can't seem to get it right.

      Many thanks in advance.
      You might try saving it locally first so that your method works and then see if you can get the network address correct

        Comment

        Previous template Next
        Working...