zip - Save logfile within Excel file using VBA -

-

i trying develop manner in vba track changes in document without having hide contents in sheet within workbook.

i understand if change extension of excel file ".zip", can access excel document components sorted directories. there way save , write text file within 1 of these directories can access every time document opened, without having have user drag log file along excel document?

some facts:

  • when excel opens file, file blocked excel. there no possibility write file within vba
  • you can store additional data file externally or after excel workbook has been closed
  • you need have code externally workbook accomplish writing file after has been closed. may want use vsto or oldschool excel addin.
  • you have ensure excel not destroy changes when restructuring or repairing file.

in first run, idea sounds natural, not use sheets programmer's point of view. have full control on excel files when

  • you use external libraries (e.g. spreadsheet gear) or
  • you remote control excel via automation.
  • you use openxml sdk excel
  • you use vba

you insert additonal information , take care information not skipped excel.

when want tracking way, suggest use excel addin. there no need installation when using kind of addin. attach open workbook , close workbook events , ensure changes written excel workbook after has been closed. have attach kind of other events track changes workbook. may need have in mind there can more 1 workbook opened @ time.

actually there alternatives.

  • write logging code in vba or whatever fits
  • abstract away how persist code (e.g. use data provider)

  • think these 2 alternatives store logging data:

    • you can save logging data in cells of excel. when using "newer" version of excel, have limit of 1 million rows. may want implement rolling mechanism ensures never go on border of 1 million records. (you may dont want track million changes)
    • you can use document properties store information xml.

last not least, obvious: why not using excel's functionality of tracking changes? understand track changes in excel 2013


Comments

Post a Comment

Popular posts from this blog

javascript - Chart.js (Radar Chart) different scaleLineColor for each scaleLine -

-
Image
i try , create radar chart using chart.js has various colours each scaleline, or coloured between scalelines. wondering if possible? from: to: i have working graph, though there doesn't seem method change individual scale lines. kind regards leigh you can extend radar chart type this, so chart.types.radar.extend({ name: "radaralt", initialize: function (data) { chart.types.radar.prototype.initialize.apply(this, arguments); var originalscaledraw = this.scale.draw; var ctx = this.chart.ctx; this.scale.draw = function () { var linewidth = this.linewidth; // bypasses line drawing in originalscaledraw this.linewidth = linewidth; originalscaledraw.apply(this, arguments); ctx.linewidth = this.linewidth; var scale = this; // draw chart.helpers.each(scale.ylabels, function (label, index) { // color of ...
Read more

apache - Error with PHP mail(): Multiple or malformed newlines found in additional_header -

-
suddenly have started receiving above error without changes having been made script. host 1and1 (i know...) the script still works fine on different server, , suspicion there must have been server config change has lead this, although hosts plead ignorance. there's no information on above error @ in google can find - have ideas? server running apache if helps. had similar problem. came out of blue. no php code changed. what changed: php upgraded 5.5.25-1 5.5.26. a security risk in php mail() function has been fixed , newlines in additional_headers allowed no more. because newlines mean: starts email message (and surely don't want inject newlines through headers followed evil message). what have worked fine, e.g. having newlines after headers or passing whole message additional_headers , function no more. solution : sanitize headers. no multiple newlines in additional_headers argument. these count "multiple or malformed newlines":...
Read more

java - Android – MapFragment overlay button shadow, just like MyLocation button -

-
Image
i'm struggling add shadow custom overlay button on google map. goal make custom button google's mylocation button. here's how app looks now: layout.xml <relativelayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" xmlns:map="http://schemas.android.com/apk/res-auto" android:layout_height="match_parent" android:layout_width="match_parent" style="@style/apptheme"> <fragment android:layout_width="match_parent" android:layout_height="match_parent" android:id="@+id/map" tools:context=".mapsactivity" android:name="com.google.android.gms.maps.supportmapfragment" android:layout_alignparentend="true" android:layout_alignparentstart="true" android:layout_alignparentbottom="true" ...
Read more