Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
save\change sheet name
Hello,
We get emulation report on excel from oracle softwere and we link it to access database. we save (with excel macro ) the report to name that access "know", but it is not enough, because the sheet of the excei file change it's name with every report and access dont recognize those names. (it recogize the name 'sheet 1' ). How do i save the excel sheet name ( with macro code ) to the name 'sheet 1' witout having known the sheet name ? (original from emulation) Thank you -- תודה רבה |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
save\change sheet name
You can try this. If the sheet always the first sheet in the workbook, if so
you can use this to see the Sheet Name: Sub WksName() MsgBox Worksheets(1).Name End Sub or if you want to know the name of every worksheet in the workbook you can you this: Sub WksName() Dim i As Long For i = 1 To Worksheets.Count MsgBox Worksheets(i).Name Next i End Sub Hope this helps! -- Cheers, Ryan "יריב החביב" wrote: Hello, We get emulation report on excel from oracle softwere and we link it to access database. we save (with excel macro ) the report to name that access "know", but it is not enough, because the sheet of the excei file change it's name with every report and access dont recognize those names. (it recogize the name 'sheet 1' ). How do i save the excel sheet name ( with macro code ) to the name 'sheet 1' witout having known the sheet name ? (original from emulation) Thank you -- תודה רבה |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
save\change sheet name
I read what you wanted again and maybe this is what you wanted
Sub WksName() 'this will change the first sheets name to "Sheet1" Worksheets(1).Name = "Sheet1" End Sub Hope this helps! If so, please click "Yes" this was helpful. -- Cheers, Ryan "יריב החביב" wrote: Hello, We get emulation report on excel from oracle softwere and we link it to access database. we save (with excel macro ) the report to name that access "know", but it is not enough, because the sheet of the excei file change it's name with every report and access dont recognize those names. (it recogize the name 'sheet 1' ). How do i save the excel sheet name ( with macro code ) to the name 'sheet 1' witout having known the sheet name ? (original from emulation) Thank you -- תודה רבה |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
save\change sheet name
excellent,
that wkat i need thank you -- תודה רבה "RyanH" wrote: I read what you wanted again and maybe this is what you wanted Sub WksName() 'this will change the first sheets name to "Sheet1" Worksheets(1).Name = "Sheet1" End Sub Hope this helps! If so, please click "Yes" this was helpful. -- Cheers, Ryan "יריב החביב" wrote: Hello, We get emulation report on excel from oracle softwere and we link it to access database. we save (with excel macro ) the report to name that access "know", but it is not enough, because the sheet of the excei file change it's name with every report and access dont recognize those names. (it recogize the name 'sheet 1' ). How do i save the excel sheet name ( with macro code ) to the name 'sheet 1' witout having known the sheet name ? (original from emulation) Thank you -- תודה רבה |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent color change open/save sheet? | Excel Discussion (Misc queries) | |||
Save, save as, page setup dimmed out in unprotected excel sheet? | Excel Discussion (Misc queries) | |||
Save File to Another Directory, but not change Users File Save location | Excel Programming | |||
is it possible to change this macro to save each sheet seperately? | Excel Programming | |||
Why system asks me to save change even after I call save method(VB.NET) | Excel Programming |