cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jb0100
New Member

Send keys in excel, Curly brackets key is registered as text and not as parto of an expression, eg. {Enter}

Screenshot 2022-11-23 202226.jpg

 

Sending this to excel, the problem is that Alt works but after that the Curly brackets "{}" keys are counted as text, so excel makes a sound as if I pressed an "illegal" character.

 

Used a keylogger and ran the macro and the keypresses came out as: 

VK codesPositionKey
A4downLEFT ALT
A4upLEFT ALT
A0downshift
DBdown{
DBup{
A0upshift
58downX
58upX
A0downshift
DDdown}
DDup}
A0upshift
58downX
58upX
A0downshift
DDdown}
DDup}
A0upshift
A0downshift
DBdown{
DBup{
A0upshift
32down2
32up2
A0downshift
DDdown}
DDup}
A0upshift
32down2
32up2
A0downshift
DDdown}
DDup}
A0upshift
0DdownEnter
0DupEnter
09downTab
09upTab
0DdownEnter
0DupEnter
0DdownEnter
0DupEnter

 

So im totally lost... 

1 ACCEPTED SOLUTION

Accepted Solutions

Great! you can close the thread if its resolved now.

View solution in original post

3 REPLIES 3
VJR
Super User
Super User

I do not see any key as x when pressed even manually in Excel and it gives a sound of an illegal character.

VJR_0-1669262245588.png

 

 

So what is the x after the Alt in your message?

And which menu are you trying to activate?

 

jb0100
New Member

Hello

 

Its de add-ins menu.

 

I figured it out, {Alt}x2{enter}..... worked.

 

Thanks!!

 

Great! you can close the thread if its resolved now.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,469)