Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auto Refrshing Data
I have trying to auto-publish data from spreadsheet to a HTML file.
I have created a spreadsheet which MS Scheduler automatically opens. Within the spreadsheet is an Auto_Open macro, which:- Refreshes data within a pivot extracted from a third party application, Closes the spreadsheet saving the data within excel and also save as 'to an html file. The problem is that when I save as html a message is displayed stating that the third party application password will not be saved (although it is with the pivot table) Thus when the process runs the question pops up asking for the password. Has anyone encountered this, if so, how did they get around it. Cheers Dave |
#2
|
|||
|
|||
Have you tried:
Application.DisplayAlerts = False ActiveWorkbook.SaveAs .... Application.DisplayAlerts = True ? Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Auto Update Data Source? | Excel Worksheet Functions | |||
Auto filling dates on other worksheets with data from a next payme | Excel Worksheet Functions | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |