How can I update web published chart based on a link in XL?

[nhsdk]

Hi

I need to update some links in XL, without having to start XL.
I am publishing charts on the web. But when the user access this htm it never goes back to XL to update the datalinks.

Is there anyone who knows of a tool, which could open-update-close an xls-file. I can then put a schedule on that to get my web chart updated.

 

[01Patrik]

It might not be exactly what you're looking for, but it might be an altervative way of solving the problem...

Use a workbook.open macro in your personal.xls workbook, something like this:

private sub workbook.open()

workbooks.open ("your_file_with_path.xls")
activeworkbook.close (savechanges = true)

end sub

This way your workbook will be updated everytime you (or any user to whom's computer you assign this workbook.open macro) start Excel. And why not combine with adding Excel to the Startup folder...?


Good luck!



// Patrik
______________________________

To the optimist, the glass is half full. To the pessimist, the glass is half empty. To the IT Professional, the glass is twice as big as it needs to be.

 

[nhsdk]

Hi Patrik

Thanks for your reply. I thought of that to, but what do I do, when I have to modify the file afterwoods. Will it not close, as soon as I try to open it?

And also.. I am going to use a DTS package from SQL, so it has to be something, that can start from a DOS prompt.

//nhs

 

[01Patrik]

It won't close. When you start excel workbooks.open in personal.xls opens the file and closes it - whereafter it continues with the task at hand (opening the file you have ordered Excel to open, or starting a new workbook).

This means that if you try to open your file (when Excel isn't started) by doubleclicking it - or starting it from a DOS prompt , by that matter - then Excel will open it, close it (save the changes) and then open it again.


I really don't know anything about DTS: But you can start excel from a DOS prompt, by simply writing the address to the program and the filename, something like this:

C:\program files\office10\excel.exe path_and_filename.xls

This of course presumes that Win is runing in the background - running Excel from DOS as Operating System (without Win in the background) will not work.

I'd give it a try, it doesn't take very much more time than answering me

// Patrik
______________________________

To the optimist, the glass is half full. To the pessimist, the glass is half empty. To the IT Professional, the glass is twice as big as it needs to be.