TeacherEric
Board Regular
- Joined
- Mar 21, 2006
- Messages
- 78
I'm having a major problem with my code. I can't seem to figure out what is wrong.
When I run this code:
Instead of executing the saveas command, VB jumps to a combobox code from another worksheet then jumps to another, and another, until it errors out. Once I click the RESET button on the VB toolbar, it saves.
If I have "thisworkbook.save" it will save without a problem.
Only when I'm doing a saveas does it start this "code hopping".
Can someone guide me to an answer, or give me an idea what I'm doing wrong?
The code is accessed by clicking an autoshapebox.
By the way, the cell value of
is:
C:\Gradebooks\Chem1 AY06-07 Gradebook.xls
Thank you,
TeacherEric
When I run this code:
Code:
If Dir("C:\Gradebooks", vbDirectory) = "" Then
MkDir "C:\Gradebooks"
End If
ActiveWorkbook.SaveAs Filename:=Sheets("information").Range("k151"), FileFormat:= _
xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
Instead of executing the saveas command, VB jumps to a combobox code from another worksheet then jumps to another, and another, until it errors out. Once I click the RESET button on the VB toolbar, it saves.
If I have "thisworkbook.save" it will save without a problem.
Only when I'm doing a saveas does it start this "code hopping".
Can someone guide me to an answer, or give me an idea what I'm doing wrong?
The code is accessed by clicking an autoshapebox.
By the way, the cell value of
Code:
Sheets("information").Range("k151")
C:\Gradebooks\Chem1 AY06-07 Gradebook.xls
Thank you,
TeacherEric