Capture "Save As" Pathname and Save another File.

I have an excel workbook that uses a .bmp file [a picture]. The master excel file and the .bmp file are in the same directory on the network. The excel file is "Read-Only", so the user would open it, customize it and save it on their own computer or somewhere else on the network.

They are only allowed to save it under "Save As". Once the user saves it, they would then be able to use their customized copy for future updates etc. The problem is that the .bmp file is missing from this new directory.

Is there a way to automatically save a copy of the .bmp file under the Directory specified by the user, so it's always available when the Excel workbook is opened? Or is there a way to attach the .bmp file to the excel file, so they are always saved together?

Hope someone can help me or point me in the right direction.

Thanks,
modytrane.

How does the workbook 'use' the bitmap?

The trouble is you do not know the location of where the file is going to be saved if you try and code for it in the BeforeSave event.

You could try testing for the file in the BeforeClose event. But in order to do that you need to know where to copy the bmp from. If you know where to copy the bmp from then you could do the copy within the code you posted.

In Thisworkbook object.

Please Login or Register  to view this content.