How to create a macro for this?

[zimon72]

I created a SQL script, that eventually spools an Excel file.

This spool file is the source file for a total report (destination file) in Excel. I already tried to work with links between the source file and the destination file, but when I than open the destination file, it can only updates the values if I also open the source file. This is not what I want. I would like the destination file to automatically updates its value automatically wihtout having to open the source file. Can I record a marco to do this? If so, can anyone explain how?

[Tom Ogilvy]

If the link is properly established, it should update. Since what you ask
is normal behavior if you have the proper settings and proper links, there
wouldn't be any special action which you would need to take or which you
could take.

--
Regards,
Tom Ogilvy

"zimon72" <[email protected]> wrote in
message news:[email protected]...
>
> I created a SQL script, that eventually spools an Excel file.
>
> This spool file is the source file for a total report (destination
> file) in Excel. I already tried to work with links between the source
> file and the destination file, but when I than open the destination
> file, it can only updates the values if I also open the source file.
> This is not what I want. I would like the destination file to
> automatically updates its value automatically wihtout having to open
> the source file. Can I record a marco to do this? If so, can anyone
> explain how?
>
>
> --
> zimon72
> ------------------------------------------------------------------------
> zimon72's Profile:
http://www.excelforum.com/member.php...o&userid=30592
> View this thread: http://www.excelforum.com/showthread...hreadid=502842
>

[zimon72]

Tom,

If it would work, I wouldn't post...

So, it doesn't work. The problem is - I think - that although it looks like my sql script exports an .xls file, Excel sees and recognizes it as an .xls file as soon as I open it in Excel. So, I can only update my destination file after I open my .xls source file in Excel. And for this last part, I would like to record a macro.