Excel External Data Connection crashing on other users -

-

i have tool.xlsx file uses external data connection access db (both on network drive, available users proper access rights). have vbscript (code below) refreshes connections in workbook. works charm when running script when colleague runs it, throws no errors not connections refreshed. ideas?

dim xlapp dim xlwkb set xlapp = createobject("excel.application") xlapp.visible = false xlapp.workbooks.open "\\networkpath\tool.xlsx" xlapp.displayalerts = false set wr = xlapp.workbooks.open("\\networkpath\tool.xlsx") wr.refreshall xlapp.visible = false wr.save wr.close

and here connection string tool.xlsx workbook:

provider=microsoft.ace.oledb.12.0;user id=admin;data source=\\networkpath\db.accdb;mode=share deny write;extended properties="";jet oledb:system database="";jet oledb:registry path="";jet oledb:engine type=6;jet oledb:database locking mode=0;jet oledb:global partial bulk ops=2;jet oledb:global bulk transactions=1;jet oledb:new database password="";jet oledb:create system database=false;jet oledb:encrypt database=false;jet oledb:don't copy locale on compact=false;jet oledb:compact without replica repair=false;jet oledb:sfp=false;jet oledb:support complex data=false;jet oledb:bypass userinfo validation=false;jet oledb:limited db caching=false;jet oledb:bypass choicefield validation=false

here's different approach @ refreshing each connection @ once:

on error resume next dim xlapp dim xlwkb set xlapp = createobject("excel.application") xlapp.visible = false xlapp.displayalerts = false set wr = xlapp.workbooks.open("\\networkpath\tool.xlsx")     each cn in wr.connections         cn.refresh     next wr.refreshall xlapp.visible = false wr.save wr.close


Comments

Post a Comment

Popular posts from this blog

javascript - Karma not able to start PhantomJS on Windows - Error: spawn UNKNOWN -

-
i lost "unknown" error: karma.conf.js: frameworks: ['mocha', 'should'], plugins: ['karma-mocha', 'karma-should', 'karma-phantomjs-launcher'], ... browsers: ['phantomjs'], error: 23 07 2015 14:35:37.691:warn [karma]: no captured browser, open http://localhost:9876/ 23 07 2015 14:35:37.701:info [karma]: karma v0.13.3 server started @ http://localhost:9876/ 23 07 2015 14:35:37.707:info [launcher]: starting browser phantomjs 23 07 2015 14:35:37.738:error [karma]: { [error: spawn unknown] code: 'unknown', errno: 'unknown', syscall: 'spawn' } error: spawn unknown @ exports._errnoexception (util.js:749:11) @ childprocess.spawn (child_process.js:1093:11) @ exports.spawn (child_process.js:933:9) @ object._execcommand (c:\users\jinga4x\git\mdl-sample-project\node_modules\karma\lib\launchers\process.js:63:21) @ object._start (c:\users\jinga4x\git\md...
Read more

Nuget pack csproj using nuspec -

-
i want create nuget package contains specified in nuspec file, still version csproj. in order use token have pack like: nuget pack myproj.csproj but when adds dependencies , creates unwanted folder in nuget package. nuspec file is: <?xml version="1.0" encoding="utf-8"?> <package xmlns="http://schemas.microsoft.com/packaging/2011/08/nuspec.xsd"> <metadata> <id>test</id> <version>$version$</version> <title>test</title> <authors>test</authors> <owners>test</owners> <requirelicenseacceptance>false</requirelicenseacceptance> <description>test</description> <summary>test</summary> <releasenotes>test</releasenotes> <copyright>test</copyright> </metadata> <files> <file src="bin\debug\*.dll" target="lib\net45" /> <file s...
Read more