VBA String variable paste into separate application

**Jimbo77** · 05-17-2014, 08:18 AM

hello all

is it possible to have a string variable within the vba code and then take this variable and paste it into another application?

I had thought of placing the string variable in a new sheet and then copying it but I want the new sheet to be deleted and this clears the memory.

Any thoughts?

Jim

**HaHoBe** · 05-17-2014, 08:21 AM

Hi, Jim,

what other application, what do you want to pass, is the other application driven by VBA as well?

Ciao,
Holger

**Jimbo77** · 05-17-2014, 12:14 PM

Hello Holger

No the other application is non vba unfortunately...

Any thoughts?

Jim

**HaHoBe** · 05-17-2014, 03:43 PM

Hi, Jim,

maybe you could use the ClipBoard for getting the data over, or pass the data as a paramneter (maybe using Shell).

Ciao,
Holger

**Jimbo77** · 05-17-2014, 05:19 PM

how would I do that?

**HaHoBe** · 05-18-2014, 03:19 AM

Hi, Jim,

has that anything to do with http://www.excelforum.com/excel-prog...n-website.html You would need to pass any information about what oyu wan tot pass as well as maybe the application and how this application awaits the information.

Ciao,
HOlger

**Jimbo77** · 05-18-2014, 04:35 AM

I really just want the variable string to be on the clipboard, the macro ends, then the user pastes the contents manual using ctrl and v into the other application.

Is this possible?

**Jimbo77** · 05-18-2014, 04:37 AM

I really just want the variable string to be on the clipboard, the macro ends, then the user pastes the contents manual using ctrl and v into the other application.

Is this possible?