Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Command code
Hello,
I'll try to explain what I want a command to perform, any help would be greatly appreciated. I have a file "RCA TRIGGERS.XLSM" I want to add a command button that when I hit it, it does the following. Copy the current sheet to the end of the workbook, name the new tab by date and time, clear out the old form, and then re-save the file. I tried to record a macro to do this and almost had it. The only problem was that I can't name the tab with the characters that are used in a date and time. The second command I want is to hit a button that opens E-mail, attaches the current sheet as an attachment, and sends the sheet to a specific distribution list. Any help will be valued. -- Thank you for your time! John |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Command code
Option Explicit
Sub testme() ActiveSheet.Copy _ after:=Sheets(Sheets.Count) 'the new sheet is now the activesheet ActiveSheet.Name = Format(Now, "yyyy-mm-dd_hh-mm-ss") End Sub There are characters and names you can't use when you name a sheet. I liked this format of the date/time. But you may want to change to something you like. Very Basic User wrote: Hello, I'll try to explain what I want a command to perform, any help would be greatly appreciated. I have a file "RCA TRIGGERS.XLSM" I want to add a command button that when I hit it, it does the following. Copy the current sheet to the end of the workbook, name the new tab by date and time, clear out the old form, and then re-save the file. I tried to record a macro to do this and almost had it. The only problem was that I can't name the tab with the characters that are used in a date and time. The second command I want is to hit a button that opens E-mail, attaches the current sheet as an attachment, and sends the sheet to a specific distribution list. Any help will be valued. -- Thank you for your time! John -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Command code
You guys in here are incredible, I've been trying to figure this out for
hours. Thank you! -- Thank you for your time! John "Dave Peterson" wrote: Option Explicit Sub testme() ActiveSheet.Copy _ after:=Sheets(Sheets.Count) 'the new sheet is now the activesheet ActiveSheet.Name = Format(Now, "yyyy-mm-dd_hh-mm-ss") End Sub There are characters and names you can't use when you name a sheet. I liked this format of the date/time. But you may want to change to something you like. Very Basic User wrote: Hello, I'll try to explain what I want a command to perform, any help would be greatly appreciated. I have a file "RCA TRIGGERS.XLSM" I want to add a command button that when I hit it, it does the following. Copy the current sheet to the end of the workbook, name the new tab by date and time, clear out the old form, and then re-save the file. I tried to record a macro to do this and almost had it. The only problem was that I can't name the tab with the characters that are used in a date and time. The second command I want is to hit a button that opens E-mail, attaches the current sheet as an attachment, and sends the sheet to a specific distribution list. Any help will be valued. -- Thank you for your time! John -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
command code ( GOTO command) in formula | New Users to Excel | |||
Code for Command Buttons | Excel Discussion (Misc queries) | |||
Code question for clearing a command checkbox. | Excel Discussion (Misc queries) | |||
VBA code behind command button | Excel Worksheet Functions | |||
Command Button VBA code | Excel Discussion (Misc queries) |