Re: Macro reloaded Failure
Excel VBA question moved to Office Development
Re: Macro reloaded Failure
Thanks koolsid, One of the IT boys came out ot my house and fixed the problem. I did however try to get him to help out with some of my own programming problems, but he flat out declied.
Re: Macro reloaded Failure
Quote:
Thanks koolsid, One of the IT boys came out ot my house and fixed the problem.
Glad it is resolved :)
Quote:
I did however try to get him to help out with some of my own programming problems, but he flat out declied.
The members in this forums won't ;) so go ahead and shoot what problems are you facing :) just make sure it is in the right forum to get the exact response...
Re: Macro reloaded Failure
Quote:
Originally Posted by koolsid
The members in this forums won't ;)
Not me! Once I spent one hour to work out a way to help him but he denied my code that forced me to withdraw my post and he kept yelling for help.
I said to myself "that will never happen again."
Re: Macro reloaded Failure
I said to myself again "that will never happen again."
Re: Macro reloaded Failure
Quote:
he denied my code that forced me to withdraw my post and he kept yelling for help.
I wasn't yelling. If I was the text in my post would have looked like this:"I DON"T UNDERSTAND WHAT YOU SAID" but concidering that I find yelling,or shouting extremely rude I don't use it in any posts.
Quote:
Quote:
Originally Posted by koolsid
The members in this forums won't
Not me! Once I spent one hour to work out a way to help him but he denied my code that forced me to withdraw my post and he kept yelling for help.
I said to myself "that will never happen again."
__________________
• IsDigits() and IsNumber() functions • Wichmann-Hill Random() function • >> and << functions for VB
I didn't deny the code. I busy tring out Pete's code at the time and I was asking questions about it.
Quote:
I said to myself again "that will never happen again."
__________________
• IsDigits() and IsNumber() functions • Wichmann-Hill Random() function • >> and << functions for VB
I did however say that "I would like to use the format that I have started using already.
Well you removed the post before I could completely finish Pete's code example.
Re: Macro reloaded Failure
Quote:
Can I see that code?
Would have loved to show you the code, but work owns my home computer. I think that if I had posted the code, I would mostly likely be sacked.
Re: Macro reloaded Failure
Code:
G54D10* X-116Y+1336D01* Format from Gerber file
Format Conversion from Gerber File
Axis 1 Co-op Axis 2 Co - op Select My Output from VB6 to Excel
X- 116 Y+ 1336 D01
Re-adjusted Format of Homemade Router After conversion and re-adjustments are made
Axis 1 Co-op Axis 2 Co - op Select
X- 118 Y+ 1338 D01 Frist past
X- 114 Y+ 1334 D01 Second past
Parameter Object Diameter & size
D10 CIRCLE D=0.38mm Circle adjusted for cutting tool ( not Draw command)
I have posted this, because of anhn comments,
First of all, VB6 sends the information to Excel in the orginial state. After the data arrives in Excel the program starts to read the data and starts setting up program values and diameters, tool selections and so on. Next even if I could miss the last part, I don't want to. The program re adjusts the output that Excel has and re-writes the information so that my router can do two pasts, not just one past. (This includes Traces and Pad styles)
Now, because Photoplotters send DRAW commands, FLASH commands and so on. I need this data to be re-writtern so that I can use a cutting tool to make the same design possiable. The tranfer process will be carried out via MSCOMM1 with handhanding enabled and data received first enabled (To stop the program overrunning the processes that have already started)
The mircocontroller only reads the X-, X+,X0,Y-,Y+,Y0 as XOR statements and the main processing is done with VB6 controlling the timing values. IT said, that this will depend on the computer speed and software applications running at the time as the code is executed, and may have problems with other concoles running in different conditions.