Remove marching ants after notepad macro opens notepad

So In this macro,

it post whatever is in cell A1 into a notepad...

I have two questions...

1. How do I have it so that the marching ants don't appear after the contents of cell A1 are posted into the notepad.?

2. Once the contents are posted into the notepad, Is there a way to have excel copy what's in the notepad?
Or is that pretty much the limit (as in once its out of excel into the notepad...)

see attachment

Originally Posted by noboffinme

Hi swade730,

I assume you mean the 'Marquee' when you say 'Marching Ants'?

You can Save the workbook to stop them 'Marching'

Cheers

Yes, I think marching ants sounds cooler though

-Thanks

Originally Posted by alansidman

swade730;
I'm with you. Look at this link http://spreadsheets.about.com/od/m/g/ants_def.htm
BTW: I use Leith's solution regularly.

Hahaha, Nice!

Leith's solution to apply

Please Login or Register  to view this content.

Does not work in this scenario.

Originally Posted by noboffinme

Hi swade730,

I assume you mean the 'Marquee' when you say 'Marching Ants'?

You can Save the workbook to stop them 'Marching'

Cheers

I've tried this as well. When you save the workbook, NOTHING gets pasted to the notepad! A trade-Off I can't afford...


Any other insight/workaround?

Originally Posted by Leith Ross

Hello swade730,

This is your code with a couple of changes: Added TRUE to SendKeys and included Application.CutCopyMode = False.

Adding True to SendKeys makes SendKeys wait until the active window has received the information before returning back to VBA. If you don't do this then VBA may clear the clipboard (that's what Application.CutCopyMode = false does) before the data is transferred to NotePad.

Please Login or Register  to view this content.

You should also explain more about what you want to do. Retrieving the data from Notepad is possible. Before I or anyone can help you with this, you need to provide clear details of what you want to do.

Thank You So much for the explanation...

The goal is to basically make it easier for me to copy from notepad the information I am pulling from the respective cell in excel.

If VBA pastes it to the notepad...I then have to go highlight it in the notepad...

It would boggle my mind if Once pasted to the notepad, I can have it so that it's highlighted and copied already from the notepad,
(Avoiding having to do this manually with my mouse).



So essentially from the macro, I am just pasting what ever went to the notepad...to my destination.

Leith Ross,
The API functions in your code do not relate to Windows Vista or later - the PtrSafe attribute requires VBA7 or later, so Office 2010 and forward. The Windows version does not in fact matter.

Originally Posted by Leith Ross

Hello swade730,

Copy the code below and paste it into a new VBA module in your workbook. Call the macro CopyNotepadToClipboard to copy ALL of Notepad to the clipboard.

Please Login or Register  to view this content.

Thank You sooo much. Sorry for the late response. I do appreciate this code.
Thank You!

Originally Posted by Leith Ross

Hello swade730,

You're welcome. Glad I could help out.

Nollaig chridheil!

(Scottish for "Merry Christmas!")

Merry Christmas...

one Last Question... What version of Excel is this good for again?

It works for but not for prior...

What would be the code to run this on a earlier version?

Originally Posted by Leith Ross

Hello swade730,

Here is the code for computers running VBA5 or VBA6.

Please Login or Register  to view this content.

Thank you, I will try and apply it and I will let you know how it goes... I really really appreciate it