Application.SendKeys Alt Tab Not working

[lexusap]

Hi,

I have two Excel spreadsheet that i want to rotate to get data and paste it.
something like this (Alt Tab to spreadsheet 2 > Select sheet xyz > copy range > Alt tab to spreadsheet 1 > paste range) 20 times.

However i got an error at selecting worksheet (it seems like i am not in the spreadsheet 2 when application.send key got execute.)

error at sheets("CROSSTAB_1").select

Please Login or Register  to view this content.

any help would be appreciated.

Thanks
Lex

[Winon]

Hello lexusap,

Are you not maybe over complicating things a little? This can be done without Alt Tab and Send Keys.

Attach a sample workbook (not a picture or pasted copy).

Make sure there is just enough data to demonstrate your need.

Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Regards.

[Logit]

.
Hey Winon. You are up late ? early ?

[lexusap]

how would you do it without using send keys?
I want to make it as simple as possible to the end user, where they do not need to save the workbook , and using alt+tab copy paste would be a quick solutions.

Let me know what you think.

[Winon]

Hi lexusap,

I want to make it as simple as possible to the end user, where they do not need to save the workbook...

Exactly my point as well, but I don't know what else you may have in the Workbook, hence my request for a sample. It makes it much easier for us to assist, if you could attach a sample, instead of us having to create one based on guessing your setup, etc.

Regards.

[Winon]

@ Logit,

Hey there Buddy!

Yip, up since just after midnight with a toothache, and now you to make me even more miserable!

If i am up early, maybe that means you are up late?

Your'e o.k.?

[Logit]

.
Almost sleep time here for me. Sorry about your tooth.

Drink some home brew. Works every time !

[Winon]

The only brew I really enjoy, is a cuppa Java. Hate the taste of alcohol, although I may have some on occasion. But very seldom.

[lexusap]

Hi,

please see sample data, open up Hymix market data, select Macro and click on button Copy.

Thanks
Lex

[Winon]

Thank you lexusap,

Its about time.

I'll have a look, and get back to you, also taking my time. LOL

[lexusap]

Cheers - thanks Winon.

[Winon]

Hi lexusap,

In your original Post you refer to two Worksheets, when in fact it is actually two Workbooks. Big difference!

In your "Sub Macro2marketdata" you refer to "Hymix Market Data - JAN 18.xlsx", while you only have "Hymix Market Data - MAY18.xlsm"

Your Code will therefor not be able to locate "Hymix Market Data - JAN 18.xlsx"

Thus far my findings. Can you please clarify a bit more?

This may take longer to resolve with two Workbooks as opposed to Two Worksheets in one Workbook.

Thank you

[lexusap]

didn't realise i said 2 spreadsheets.. whoops my bad.

The naming of the workbooks will be replace by combo of Alt+Tab.

can i ask whether the first 13 line of code Macro1 works?

Please Login or Register  to view this content.

Thanks
Lex

[Winon]

Sorry lexusap,

Certain "Powers" on this forum do not appreciate me contributing the way I do, and I have decided to rather withdraw from this and all other Threads with immediate effect.

I trust someone else will come to your rescue.

So long!

[lexusap]

No worries. i think there is some misunderstanding that the macro i am referring to is called "Macro1" on Module 2 rather than "Macro2marketdata" on Module 1.

Cheers