Thread: resume.xlw
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
OZDOC OZDOC is offline
external usenet poster
 
Posts: 13
Default 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