| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem: vba code for creating a button to save worksheet as Cell
Public Sub SaveAsA1() ThisFile = Range("A1").Value ActiveWorkbook.SaveAs Filename:=ThisFile End Sub I have created a button that would save the worksheet as the value in cell A1. I keep getting an error with the above code. Can someone point out where I am going wrong , and suggest an alternative way of coding for this cmd. Thanks, Steve |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem: vba code for creating a button to save worksheet as Cell
What's the value in A1?
If you put the date in there, remember that you can't use slashes in filenames--at least in Windows. caldog wrote: Public Sub SaveAsA1() ThisFile = Range("A1").Value ActiveWorkbook.SaveAs Filename:=ThisFile End Sub I have created a button that would save the worksheet as the value in cell A1. I keep getting an error with the above code. Can someone point out where I am going wrong , and suggest an alternative way of coding for this cmd. Thanks, Steve -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem: vba code for creating a button to save worksheet as C
Always the word 'Current' and then a three digit number, with no slashes or
hyphens in it or spaces. Example: 'Current112' Steve "Dave Peterson" wrote: What's the value in A1? If you put the date in there, remember that you can't use slashes in filenames--at least in Windows. caldog wrote: Public Sub SaveAsA1() ThisFile = Range("A1").Value ActiveWorkbook.SaveAs Filename:=ThisFile End Sub I have created a button that would save the worksheet as the value in cell A1. I keep getting an error with the above code. Can someone point out where I am going wrong , and suggest an alternative way of coding for this cmd. Thanks, Steve -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem: vba code for creating a button to save worksheet as C
Maybe you're looking at the wrong worksheet?
ThisFile = activeworkbook.worksheets("Sheet1").Range("A1").Va lue If that doesn't help, maybe you can post the exact error you get. caldog wrote: Always the word 'Current' and then a three digit number, with no slashes or hyphens in it or spaces. Example: 'Current112' Steve "Dave Peterson" wrote: What's the value in A1? If you put the date in there, remember that you can't use slashes in filenames--at least in Windows. caldog wrote: Public Sub SaveAsA1() ThisFile = Range("A1").Value ActiveWorkbook.SaveAs Filename:=ThisFile End Sub I have created a button that would save the worksheet as the value in cell A1. I keep getting an error with the above code. Can someone point out where I am going wrong , and suggest an alternative way of coding for this cmd. Thanks, Steve -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem: vba code for creating a button to save worksheet as Cell
Public Sub SaveAsA1() Activeworkbook.SaveAs (Range("A1")) End Sub |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem: vba code for creating a button to save worksheet as C
This is the error message I get:
[ Run-time error '91': Object variable or With block variable not set ] "Dave Peterson" wrote: Maybe you're looking at the wrong worksheet? ThisFile = activeworkbook.worksheets("Sheet1").Range("A1").Va lue If that doesn't help, maybe you can post the exact error you get. caldog wrote: Always the word 'Current' and then a three digit number, with no slashes or hyphens in it or spaces. Example: 'Current112' Steve "Dave Peterson" wrote: What's the value in A1? If you put the date in there, remember that you can't use slashes in filenames--at least in Windows. caldog wrote: Public Sub SaveAsA1() ThisFile = Range("A1").Value ActiveWorkbook.SaveAs Filename:=ThisFile End Sub I have created a button that would save the worksheet as the value in cell A1. I keep getting an error with the above code. Can someone point out where I am going wrong , and suggest an alternative way of coding for this cmd. Thanks, Steve -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem: vba code for creating a button to save worksheet as C
What is the line that causes the error?
yasser wrote: This is the error message I get: [ Run-time error '91': Object variable or With block variable not set ] "Dave Peterson" wrote: Maybe you're looking at the wrong worksheet? ThisFile = activeworkbook.worksheets("Sheet1").Range("A1").Va lue If that doesn't help, maybe you can post the exact error you get. caldog wrote: Always the word 'Current' and then a three digit number, with no slashes or hyphens in it or spaces. Example: 'Current112' Steve "Dave Peterson" wrote: What's the value in A1? If you put the date in there, remember that you can't use slashes in filenames--at least in Windows. caldog wrote: Public Sub SaveAsA1() ThisFile = Range("A1").Value ActiveWorkbook.SaveAs Filename:=ThisFile End Sub I have created a button that would save the worksheet as the value in cell A1. I keep getting an error with the above code. Can someone point out where I am going wrong , and suggest an alternative way of coding for this cmd. Thanks, Steve -- Dave Peterson -- Dave Peterson -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem: vba code for creating a button to save worksheet as Cell
caldog wrote: Public Sub SaveAsA1() ThisFile = Range("A1").Value ActiveWorkbook.SaveAs Filename:=ThisFile End Sub I have created a button that would save the worksheet as the value in cell A1. I keep getting an error with the above code. Can someone point out where I am going wrong , and suggest an alternative way of coding for this cmd. Thanks, Steve Your going to need something like : Public Sub SaveAsA1() ThisFile = Range("A1").Value ActiveWorkbook.SaveAs with .Filename:=ThisFile end with End Sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating a button to activate another worksheet within a workbook | Excel Programming | |||
| Creating a Command Button on a worksheet | Excel Discussion (Misc queries) | |||
| Creating some sort of button that will take you to a new worksheet | New Users to Excel | |||
| Great Code : Need Modification - VBA Save Button | Excel Programming | |||
| save button in excel to save one of the worksheets with a cell value as its name | Excel Programming | |||
Linear Mode
