Excel – Automatically Publish graphs to Intranet
I want to publish updated graphs to my intranet automaticlly. ie open excel, refresh data (from as400)then save,publish&close (running from the scheduler )
I have my Downloaded vb express & looked at vb sites etc… & managed to create a project which publishes the page to the intranet correctly using f5 but as I say I want this to be automatic. Any ideas ???
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
MyBase.Load
Call ColFunc()
End Sub
Function ColFunc() As Integer
Dim objExcel
Dim objWorkBook
objExcel = CreateObject(”EXCEL.APPLICATION”)
objWorkBook = objExcel.Workbooks.Open(”filename”)
objExcel.DisplayAlerts = False
objWorkBook.SaveAs(”filename”, 44)
objExcel.DisplayAlerts = True
objWorkBook.Close(True)
objExcel.Quit()
objWorkBook = Nothing
objExcel = Nothing
Return 0
End Function
End Class
Software/Hardware used:
Software/Hardware used:
ASKED:
September 15, 2008 2:50 PM
UPDATED:
September 20, 2008 9:46 PM
Answer Wiki:
I'd recommend getting rid of the VB program. Record an Excel macro directly within excel to save a copy of the file to where it needs to be saved to be on the website.
Then add a scheduled task to launch excel passing it the path to the excel workbook.
After you create the macro, in the macro editor select ThisWorkbook from the project. In the first dropdown menu select Workbook. This will open the Excel macro which runs when the workbook is opened. Give it the name of the Sub which was created when you recorded the Macro.
From now on when the workbook is opened it will update it self and publish it self to the web server.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
