Tableau Desktop Keyboard Shortcuts

[turnercj65]

Here is a script to hack in some more keyboard shortcuts to Tableau Desktop!

Code: Select all

#SingleInstance force

SetTitleMatchMode 1

#ifWinActive Tableau

; ctrl-shift C = Create Calculated Field
^+C::
ClickMenuItem(301, 40, 373, 428)
return

; ctrl-shift D = View Data
^+D::
ClickMenuItem(301, 40, 339, 129)
return

; ctrl-shift P = Publish Workbook
^+P::
ClickMenuItem(447, 40, 504, 112)
return

; ctrl-shift Home = move pill to dimensions shelf
^+Home::
MouseGetPos, x, y ;get current position of mouse to reset the mouse after hot key
SendEvent {Click %x%, %y%, down}{click 100, 400, up} ;click and drag to dimensions and let go
MouseMove %x%, %y%, 0 ;restore mouse position
return

; ctrl-shift R = Rename field
^+R::
MouseGetPos, x, y
MouseClick, right, %x%, %y%
Sleep, 75
x+= 75
y+=95
MouseMove %x%, %y%, 0
MouseClick, left
x-= 75
y-=95
MouseMove %x%, %y%, 0
return


ClickMenuItem(menuButtonX, menuButtonY, menuItemX, menuItemY)
{
	MouseGetPos, x, y ;get current position of mouse to reset the mouse after hot key
	MouseMove, menuButtonX, menuButtonY, 0 ;move mouse to menu button on toolbar
	MouseClick, left ;click on appropriate menu button
	MouseMove, menuItemX, menuItemY, 0 ;move mouse to menu item
	MouseClick, left ;click on appropriate menu item
	MouseMove %x%, %y%, 0 ;restore mouse position
} ;end ClickMenuItem

[Joe Glines]

I'm using Tableau and there is no hotkey for exporting images. The following will copy the default image to clipboard and paste to PowerPoint if it exists.

Code: Select all

sleepy:=75
;************************************************************
if WinActive("ahk_class Qt5QWindowIcon"){
Send, {Alt}
sleep, sleepy
send, w ;select Worksheet option
sleep, sleepy
send, c ;Select copy option
sleep, sleepy
send, i ;select image option
sleep, sleepy
send {Enter} ;click the copy button

;***********paste into PowerPoint *******************
If WinExist("ahk_class PPTFrameClass")
{
WinActivate
sleep, sleepy
    Send, ^v
}
}

[StevieD]

Any idea if the copy and paste function still works? I've tried it and it doesn't seem to?

[Joe Glines]

I used this not too long ago. It automated exporting the images and saving them to the hard drive

Code: Select all

sleepy:=100
;************************************************************
if WinActive("ahk_class Qt5QWindowIcon"){
MouseClick, left, 873 ,156
sleep, sleepy
Send, {Alt}
sleep, sleepy
send, w ;select Worksheet option
sleep, sleepy
send, e ;Select copy option
sleep, sleepy
send, i ;select image option
sleep, sleepy
send {Enter} ;click the copy button

WinWaitActive, Save Image,,2
ControlClick, Save, Save Image
}