Databases
StackOverflow2013
Postsdbo
POvb script Refreshall Error 424
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POvb script Refreshall Error 424
    primarykey
    data
    text
    <p>I have a VB Script that opens a spreadsheet, executes RefreshAll to update the sheet from external data, then does SaveAs a .CSV I had the script working as it should, then moved job to run on another computer. The job is running unattended through the Task Scheduler and now my error log shows ERROR 424 and the script no longer updates the spreadsheet, nor saves the .CSV. The script does run as it should on this machine interactively. The Job is using my credentials to run unattended. Anyone have any help on the Error 424??? </p> <p>Here is code snippet:</p> <pre><code>dim sLogFile, logFSO, objLogFile sLogFile = "F:\Feed\FeedLog.log" Set logFSO = CreateObject("Scripting.FileSystemObject") Set objLogFile = logFSO.OpenTextFile(sLogFile, 8, True) Dim objExcel Dim objWorkBook, objWorksheet Set objExcel = CreateObject("EXCEL.APPLICATION") Set objWorkBook = objExcel.Workbooks.Open("F:\Feed\FeedOlap.xlsx") Set objWorksheet = objWorkbook.Worksheets("Sheet6") objLogFile.WriteLine (" " &amp; DATE &amp; " " &amp; TIME &amp; " Starting Refresh") objworkbook.Refreshall IF ERR THEN objLogFile.WriteLine "Error" &amp; Err.Number End If objLogFile.WriteLine (" " &amp; DATE &amp; " " &amp; TIME &amp; " Refresh Complete") objExcel.DisplayAlerts=FALSE objWorkBook.Save objWorksheet.SaveAs "F:\Feed\FeedOlapCSV.csv", 6 objWorkBook.Close True objExcel.Quit Set objWorkBook = Nothing Set objExcel = Nothing objLogFile.WriteLine (" " &amp; DATE &amp; " " &amp; TIME &amp; " CSV Created") </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USbigjoe
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COError 424 means [`Object required`](http://msdn.microsoft.com/en-us/library/xe43cc8d). Which line is giving you the error?
      singulars
      1. POvb script Refreshall Error 424
      1. USAnsgar Wiechers
    2. COobjworkbook.Refreshall
      singulars
      1. POvb script Refreshall Error 424
      1. USbigjoe
    3. CO`objworkbook` seems to be good, otherwise the script should have already failed at the line `Set objWorksheet = objWorkbook.Worksheets("Sheet6")`. What are the account settings of your scheduled task?
      singulars
      1. POvb script Refreshall Error 424
      1. USAnsgar Wiechers
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload