The "positive spin" on this behavior is it acted as a Progress Bar - the program swallowed a bunch of data, chewed on it for a few seconds (may 10-20), "silently" opened Excel and wrote the Worksheets, then made a second pass where it read the Worksheets, made the graphs, and "flashed" a glimpse of the Workbook, taking maybe a second per Worksheet. However, I just had to "gild the lily" - I wanted to create two Graphs plotting some of the data, which necessitated reading from the just-written Worksheet and then adding an Excel Graph - this process caused an image of the Excel page to "flash" (appear for maybe a few tenths of a second) for each Worksheet processed. This sheet will be for longging the ProtectUnProtect info. You can also toggle the lock on and off just by clicking the Format. First of all got to Review Tab at the Top of Excel Menu Bar, then click on Protect Sheet. Station 01, Station 23, etc.), creates a nice table, and (if that's all I did) never shows that Excel is running. Add a new log worksheet to your workbook and give it the name of LogSheet. You do, in fact, need to open Excel as it is the program doing the work, but when you do the New Report, you can set the Window State to "minimized", and Excel will (most of the time) not "pop up".ĭo you notice the hand-waving language in the previous paragraph? I have a routine that reads some data (text) files, processes these data into a series of Excel Worksheets (named for the Station from which the data comes, e.g. Wrong on two counts - I'm sure there are "parallels", and you "sort-of" can save data without obviously (or, maybe, "flauntingly", if that's a word) opening Excel.
Knowledge of the Report Generation toolkit is unparalleled, is there any way to save data to excel without opening and displaying the application window? Me thinkls not.
0 kommentar(er)
