Import sheets with picture

C

chschauss

Hi all,

In my active workbook, I have buttons that allow me to import spreadsheets from another workbooks located on my server.
Here is the code for these buttons:
Sheets.Add before: = Sheets ("Data"), _
Type: = GetSetting (appname: = "MyApp", section: = "Parameter", Key: = "DirPrint") & "MyFile.XLTM"

On the first page of these files (MyFile.xltm) is an picture (logo).

Here is my problem:
When these sheets are imported into my workbook, instead of seeing my picture, a white frame appears with the message "The linked picture can not be displayed. The file may Have Been Moved, renamed, or deleted. Verify que le link point to the right file and location "

I found that this problem occurs when imported Excel files are on a server,in a network environment.

Thank you in advance for your help and suggestions.

Have a nice day
Charles
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top