Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excel macro export to freeze panes

I am trying to freeze panes using excel code but it isn't working.

I tried the following codes:

1.

XLDoc.Sheets(LCR).Range("F5").FreezePanes = True

2.

With XLDoc.Sheets(LCR).Range("F5").Select

        XLDoc.Sheets(LCR).FreezePanes = True

end with

Can anyone tell me what I am doing wrong?

Thank you!!!!

7 Replies
m_woolf
Master II
Master II

Is LCR the sheet name? If so, it must be enclosed in quotes.

Not applicable
Author

Yes it is the sheet name.  This is only part of the code that I pasted in and that is not the problem.  The problem lies with the freeze panes.

m_woolf
Master II
Master II

XLApp.ActiveWindow.FreezePanes = True

Not applicable
Author

It works!  But can you tell me how I can freeze it at cell F5?

m_woolf
Master II
Master II

Select cell F5 before executing the freeze panes command.

Not applicable
Author

I got it! 

XLDoc.Sheets(LCR).Range("F" &  5).Select

XLApp.ActiveWindow.FreezePanes = True

all in qlikview's vbscript

Thank you!!!

Anonymous
Not applicable
Author

Hi ,

How to freeze entire first row for me it is working but from 11th line the scroll  is enabled

Regards,

Siva