Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
resume.xlw
I posted this but no response as yet but this darn thing is driving me
crazy, if you can help turn it off id be very happy, one frustrated person right now, have searched online / help and now ready to tear the wall down its so frustrating Hi All, a small problem if some one can help, I have a macro that opens a hyperlink and runs an application in another workbook, saves it then moves to the next one. all is good with this but when all is closed it has somehow created a XLW a workspace for these files, which I don't want ? tried finding how it was created but no luck, is there an option somewhere were this can be turned off. regards Pete |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
resume.xlw
Can you post the macro?
"OZDOC" wrote: I posted this but no response as yet but this darn thing is driving me crazy, if you can help turn it off id be very happy, one frustrated person right now, have searched online / help and now ready to tear the wall down its so frustrating Hi All, a small problem if some one can help, I have a macro that opens a hyperlink and runs an application in another workbook, saves it then moves to the next one. all is good with this but when all is closed it has somehow created a XLW a workspace for these files, which I don't want ? tried finding how it was created but no luck, is there an option somewhere were this can be turned off. regards Pete |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
resume.xlw
If any one can tell me why excel auto creates a resume.xlw file i would be
very grateful i have now spent the second day trying to find it in help everywhere very annoyed "OZDOC" wrote in message ... I posted this but no response as yet but this darn thing is driving me crazy, if you can help turn it off id be very happy, one frustrated person right now, have searched online / help and now ready to tear the wall down its so frustrating Hi All, a small problem if some one can help, I have a macro that opens a hyperlink and runs an application in another workbook, saves it then moves to the next one. all is good with this but when all is closed it has somehow created a XLW a workspace for these files, which I don't want ? tried finding how it was created but no luck, is there an option somewhere were this can be turned off. regards Pete |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
resume.xlw
You still haven't posted the macro code that Barb requested.
The macro would seem to be the source of creation for the resume.xlw Gord Dibben MS Excel MVP On Sat, 29 Jul 2006 19:29:15 +0930, "OZDOC" wrote: If any one can tell me why excel auto creates a resume.xlw file i would be very grateful i have now spent the second day trying to find it in help everywhere very annoyed "OZDOC" wrote in message ... I posted this but no response as yet but this darn thing is driving me crazy, if you can help turn it off id be very happy, one frustrated person right now, have searched online / help and now ready to tear the wall down its so frustrating Hi All, a small problem if some one can help, I have a macro that opens a hyperlink and runs an application in another workbook, saves it then moves to the next one. all is good with this but when all is closed it has somehow created a XLW a workspace for these files, which I don't want ? tried finding how it was created but no luck, is there an option somewhere were this can be turned off. regards Pete |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
resume.xlw
I apologise as I never seen a request for the code ?
Sub RAYS() Range("D10").Select If ActiveCell.Offset(0, -1).Value < "Y" Then Exit Sub End If MYDAYS = ActiveCell.Offset(0, 1).Value Workbooks.Open Filename:=ActiveCell.Value Range("L9").Value = MYDAYS Application.Run "'1.JY T$ DATA V9-5.XLS'!SELECTUPDATE" ActiveWorkbook.Save ActiveWindow.Close End Sub On the subject above, I notice a lot of people reply but not in the thread and I guess this is where I missed the request, is there a way to also check multiple posts to see if some one as replied to yours ? or am I missing something here ? cheers Pete "Gord Dibben" <gorddibbATshawDOTca wrote in message ... You still haven't posted the macro code that Barb requested. The macro would seem to be the source of creation for the resume.xlw Gord Dibben MS Excel MVP On Sat, 29 Jul 2006 19:29:15 +0930, "OZDOC" wrote: If any one can tell me why excel auto creates a resume.xlw file i would be very grateful i have now spent the second day trying to find it in help everywhere very annoyed "OZDOC" wrote in message ... I posted this but no response as yet but this darn thing is driving me crazy, if you can help turn it off id be very happy, one frustrated person right now, have searched online / help and now ready to tear the wall down its so frustrating Hi All, a small problem if some one can help, I have a macro that opens a hyperlink and runs an application in another workbook, saves it then moves to the next one. all is good with this but when all is closed it has somehow created a XLW a workspace for these files, which I don't want ? tried finding how it was created but no luck, is there an option somewhere were this can be turned off. regards Pete |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
resume.xlw
Here is the thread with replies.
http://snipurl.com/u3ws As to your code, I don't see anything in this macro but perhaps the macro SELECTUPDATE is the culprit. I'm not much of a VBA person so may be missing something. Gord On Sun, 30 Jul 2006 11:50:15 +0930, "OZDOC" wrote: I apologise as I never seen a request for the code ? Sub RAYS() Range("D10").Select If ActiveCell.Offset(0, -1).Value < "Y" Then Exit Sub End If MYDAYS = ActiveCell.Offset(0, 1).Value Workbooks.Open Filename:=ActiveCell.Value Range("L9").Value = MYDAYS Application.Run "'1.JY T$ DATA V9-5.XLS'!SELECTUPDATE" ActiveWorkbook.Save ActiveWindow.Close End Sub On the subject above, I notice a lot of people reply but not in the thread and I guess this is where I missed the request, is there a way to also check multiple posts to see if some one as replied to yours ? or am I missing something here ? cheers Pete "Gord Dibben" <gorddibbATshawDOTca wrote in message .. . You still haven't posted the macro code that Barb requested. The macro would seem to be the source of creation for the resume.xlw Gord Dibben MS Excel MVP On Sat, 29 Jul 2006 19:29:15 +0930, "OZDOC" wrote: If any one can tell me why excel auto creates a resume.xlw file i would be very grateful i have now spent the second day trying to find it in help everywhere very annoyed "OZDOC" wrote in message ... I posted this but no response as yet but this darn thing is driving me crazy, if you can help turn it off id be very happy, one frustrated person right now, have searched online / help and now ready to tear the wall down its so frustrating Hi All, a small problem if some one can help, I have a macro that opens a hyperlink and runs an application in another workbook, saves it then moves to the next one. all is good with this but when all is closed it has somehow created a XLW a workspace for these files, which I don't want ? tried finding how it was created but no luck, is there an option somewhere were this can be turned off. regards Pete |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
resume.xlw
It would seem to me that you need to dig into
'1.JY T$ DATA V9-5.XLS'!SELECTUPDATE To see what's happening. There is nothing in the remainder of the code I see that would create the file you mention. "OZDOC" wrote: I apologise as I never seen a request for the code ? Sub RAYS() Range("D10").Select If ActiveCell.Offset(0, -1).Value < "Y" Then Exit Sub End If MYDAYS = ActiveCell.Offset(0, 1).Value Workbooks.Open Filename:=ActiveCell.Value Range("L9").Value = MYDAYS Application.Run "'1.JY T$ DATA V9-5.XLS'!SELECTUPDATE" ActiveWorkbook.Save ActiveWindow.Close End Sub On the subject above, I notice a lot of people reply but not in the thread and I guess this is where I missed the request, is there a way to also check multiple posts to see if some one as replied to yours ? or am I missing something here ? cheers Pete "Gord Dibben" <gorddibbATshawDOTca wrote in message ... You still haven't posted the macro code that Barb requested. The macro would seem to be the source of creation for the resume.xlw Gord Dibben MS Excel MVP On Sat, 29 Jul 2006 19:29:15 +0930, "OZDOC" wrote: If any one can tell me why excel auto creates a resume.xlw file i would be very grateful i have now spent the second day trying to find it in help everywhere very annoyed "OZDOC" wrote in message ... I posted this but no response as yet but this darn thing is driving me crazy, if you can help turn it off id be very happy, one frustrated person right now, have searched online / help and now ready to tear the wall down its so frustrating Hi All, a small problem if some one can help, I have a macro that opens a hyperlink and runs an application in another workbook, saves it then moves to the next one. all is good with this but when all is closed it has somehow created a XLW a workspace for these files, which I don't want ? tried finding how it was created but no luck, is there an option somewhere were this can be turned off. regards Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|