software

Hi there,

I created a source file (.csv) that contains two columns and several
rows. This source file is filled (updated) by a SQL process that runs
everyday.

The source file is input for a report in Excel. I would like to
automatically update the Excel report when it is opened. However,
although it looks like I linked the correct file, worksheet and range,
I can only update the Excel report after I manually open the source
file. But that's not what I want, I don't want to see the source file.

Anyone?--
zimon72
------------------------------------------------------------------------
zimon72's Profile: www.excelforum.com/member.php...oamp;userid=30592
View this thread: www.excelforum.com/showthread...hreadid=502398I believe that if the file is a text file it has to be opened in Excel for
the update to occur, as the text file does not have and cell address
references.

Outputting the linked file as an Excel file would correct this problem.
--
Kevin Backmannquot;zimon72quot; wrote:

gt;
gt; Hi there,
gt;
gt; I created a source file (.csv) that contains two columns and several
gt; rows. This source file is filled (updated) by a SQL process that runs
gt; everyday.
gt;
gt; The source file is input for a report in Excel. I would like to
gt; automatically update the Excel report when it is opened. However,
gt; although it looks like I linked the correct file, worksheet and range,
gt; I can only update the Excel report after I manually open the source
gt; file. But that's not what I want, I don't want to see the source file.
gt;
gt; Anyone?
gt;
gt;
gt; --
gt; zimon72
gt; ------------------------------------------------------------------------
gt; zimon72's Profile: www.excelforum.com/member.php...oamp;userid=30592
gt; View this thread: www.excelforum.com/showthread...hreadid=502398
gt;
gt;


How do I do that? Just giving an .xls entension to my output doesn't
split my data into columns!--
zimon72
------------------------------------------------------------------------
zimon72's Profile: www.excelforum.com/member.php...oamp;userid=30592
View this thread: www.excelforum.com/showthread...hreadid=502398