Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Export to excel

Hello friends,

As I have a macro from QV to export excel in the platform of (Windows XP and Mo-office 2010) its working fine but the same code in Windows 7, the image color is filled with a colour and not able to see the image for instance if you see in the attached test.xlsx file "Summary of Data" background is filled with Black colour.

Is there any workaround for this...

Regards

Chriss

1 Reply
Not applicable
Author

Hello Friends,

Can anybody help me out from this issue, I tried the following code that is alos not helpless

if (pasteMode = "image") then

                              With objExcelApp.Selection

                               .Interior.Color= RGB(25,25,112)

                              End With                    

                    end if     

Could you please suggest any solution for this.............