Location of ExcelWebPagePreview...

J

Jeevan-S

Hi,

I use Excel 2002 in a WinXP Pro environment.

When I do a File->WebPagePreview, Excel converts the
workbook into HTM & opens in a browser.

The location being:
C:\temp\ExcelWebPagePreview\<name-of-workbook>.htm

I could not locate in options where the
path "C:\temp\ExcelWebPagePreview" is specified.

How to change it ?

thks
g1
 
D

Dave Peterson

I don't think I've ever clicked on this option!

But when I did, my file got saved to the C:\windows\temp folder.

It looks like it just uses the windows temp folder. But you could use
File|saveAs inside MSIE to save it to the folder you like.

Not quite what you were looking for, but it might help.
 
J

Jeevan-S

Looks like u r right.
My TEMP and TMP env variables point to c:\temp

Anyway solved my problem by writing a macro.
---- macro ----
ActiveWorkbook.Save
ActiveWorkbook.WebPagePreview
Set fs = CreateObject("Scripting.FileSystemObject")

fs.CopyFile "C:\temp\ExcelWebPagePreview\*.htm", "C:\Jeevan
\Satyam\Alpharetta-Trip-Expenses\"

fs.CopyFolder "C:\temp\ExcelWebPagePreview\*", "C:\Jeevan\S
atyam\Alpharetta-Trip-Expenses"
---- macro ----

thks
g1
 
Top