Horizontal Scroll Bar Control in Excel via Invoke VB

Help Studio
, ,
1

Hi everyone,

i need to control of the horizontal scroll bar in excel via vb.

How can i control with code?

Thanks.

2

Hi @Kuki_Force ,

Could you let us know the use case that you are trying to perform ?

Do note that we could perform background operations for reading or modifying the data in an Excel file and it would be troublesome or not recommended to go for UI Automation unless it is really required.

3

Hi,

i have excel with some datas and tables. Iā€™m taking screenshot table but when i open the excel horizontal scroll bar starts from right side I mean lets say starts from z column. It should starts from at the beginning of left side in excel meaning A column.
How can i control the horizontal bar? via vb code.

NOT : I can control the vertical scroll Bar.

If you need more info or clarification, let me know it.

Thank you.

4

Hey

can you give a try with mouse scroll activity, setting the direction to left and the distance or also until reach the element you need?
image

Regards!

1 Like
5

Hi,

Thnx for idea and response. But i need to write a code. I cannot use activity.

Regards!

6

I found the answer.

You can try this => xlsApp.ActiveWindow.SmallScroll(0,0,0,100)

(0,0,0,100) => (To Down(Optional),To Up(Optional),To Right(Optional),To Left(Optional))

0 mean => Nothing
100 mean => At the Beginning, Highest(For Up) or Lowest(For Down)

xlsApp => Microsoft.Office.Interop.Excel.Application

Regards!

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.