whats the syntax to save a file in a macro but use the file from within a cell
i.e. if cell A1 is the name I want to save the file as - how do I reference
that cell from within the macro?
whats the syntax to save a file in a macro but use the file from within a cell
i.e. if cell A1 is the name I want to save the file as - how do I reference
that cell from within the macro?
Try this:
Change the variable pathName to suit your needs.Please Login or Register to view this content.
HTH
Martin
Martin Short
Activeworkbook.SAveAs Filename = Worksheets("Sheet1").Range("A1")
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"ynissel" <[email protected]> wrote in message
news:[email protected]...
> whats the syntax to save a file in a macro but use the file from within a
cell
> i.e. if cell A1 is the name I want to save the file as - how do I
reference
> that cell from within the macro?
>
Let's put qwerty.xls in cell A1. Then:
Sub Macro1()
ChDir "C:\"
ActiveWorkbook.SaveAs Filename:="C:\" & Cells(1, 1).Value
End Sub
will do a save_as to your top-level directory.
--
Gary''s Student
"ynissel" wrote:
> whats the syntax to save a file in a macro but use the file from within a cell
> i.e. if cell A1 is the name I want to save the file as - how do I reference
> that cell from within the macro?
>
this is great - thanks! what would the syntax be if the range I want to name
is in a sheet called backup and the cell is A15?
Thanks again.
"Gary''s Student" wrote:
> Let's put qwerty.xls in cell A1. Then:
>
> Sub Macro1()
> ChDir "C:\"
> ActiveWorkbook.SaveAs Filename:="C:\" & Cells(1, 1).Value
> End Sub
>
> will do a save_as to your top-level directory.
> --
> Gary''s Student
>
>
> "ynissel" wrote:
>
> > whats the syntax to save a file in a macro but use the file from within a cell
> > i.e. if cell A1 is the name I want to save the file as - how do I reference
> > that cell from within the macro?
> >
Activeworkbook.SAveAs Filename = Worksheets("backup").Range("A15")
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"ynissel" <[email protected]> wrote in message
news:[email protected]...
> this is great - thanks! what would the syntax be if the range I want to
name
> is in a sheet called backup and the cell is A15?
> Thanks again.
>
> "Gary''s Student" wrote:
>
> > Let's put qwerty.xls in cell A1. Then:
> >
> > Sub Macro1()
> > ChDir "C:\"
> > ActiveWorkbook.SaveAs Filename:="C:\" & Cells(1, 1).Value
> > End Sub
> >
> > will do a save_as to your top-level directory.
> > --
> > Gary''s Student
> >
> >
> > "ynissel" wrote:
> >
> > > whats the syntax to save a file in a macro but use the file from
within a cell
> > > i.e. if cell A1 is the name I want to save the file as - how do I
reference
> > > that cell from within the macro?
> > >
What am I doing wrong?
my macro reads:
ChDir "S:\Underwriting\Secondary\Wholesale\WS Rate Sheets"
ActiveWorkbook.SaveAs Filename = Worksheets("Rate Sheet Backup").Range("A31")
Cell A31 reads:
="AFC Wholesale Rate Sheet
"&MONTH(TODAY())&"-"&DAY(TODAY())&"-"&YEAR(TODAY())
and Im getting a file name of false? when the macro runs.
Thanks again,
Yosef
"Bob Phillips" wrote:
> Activeworkbook.SAveAs Filename = Worksheets("backup").Range("A15")
>
>
> --
>
> HTH
>
> Bob Phillips
>
> (replace xxxx in the email address with gmail if mailing direct)
>
> "ynissel" <[email protected]> wrote in message
> news:[email protected]...
> > this is great - thanks! what would the syntax be if the range I want to
> name
> > is in a sheet called backup and the cell is A15?
> > Thanks again.
> >
> > "Gary''s Student" wrote:
> >
> > > Let's put qwerty.xls in cell A1. Then:
> > >
> > > Sub Macro1()
> > > ChDir "C:\"
> > > ActiveWorkbook.SaveAs Filename:="C:\" & Cells(1, 1).Value
> > > End Sub
> > >
> > > will do a save_as to your top-level directory.
> > > --
> > > Gary''s Student
> > >
> > >
> > > "ynissel" wrote:
> > >
> > > > whats the syntax to save a file in a macro but use the file from
> within a cell
> > > > i.e. if cell A1 is the name I want to save the file as - how do I
> reference
> > > > that cell from within the macro?
> > > >
>
>
>
ChDir "S:\Underwriting\Secondary\Wholesale\WS Rate Sheets"
ActiveWorkbook.SaveAs Filename:=Worksheets("Rate Sheet Backup").Range("A31")
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"ynissel" <[email protected]> wrote in message
news:[email protected]...
> What am I doing wrong?
> my macro reads:
> ChDir "S:\Underwriting\Secondary\Wholesale\WS Rate Sheets"
> ActiveWorkbook.SaveAs Filename = Worksheets("Rate Sheet
Backup").Range("A31")
>
> Cell A31 reads:
> ="AFC Wholesale Rate Sheet
> "&MONTH(TODAY())&"-"&DAY(TODAY())&"-"&YEAR(TODAY())
>
> and Im getting a file name of false? when the macro runs.
> Thanks again,
> Yosef
>
> "Bob Phillips" wrote:
>
> > Activeworkbook.SAveAs Filename = Worksheets("backup").Range("A15")
> >
> >
> > --
> >
> > HTH
> >
> > Bob Phillips
> >
> > (replace xxxx in the email address with gmail if mailing direct)
> >
> > "ynissel" <[email protected]> wrote in message
> > news:[email protected]...
> > > this is great - thanks! what would the syntax be if the range I want
to
> > name
> > > is in a sheet called backup and the cell is A15?
> > > Thanks again.
> > >
> > > "Gary''s Student" wrote:
> > >
> > > > Let's put qwerty.xls in cell A1. Then:
> > > >
> > > > Sub Macro1()
> > > > ChDir "C:\"
> > > > ActiveWorkbook.SaveAs Filename:="C:\" & Cells(1, 1).Value
> > > > End Sub
> > > >
> > > > will do a save_as to your top-level directory.
> > > > --
> > > > Gary''s Student
> > > >
> > > >
> > > > "ynissel" wrote:
> > > >
> > > > > whats the syntax to save a file in a macro but use the file from
> > within a cell
> > > > > i.e. if cell A1 is the name I want to save the file as - how do I
> > reference
> > > > > that cell from within the macro?
> > > > >
> >
> >
> >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks