Hi all,
I have a macro which saves a worksheet in a new workbook that is supposed to be stored in a temporary location.
I have been writing the code on my windows 7, excel 2010.
But when i open the same workbook from a different computer, the macro stops running
This is the problem area.
TempFilePath = Environ$("temp") & "\"
It says Compile Error: can't find project or library.
Is there some way i can change the code so that i can use this in another computer?
I have a macro which saves a worksheet in a new workbook that is supposed to be stored in a temporary location.
I have been writing the code on my windows 7, excel 2010.
But when i open the same workbook from a different computer, the macro stops running
This is the problem area.
TempFilePath = Environ$("temp") & "\"
It says Compile Error: can't find project or library.
Is there some way i can change the code so that i can use this in another computer?