Opening Notepad and Pasting, from Excel?

[Ste_Moore01]

Hello again,

I was wondering, is it possible to make a macro in Excel that copies the contents of column A then opens Notepad and pastes it?

I need this because we have dot matrix printer in work. If we printed to it from Excel it doesn't print correctly and will take ages to print, whereas if you print from Notepad it works perfectly.

Does anyone know whether this is possible?

 

[Ste_Moore01]

I've run your function and it lists the printers, but it isn't listing any printers on our server computer.

It lists all the printers on the other computers on our network though.

 

[Oorang]

The printer you want to print to needs to be mapped to the PC you are running your code on. If you go to the control panel and then go to printers is the printer listed? If not you need to add it.

 

[Ste_Moore01]

Yes it is listed.

I have all the printers on our network added on my computer but it doesn't list the ones on our server computer when I run your function.

It lists every printer on the network except the ones that are on the server computer.

 

[kokkentor]

Right_Click,
your suggestion is sweet! Kudos! Exactly what I was searching this forum for right now! I haven't tested the Oorang's yet.

 

[Gane27]

Hi when i copy and paste the code it create error. is there any working code.