Save As (2)

Ampleford · Mar 28th, 2002, 01:21 AM

What about Getting a value from the worksheet say "10", then saving the file as "Filename10.xls" I don't know how to get a value from a worksheet (even if it's named) to the VB editor screen for use in there..... Even how to use functions, like random generators in VB

Who can help

Share the Knowledge

[ This Message was edited by: Ampleford on 2002-03-28 00:21 ]

chaju · Mar 28th, 2002, 01:43 AM

Hello! Are you from UK? you know Ampleforth College in York? I wonder if your nick name comes from it

Ampleford · Mar 28th, 2002, 01:47 AM

No - It comes from my surname.

Although I do know about the College

AJ · Mar 28th, 2002, 05:33 AM

Hi,

All you need to do is split up the path/filename in the save as with & and add in either your variable, or your range.
i.e.

ActiveWorkbook.SaveAs Filename:="C:TESTFilename" & myVariable & ".xls", FileFormat:=xlNormal

ActiveWorkbook.SaveAs Filename:="C:TESTFilename" & Range("A1").value & ".xls", FileFormat:=xlNormal

Oh, and just to add, to get a value from a worksheet into a variable, you'd have something like

Dim myVariable As (whatever it is)

At the top of the macro

Then
myVariable = Range("A1").Value

etc.etc.

[ This Message was edited by: AJ on 2002-03-28 04:35 ]

Ampleford · Mar 29th, 2002, 02:30 AM

Thanks a lot - two really helpful hints there.

Cheers

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 28th, 2002, 01:21 AM	#1
Ampleford Board Regular Join Date: Mar 2002 Location: Scotland Posts: 341	What about Getting a value from the worksheet say "10", then saving the file as "Filename10.xls" I don't know how to get a value from a worksheet (even if it's named) to the VB editor screen for use in there..... Even how to use functions, like random generators in VB Who can help Share the Knowledge [ This Message was edited by: Ampleford on 2002-03-28 00:21 ]

Mar 28th, 2002, 01:43 AM	#2
chaju Board Regular Join Date: Mar 2002 Posts: 82	Hello! Are you from UK? you know Ampleforth College in York? I wonder if your nick name comes from it

Mar 28th, 2002, 01:47 AM	#3
Ampleford Board Regular Join Date: Mar 2002 Location: Scotland Posts: 341	No - It comes from my surname. Although I do know about the College

Mar 28th, 2002, 05:33 AM	#4
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	Hi, All you need to do is split up the path/filename in the save as with & and add in either your variable, or your range. i.e. ActiveWorkbook.SaveAs Filename:="C:TESTFilename" & myVariable & ".xls", FileFormat:=xlNormal ActiveWorkbook.SaveAs Filename:="C:TESTFilename" & Range("A1").value & ".xls", FileFormat:=xlNormal Oh, and just to add, to get a value from a worksheet into a variable, you'd have something like Dim myVariable As (whatever it is) At the top of the macro Then myVariable = Range("A1").Value etc.etc. [ This Message was edited by: AJ on 2002-03-28 04:35 ]

Mar 29th, 2002, 02:30 AM	#5
Ampleford Board Regular Join Date: Mar 2002 Location: Scotland Posts: 341	Thanks a lot - two really helpful hints there. Cheers