Gui data to Excel Sheet

[Crashm87]

Morning Community,

I have a script I have written to take information from Gui Edit boxes and push them to excel sheet to make labels. The script searches an old database to see if the label has been made before, if it has it pulls all the data to sheet from database. If it hasn't been made, it opens a Gui to input all the new information, on OK sends it to sheet.

Problem I'm having is, if I have to add another one manually like that, I get an error that the same variable can't be used for more than one control.

Here is broken down code that shows code related to errors.

Code: Select all

if	!c :=	myRng.Find(LookFor)
{
	MsgBox, 4, Warning, No matches found. Do you want to add one?
	IfMsgBox Yes
	{
		Goto, newcust
	}
	Else
		GoTo, Cancel
	return
}
; ERROR HAPPENS RIGHT HERE ON MESSAGE BOX YES
newcust:
xl :=	ComObj("Excel.Application")
Gui, 2:Add, Text, x12 y29 w80 h20 , Customer Name
Gui, 2:Add, Text, x12 y59 w90 h20 , Customer Number
Gui, 2:Add, Text, x12 y89 w80 h20 , Tire Size
Gui, 2:Add, Text, x12 y119 w80 h20 , Tire Brand
Gui, 2:Add, Text, x12 y149 w80 h20 , Rims?
Gui, 2:Add, Text, x12 y179 w80 h20 , VIN:
Gui, 2:Add, Edit, x102 y29 w80 h20 vcname, 
Gui, 2:Add, Edit, x102 y59 w80 h20 vcnumber, 
Gui, 2:Add, Edit, x102 y89 w80 h20 vtiresize, 
Gui, 2:Add, Edit, x102 y119 w80 h20 vbrand,
Gui, 2:Add, DropDownList, x102 y149 w80 h20 r2 vrims, ON RIMS|NOT ON RIMS
Gui, 2:Add, Edit, x102 y179 w80 h20 vvin, 
Gui, 2:Add, Button, x12 y209 w60 h25 glabel1, Label 1
Gui, 2:Add, Button, x77 y209 w60 h25 glabel2, Label 2
Gui, 2:Add, Button, x142 y209 w60 h25 glabel3, Label 3
Gui, 2:Add, Button, x77 y240 w60 h25 gcancel1, Cancel
Gui, 2:Show, w206 x%guix% y%guiy% , Customer Information
return

Any help is appreciated.

Thanks

[Wolfdagon]

Like the error says, you can't use the same variable for more than one control in a GUI. Simply change this variable name to something like cname2. If you really need for it to be cname for the later part of the script, then at some point before that put cname := cname2