excel - Cycle through employee numbers and save multiple PDF files -

-

the spreadsheet have has 2 tabs, 1 of tabs list of employees each of has unique employee number , various other pieces of information employee.

the second tab have page put employee number in , bring through of employee's information using vlookups, there save button can save employee's information pdf file.

on save button, there macro can press button , save employees information multiple different pdf files, not saving them 1 @ time?
i'm talking cycling through employee numbers , saving each one?

the code have attached button follows:

option explicit sub savepdf() dim wsheet worksheet dim vfile variant dim sfile string  set wsheet = activesheet sfile = replace(replace(range("i11"), " ", ""), ".", "_") _         & "_" _         & range("i10") _         & ".pdf" sfile = thisworkbook.path & "\" & sfile  excel.application.filedialog(msofiledialogsaveas)  dim integer = 1 .filters.count     if instr(.filters(i).extensions, "pdf") <> 0 exit next  .filterindex = .initialfilename = sfile  .show if .selecteditems.count > 0 vfile = .selecteditems.item(.selecteditems.count)  end  if vfile <> "false" wsheet.range("a1:bf47").exportasfixedformat _     type:=xltypepdf, _     filename:=vfile, _     quality:=xlqualitystandard, _     includedocproperties:=true, _     ignoreprintareas:=false, _     openafterpublish:=false  end if end sub


Comments

Post a Comment

Popular posts from this blog

java - Date formats difference between yyyy-MM-dd'T'HH:mm:ss and yyyy-MM-dd'T'HH:mm:ssXXX -

-
i trying parse date 2014-12-03t10:05:59.5646+08:00 using these 2 formats: yyyy-mm-dd't'hh:mm:ss yyyy-mm-dd't'hh:mm:ssxxx when parse using yyyy-mm-dd't'hh:mm:ss works fine, when parse yyyy-mm-dd't'hh:mm:ssxxx parseexception thrown. which correct format parse date , difference between these 2 formats? note : cannot use joda :( those valid formats: yyyy-mm-dd't'hh:mm:ss.sssz >>> e.g.: 2001-07-04t12:08:56.235-0700 yyyy-mm-dd't'hh:mm:ss.sssxxx >>> e.g.: 2001-07-04t12:08:56.235-07:00 edit: btw, "x" refer (iso 8601 time zone)
Read more

c# - Get rid of xmlns attribute when adding node to existing xml -

-
i have xml-file: <ns2:root xmlns:ns2="namespace"> <ns2:a> <ns2:b>some content</b> <ns2:c>some content</c> <ns2:d>some content</d> </a> </root> i need add new node in specific place, code is: var doc = xdocument.load(file); xnamespace ns2 = "namespace"; doc.element(ns2 + "root").element(ns2 + "a").element(ns2 + "c").addafterself( new xelement(ns2+"new", new xelement("new1", new xelement("new2","some content"), new xelement("new3", "some content")))); the output is: <ns2:root xmlns:ns2="namespace"> <ns2:a> <ns2:b>some content</b> <ns2:c>some content</c> <ns2:new> <new1 xmlns=""> <new2>some content</new2> ...
Read more