Copy, Modify, Paste, Send to CNC machine

[camle]

I have come up with an excel sheet to program a CNC machine at work. It reads a database (Main Data Mag Cyl) for different prints.
My question is: I need a VB code to copy A7:C616 and copy it to sheet name Edit - Send with (tabs and empty spaces) removed. From here I would like to send it to the com port to the CNC machine, also a pop-up windows asking if the machine is ready.
Hope you don't mind helping. Thanks

 

[camle]

You are the man!!
Thanks!!

 

[camle]

Works Great!!! Thanks Again

 

[camle]

Works Great!!
Thanks Again

 

[Teeroy]

Sorry camle, I thought you wanted the data deleted from the write string (which is what ignoring the line did) rather than needing it removed from the sheet. Oh well, John_w got you sorted.

 

[camle]

It's ok I thank both of for the help

 

[camle]

test is this thing going to the right place in the thread

 

[camle]

test is this thing going to the right place in the thread

ok that worked very good.
I'm trying to understand the code.......
can you give me the code to get the cells and send them to the port?

I split your code so that I can give them a chance to edit it before it goes to the machine.
now I need to send what has been edited.
Thanks

 

[Teeroy]

Everything after the line asking "is the machine ready" is the writing of the data so you could run that after the edit. If you break that into a second sub don't forget you''ll have to redefine the variables sendsheet and lastrow.

 

[camle]

Everything after the line asking "is the machine ready" is the writing of the data so you could run that after the edit. If you break that into a second sub don't forget you''ll have to redefine the variables sendsheet and lastrow.

Thanks so much

 

[camle]

Thanks so much

Everything is working good from the help received.

Now, can you.... while sending to the port, can it be listing in a window to show progress?

Cam