resume.xlw

[OZDOC]

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

[Barb Reinhardt]

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
>
>
>

[OZDOC]

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" <NOSPAM@iprimus.com.au> wrote in message
news:uRaS49lsGHA.3264@TK2MSFTNGP03.phx.gbl...
>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
>
>

[Gord Dibben]

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" <NOSPAM@iprimus.com.au> 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" <NOSPAM@iprimus.com.au> wrote in message
>news:uRaS49lsGHA.3264@TK2MSFTNGP03.phx.gbl...
>>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
>>
>>
>

[OZDOC]

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
news:gv0nc2d80c6cpovnh57jtcgnvcebs5t4c1@4ax.com...
> 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" <NOSPAM@iprimus.com.au> 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" <NOSPAM@iprimus.com.au> wrote in message
>>news:uRaS49lsGHA.3264@TK2MSFTNGP03.phx.gbl...
>>>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
>>>
>>>
>>
>

[Gord Dibben]

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" <NOSPAM@iprimus.com.au> 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
>news:gv0nc2d80c6cpovnh57jtcgnvcebs5t4c1@4ax.com...
>> 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" <NOSPAM@iprimus.com.au> 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" <NOSPAM@iprimus.com.au> wrote in message
>>>news:uRaS49lsGHA.3264@TK2MSFTNGP03.phx.gbl...
>>>>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
>>>>
>>>>
>>>
>>
>

[Barb Reinhardt]

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
> news:gv0nc2d80c6cpovnh57jtcgnvcebs5t4c1@4ax.com...
> > 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" <NOSPAM@iprimus.com.au> 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" <NOSPAM@iprimus.com.au> wrote in message
> >>news:uRaS49lsGHA.3264@TK2MSFTNGP03.phx.gbl...
> >>>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
> >>>
> >>>
> >>
> >
>
>
>