| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
create a macro to automaticaly name a file.
I need to have control over file naming in a worksheet would like to be able
to do this by assiging a macro to a button. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
create a macro to automaticaly name a file.
Write a macro containing something like
ActiveWorkbook.SaveAs "C:\Temp\MyFile.xls" and assign it to your button. HTH. Best wishes Harald "bh" skrev i melding ... I need to have control over file naming in a worksheet would like to be able to do this by assiging a macro to a button. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
create a macro to automaticaly name a file.
Harald: Is it possible to pull the information out of a cell entered in the
worksheet? Thanks BH "Harald Staff" wrote: Write a macro containing something like ActiveWorkbook.SaveAs "C:\Temp\MyFile.xls" and assign it to your button. HTH. Best wishes Harald "bh" skrev i melding ... I need to have control over file naming in a worksheet would like to be able to do this by assiging a macro to a button. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
create a macro to automaticaly name a file.
Write a macro containing something like
ActiveWorkbook.SaveAs Activesheet.Range("B9").Value where cell B9 contains the string C:\Temp\MyFile.xls -- Regards, Tom Ogilvy "BH" wrote in message ... Harald: Is it possible to pull the information out of a cell entered in the worksheet? Thanks BH "Harald Staff" wrote: Write a macro containing something like ActiveWorkbook.SaveAs "C:\Temp\MyFile.xls" and assign it to your button. HTH. Best wishes Harald "bh" skrev i melding ... I need to have control over file naming in a worksheet would like to be able to do this by assiging a macro to a button. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
create a macro to automaticaly name a file.
Tom:
Were do I inserte the file path. "Tom Ogilvy" wrote: Write a macro containing something like ActiveWorkbook.SaveAs Activesheet.Range("B9").Value where cell B9 contains the string C:\Temp\MyFile.xls -- Regards, Tom Ogilvy "BH" wrote in message ... Harald: Is it possible to pull the information out of a cell entered in the worksheet? Thanks BH "Harald Staff" wrote: Write a macro containing something like ActiveWorkbook.SaveAs "C:\Temp\MyFile.xls" and assign it to your button. HTH. Best wishes Harald "bh" skrev i melding ... I need to have control over file naming in a worksheet would like to be able to do this by assiging a macro to a button. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
create a macro to automaticaly name a file.
if B9 contains the string C:\Temp\MyFile.xls
then C:\Temp\ is the file path. The activeworkbook is saved to the C:\Temp directory with a filename of MyFile.xls -- Regards, Tom Ogilvy "BH" wrote in message ... Tom: Were do I inserte the file path. "Tom Ogilvy" wrote: Write a macro containing something like ActiveWorkbook.SaveAs Activesheet.Range("B9").Value where cell B9 contains the string C:\Temp\MyFile.xls -- Regards, Tom Ogilvy "BH" wrote in message ... Harald: Is it possible to pull the information out of a cell entered in the worksheet? Thanks BH "Harald Staff" wrote: Write a macro containing something like ActiveWorkbook.SaveAs "C:\Temp\MyFile.xls" and assign it to your button. HTH. Best wishes Harald "bh" skrev i melding ... I need to have control over file naming in a worksheet would like to be able to do this by assiging a macro to a button. |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
create a macro to automaticaly name a file.
I do not have a lot of experience attaching documents. I am applying for a
job and I have to attach all my documents and it keeps coming back as an error "bh" wrote: I need to have control over file naming in a worksheet would like to be able to do this by assiging a macro to a button. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel file opened automaticaly at specified time & date | Excel Discussion (Misc queries) | |||
| Can you automaticaly save a shared file every few mintues? | Excel Discussion (Misc queries) | |||
| Automaticaly create montly calendars for 30 employees | Excel Discussion (Misc queries) | |||
| macro to save file automaticaly? | Excel Discussion (Misc queries) | |||
| Excel File To update Automaticaly | Excel Programming | |||
Hybrid Mode
