ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Getting own workbook (https://www.excelbanter.com/excel-programming/400402-getting-own-workbook.html)

Sonnich Jensen[_2_]

Getting own workbook
 
Hi!

Is there a way to get the workbook, where a module belongs to?

I need to get "myself" in a module. It creates a new workbook, but
still needs to work in its own stuff.

Tervitades
Sonnich


Bernie Deitrick

Getting own workbook
 
Sonnich,

Thisworkboook

When used in code, it always refers to the workbook containing the code.

HTH,
Bernie
MS Excel MVP


"Sonnich Jensen" wrote in message
oups.com...
Hi!

Is there a way to get the workbook, where a module belongs to?

I need to get "myself" in a module. It creates a new workbook, but
still needs to work in its own stuff.

Tervitades
Sonnich





All times are GMT +1. The time now is 12:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com