word 2016 vba not writing to protected excel workbook -


my task take forms (and accompanying spreadsheets) use on google docs(sheets), , transfer them our share drive. losing access google docs(sheets) (company change o365) , @ least have 1 of these things ready go lose access google docs. options limited. i'm not versed in creating pdf forms, our version of adobe isn't developers anyway. anyway, have built first form , accompanying protected spreadsheet (needed because have personal information). problem spreadsheet opening, closing without writing information. macros running without breaking in it's current form. code word document follows:

sub submitbutton_click()     application.screenupdating = false     dim exctransfer excel.application     dim excwkbk workbook     dim excsht worksheet     set exctransfer = new excel.application     set excwkbk = exctransfer.workbooks.open("l:\30 day short term_     storage\security\security forms\vehicle registration forms\vehicle_     registration worksheet.xlsm", readonly:=false, password:="********",_     writerespassword:="********")     excwkbk.unprotect password:="********"      set excsht = sheets("current 2016")     excsht.activate     dim irow long     irow = excsht.cells.find(what:="*", searchorder:=xlrows,_    searchdirection:=xlprevious, lookin:=xlvalues).row + 1     excsht        .cells(irow, 1) = me.namebox.value        if addveh            .cells(irow, 2) = "add vehicle"        elseif remveh            .cells(irow, 2) = "remove vehicle"        else            .cells(irow, 2) = ""        end if         if prmy            .cells(irow, 3) = "yes"        elseif prmn            .cells(irow, 3) = "no"        else            .cells(irow, 3) = ""        end if         .cells(irow, 4) = me.vmake.value        .cells(irow, 5) = me.vmodel.value        .cells(irow, 6) = me.vcolor.value        .cells(irow, 7) = me.vlicense.value    end     excwkbk.close savechanges = true    exctransfer.quit     me.namebox.value = ""    me.addveh = false    me.remveh = false    me.prmy = false    me.prmn = false    me.vmake.value = ""    me.vmodel.value = ""    me.vcolor.value = ""    me.vlicense.value = ""    application.screenupdating = true     application.quit savechanges:=true  end sub

the code have spreadsheet follows:

sub workbook_open()     thisworkbook.password = "********" end sub  sub workbook_modify()     thisworkbook.unprotect password:="********" end sub

i'm sure have more code needed, that's way work. missing? i'm sure it's 1 liner.


-

Comments

Post a Comment

Popular posts from this blog

java - SSE Emitter : Manage timeouts and complete() -

i writing web app multiple listeners(evcentsource sse clients js) connected server . want store sse emitter per connected listener : can done in memory or other means assigning id each client able achieve far now question ; how send response/event specific client connected web app ? while doing sseemmiters stored either getting completed or timed out. how prevent ? how keep sseemmiter available open infinite time (till client closes) , send events selectively .
Read more

jquery - uncaught exception: DataTables Editor - remote hosting of code not allowed -

i'm trying implement crud operation using datatableseditor using datatables.but i'm getting error messages: 1)uncaught exception: datatables editor - remote hosting of code not allowed. please see http://editor.datatables.net details on how purchase editor license 2)typeerror: a.editor undefined 3) $.fn.datatable.editor not constructor" what reason? here configuration: <%@ page language="java" contenttype="text/html; charset=iso-8859-1" pageencoding="iso-8859-1"%> <!doctype html public "-//w3c//dtd html 4.01 transitional//en" "http://www.w3.org/tr/html4/loose.dtd"> <html> <head> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1"> <title>insert title here</title> <link rel="stylesheet" type="text/css" href="//cdn.datatables.net/1.10.12/css/jquery.datatables.min.css"> <link re...
Read more

java - How to resolve error - package com.squareup.okhttp3 doesn't exist? -

i trying convert json java object use of gson in maven, following youtube video guidance - https://www.youtube.com/watch?v=vqgghm9pwe0 , theres error occurs when in main class error - package com.squareup.okhttp3 doesn't exist. code below: java package com.codebeasty.json; import com.squareup.okhttp3.okhttpclient; public class main { private static okhttpclient client = new okhttpclient(); public static void main (string [] args) { } } i put in dependency in pom.xml: <dependencies> <dependency> <groupid>com.squareup.okhttp3</groupid> <artifactid>okhttp</artifactid> <version>3.4.2</version> </dependency> <dependency> <groupid>com.google.code.gson</groupid> <artifactid>gson</artifactid> <version>2.8.0</version> </dependency> </dependencies> i dont understand why doesn't recognize com.squareup. there may need download? have downl...
Read more