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
--
תודה רבה
|