Macro reloaded Failure

Hi guys, I'm having problems with the record Macro in Excel 2007. If I use the same marco in a different row, cell or column after saving data in a Workbook & worksheets, one of three things happens: Visual basic editor in Excel complains that a single line of code is too long, or that the "agruments is invalid", or a "method or object not supported".

I use to run the some code on a old version of excel (2002-2003) without any problems. After updating to Office 2007 the code doesn't work, or doesn't complete runtime.

I have tried update manager and reading FAQ, but I don't see why the old code is that out of date that Excel couldn't fix the problem without incurring errors.

Excel VBA question moved to Office Development

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.

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...

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."

I said to myself again "that will never happen again."

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.

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.

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.