Save worksheet to document file name

Hi,

I have a macro called "Rapportage" stored in an Excel file called "Index".

This file is like a database and contains links to other xls files, e.g. "datasheet1".

When I run the macro Rapportage inside datasheet1 (Index file is open at the time), a "new workbook" is made with some data from datasheet1.
After that the file is saved and closed to a specific directory. (e.g. /rapportages/..)

I need this "new workbook" to have the same name as the datasheet...

this I tried with "ActiveWorkbook.name"

But instead the workbook is called index, the workbook name the macro is stored in.

Can anybody give me a tip, how I can save the new workbook with the workbook name the macro is ran from (datasheetX), and not the workbook the macro is stored in (index)?

thanks

Welcome to the forum.

Please Login or Register  to view this content.

... is the name of the workbook the code is running in.

Hey shg,

Thanks for the quick reply!

When I store this macro inside the worksheet index,

Please Login or Register  to view this content.

but run it in the worksheet datasheet, the filename of the "new worksheet" is still index.xls

sorry if I wasn't clear. The code is stored in index.xls but is operating on datasheet1.xls (name differs per file). I don't have the entire code at hand but this is what it comes down to :


Stored in index.xls

Please Login or Register  to view this content.

Ctrl+r is pressed in datasheet1.xls. This currently saves the new workbook under the name index.xls

Maybe like this:

Please Login or Register  to view this content.

Hi shg,

Excellent! Thanks for this code. Initially it didn't work because of a "same document name" coflict .. But I added a prefix to the new document name, and it works like a charm!