Excel VBA for opening a file with changing in the file name every month -

-

i want vba code open file name changing every month 

chdir "s:\credit_risk\mis\consolidated customer profile macro\securities"  workbooks.open filename:= _     "s:\credit_risk\mis\consolidated customer profile macro\securities\enterprise  pending cases @ end of oct.2016.xls"

any 1 can help

workbooks.open filename:= _ "s:\credit_risk\mis\consolidated customer profile macro\securities\enterprise  pending cases @ end of " & format(date, "mmm.yyyy") & ".xls"

Comments

Post a Comment

Popular posts from this blog

php - Autoloader issue not returning Class -

-
problem? bootloader (autoloader) not seem working properly, or i'm missing something. here simplified code. the code below returns class "skeleton" not exist. on index.php file. index.php <?php include 'bootloader.php'; use skeleton\html\loginheader; $tool = new skeleton/html/loginheader(); bootloader.php <?php function boot($classname) { $filename = ''; $namespace = ''; // sets include path "src" directory $includepath = dirname(__file__).directory_separator.'src'; if (false !== ($lastnspos = strripos($classname, '\\'))) { $namespace = substr($classname, 0, $lastnspos); $classname = substr($classname, $lastnspos + 1); $filename = str_replace('\\', directory_separator, $namespace) . directory_separator; } $filename .= str_replace('_', directory_separator, $classname) . '.php'...
Read more

java - How to put two numbers separated by a space into two different arrays -

-
i have 2 number inputs 1010 212 i want put these 2 different arrays ([1 0 1 0] , [2 1 2]) this code import java.io.*; import java.util.*; public class solution { public static void main(string[] args) { int array[] = new int[8]; int array2[] = new int[8]; int = 0; scanner getnumber = new scanner(system.in); { array[i] = getnumber.nextint(); i++; } while(getnumber.hasnextint()); system.out.println(arrays.tostring(array)); } } but output [1010, 212, 0, 0, 0, 0, 0, 0] (i put 8 generic array length because java compiler forced initialize each array) you need store numbers first initialize arrays based on length of number. can length turning string. once left number , empty array, can split integer array of digits number of ways. int[] array, array2; scanner in = new scanner(system.in); int a, b; = in.nextint(); b = in.nextint(); array = new int[integer.tostring(a...
Read more

python - matplotlib equivalent for Ubuntu servers with no GUI? -

-
i have gui-less cloud server running bitnami-django ubuntu 14.04 lts meant retrieve , graph data users, cannot produce graphs. clear, care graph image produced , saved, not user has option click button save image. such functionality meaningless such server. on normal ubuntu linux (mate) 14.04 lts, scripts work perfectly, producing matplotlib.pyplot relevant data in gui window save, zoom, rotate , other functionality; on cloud server error, if don't try invoke show() function: bitnami@stockpredix:/opt/bitnami/apps/django/django_projects/project$ python api-test_volume.py traceback (most recent call last): file "api-test_volume.py", line 8, in <module> import matplotlib.pyplot plt file "/opt/bitnami/python/lib/python2.7/site-packages/matplotlib/pyplot.py", line 114, in <module> _backend_mod, new_figure_manager, draw_if_interactive, _show = pylab_setup() file "/opt/bitnami/python/lib/python2.7/site-packages/matplotlib/backend...
Read more