Tim Pease
12/15/2006 8:13:00 PM
On 12/15/06, ChrisH <chris.hulan@gmail.com> wrote:
>
> anon1m0us wrote:
> > I get a file name in the directory and modify the cells with making
> > bold etc.
> > when excel.visible=TRUE it works. However, when excel.visible=FALSE
> > nothing happens.
> > Why?
> ...
>
> Tried your code and it seems that 'Save as...' is putting the saved
> file into 'My Documents' rather than overwriting the original (which is
> in the same dir as where I saved your code into a file).
>
I have run into trouble in the past using relative pathnames for MS
Office files (open, saving). Try using an absolute pathname when you
(a) open the file and (b) save the file. That should put it in the
correct location.
Blessings,
TwP