use an existing Excel spreadsheet

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7331056791

November 21, 2006, 05:10 PM

pricebl

use an existing Excel spreadsheet

I'm trying to create a report that will be run daily and needs to be appended to an existing Excel spreadsheet. I'm running webfocus 7.1.3 and Excel 2003. Appreciate any help!

November 21, 2006, 06:13 PM

Prarie

There might be a better way, but I've Filedefed with an append before in previous releases.

FILEDEF VPTHO DISK \\webfsahq01\d$\ibi\apps\chddb \vptho.exl (APPEND

Then in Your Focexec
ON TABLE PCHOLD AS VPTHO FORMAT EXL2K

In Focus since 1993. WebFOCUS 7.7.03 Win 2003

November 22, 2006, 09:39 AM

Prarie

It's called late in the day "typo".

Should be .xls

In Focus since 1993. WebFOCUS 7.7.03 Win 2003

December 06, 2006, 02:35 PM

pricebl

Sorry for taking so long to reply - but thanks that helped a lot!

December 06, 2006, 05:17 PM

Prarie

Great

In Focus since 1993. WebFOCUS 7.7.03 Win 2003