Insert Logo into Query

[Former Member]

Hi All,

I have searched the SDN forum and seen only a few posts for inserting a logo into a query, but still not 100% sure.

Basically, how to insert a logo into a query that will be there everytime the query is ran? Not a workbook, but a query. Also, how to get it into a specific cell?

Cheers, Mike

[former_member188975 · Accepted solution]

Hi Mike,

Not sure if you read this on creating a workbook template:

but you can have a logo on the report when you execute the query if you set it up in a workbook, and set this workbook as the one into which queries will embed when executed.

Is this what you are looking for...?

[Former Member · Accepted solution]

Hi Bhanu,

I saw this thread, but still don't quite understand.

We are a retail company and have many different divisions. Each division has it's own "logo" they want on their own queries.

Can you give me the exact steps to accomplish this. I've tried reading the thread you mentioned and could not get it to work.

Thanks again

Mike

[former_member188975 · Accepted solution]

And different divisions don't run workbooks...I mean does everyone execute queries directly?

[Former Member · Accepted solution]

Yes, everyone runs queries.

I put the select from list option and I can see the "workbook" that has formatting. Meaning...

1. I ran a query and inserted logo, formatted font

2. Saved as a workbook

3. In Analyzer I selected Settings -> New Workbook on Embed

4. Now open query

5. I get the popup to select my query...I select it

6. I now get an option to select the workbook to embed my query in...I select it and all the formatting and logo is there.

So...

Is this how it works? If so, When selecting the workbook to embed my query in it still has all the data/result from last query run. Is there anyway not to have this "old" data show up? In other words, is there a way to create several default workbooks (to embed different queries in from different divisions), so when different divisions run different queries, they can select their "formatting workbook".

Example:

Shoes would have their "Shoe Workbook"

Pants would have their "Pant Workbook"

Thanks,

Mike

[former_member188975 · Accepted solution]

Hi Mike,

You could create a template workbook for each division and educate the users how to maintain the setting in their Bex. Then whenever they run a query, the appropriate logo will be displayed.

Hope this helps...

[Former Member · Accepted solution]

Hi Bhanu,

I will award full points after this last question, thanks as always

So is the above correct in how the system is behaving? If so, what about the "old data" showing up? When you say educate users to maintain the setting in BEX...do you mean to select their own "workbook" to embed the query in?

Thanks again, much appreciate, Mike

[former_member188975 · Accepted solution]

OK...so in the Settings button you can Set New Workbooks when embedding is Based on Permanent Workbook template. In the same place you can set the workbook which is to be the Permanent Workbook Template.

So each Div has its own Permanent Workbook Template and users in each Div need to make this setting Once Only.

Now about the old data...when you create the workbook template, just open a excel workbook and insert your logo in the desired cell, and make sure when you save it that the cell which is active will be where the query starts from. Not to confuse you , but if you happen to leave cell D13 selected, your query will start from there.

Hope this helps...

[Former Member · Accepted solution]

Perfect explanation!

Cheers Mate

[edwin_harpino]

hi Mike,

also not sure

try put code on refresh ?

Range("[colum row").Select

ActiveSheet.Pictures.Insert("filepath").Select

e.g

Range("C3").Select

ActiveSheet.Pictures.Insert("C:\company\logo.bmp").Select

• ... still you need workbook ...

hope this helps.