Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Saving a file using a specific name in a cell
I would like to direct users to fill a cell in a sheet with their Login name.
The value of this cell will then be used as the filename to save the spreadsheet. Can anyone help me to automate this process! I tried the following sub from a previous answer but it crashes my excel! sub foo() with activeworkbook .saveas filename:=.worksheets("sheet1").range("A1").value end with end sub |
#2
|
|||
|
|||
Works for me.
Do you mean "crashes" as in shuts down? Any error message(s)? Do you have a sheet1? Any invalid characters in A1? Gord Dibben Excel MVP On Thu, 24 Feb 2005 10:03:11 -0800, "SU" wrote: I would like to direct users to fill a cell in a sheet with their Login name. The value of this cell will then be used as the filename to save the spreadsheet. Can anyone help me to automate this process! I tried the following sub from a previous answer but it crashes my excel! sub foo() with activeworkbook .saveas filename:=.worksheets("sheet1").range("A1").value end with end sub |
#3
|
|||
|
|||
The Program Error prompt is shown followed by closure of Excel.
"Gord Dibben" wrote: Works for me. Do you mean "crashes" as in shuts down? Any error message(s)? Do you have a sheet1? Any invalid characters in A1? Gord Dibben Excel MVP On Thu, 24 Feb 2005 10:03:11 -0800, "SU" wrote: I would like to direct users to fill a cell in a sheet with their Login name. The value of this cell will then be used as the filename to save the spreadsheet. Can anyone help me to automate this process! I tried the following sub from a previous answer but it crashes my excel! sub foo() with activeworkbook .saveas filename:=.worksheets("sheet1").range("A1").value end with end sub |
#4
|
|||
|
|||
I have sheet1 and have a name in cell A1.
"Gord Dibben" wrote: Works for me. Do you mean "crashes" as in shuts down? Any error message(s)? Do you have a sheet1? Any invalid characters in A1? Gord Dibben Excel MVP On Thu, 24 Feb 2005 10:03:11 -0800, "SU" wrote: I would like to direct users to fill a cell in a sheet with their Login name. The value of this cell will then be used as the filename to save the spreadsheet. Can anyone help me to automate this process! I tried the following sub from a previous answer but it crashes my excel! sub foo() with activeworkbook .saveas filename:=.worksheets("sheet1").range("A1").value end with end sub |
#5
|
|||
|
|||
I don't see how the code would cause Excel to throw a Program Error then shut
down. Any chance the users don't have permission to save to the default path? On a Network? Just started happening recently? Gord On Thu, 24 Feb 2005 11:33:02 -0800, "SU" wrote: The Program Error prompt is shown followed by closure of Excel. "Gord Dibben" wrote: Works for me. Do you mean "crashes" as in shuts down? Any error message(s)? Do you have a sheet1? Any invalid characters in A1? Gord Dibben Excel MVP On Thu, 24 Feb 2005 10:03:11 -0800, "SU" wrote: I would like to direct users to fill a cell in a sheet with their Login name. The value of this cell will then be used as the filename to save the spreadsheet. Can anyone help me to automate this process! I tried the following sub from a previous answer but it crashes my excel! sub foo() with activeworkbook .saveas filename:=.worksheets("sheet1").range("A1").value end with end sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use a cell as a referance to a file in a lookup statemen. | Excel Worksheet Functions | |||
Saving file to a specific folder | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |