Is it Possible to have excel show a different picture when it open than the excel logo?

[tonywatsonhelp]

HI Everyone,

Quick question.

I've seen lots of software documents in the past that use excel as there engine but are made to look like a unique document.

Is this easy to do, are there guides i can follow or is this too hard????

for example when you open the document insytead of it showing excel, could I have my own branding so it Opens with a picture of my Logo maybe call "Tony's Document"

anyway any ideas guides or siggestions would be helpfull

Thanks

Tony

 

[Yongle]

Have a look at this thread which deals with your question in some detail

 

[tonywatsonhelp]

Thanks Yongle,

This Workaround is perfect for what I want
How to procedd:

1- Place the excel file in a hidden location (ie: in a hard to find location) on the user's computer
2- Open Notepad and place the following vbscript code in it:
Code:
Set xlapp = CreateObject("Excel.Application")
xlapp.Visible = false
Set Wb = XlApp.Workbooks.Open("PUT_YOUR_EXCEL_FILE_FULL_PATH_NA_NAME_HERE")​

3- After writing the correct excel file path in the above script, save the vbscript with the ​

.VBS

extension in the same hidden location as that of the excel file
4- Create a shortcut to the VBS file and place it in the user's desktop (You can change the shortcut icon to show the excel icon by right clicking it and choosing Properties/Shortcut tab/Change Icon button)

Now, in order for the user to open the excel file , he/she will have to click on the vbscript shortcut located on the desktop and the latter will take care of opening the excel file without showing the excel splashscreen or the workbook - Just the userform will be on display

Thanks for heading me in the right direction

Tony
​

 

[Yongle]

Glad it helped
Thanks for posting your solution

 

[MohamedHasan]

thank you for the code.

i have one probs when i open the excel file. only shows sheets i can't see the panel ex: home, visual basic