View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Print "ActiveWorkbook.FullName" always.....but

Hi
then isert this in a new workbook. save this workbook as template
(*.xlt file9 and use this template for your future workbooks

--
Regards
Frank Kabel
Frankfurt, Germany

"Dante" schrieb im
Newsbeitrag ...

"Frank Kabel" ha scritto nel messaggio
...
Hi
this has to go in your workbook module:
- open your file
- hit ALT+F11 to open the VBA Editor
- locate in the left window your project and double click on the

item
'ThisWorkbook'
- paste the code in this module
- close the VBA Editor, save the file and try it


hi
i want it work in *all* workbook (past e future) .
is possible ?
thk for reply