Azure Remote App: Import Excel Range Into Access -


i have following code within form startup procedure in access front end accessing sql end. code below, opens excel file, goes data tab , retrieves value named range, works fine. however, when migrate front end azure image , publish in remote desktop, while value retrieved , updated database, procedure hangs up. using alt-ctl-end open task manager, find excel still open, , need end task on excel before access front end moves forward in procedure. hunch, excel waiting response on something, there no dialogs open deal with. ideas?

set xl = createobject("excel.application") set xlbook = xl.workbooks.open(srwfile) set xlsheet = xlbook.worksheets("data") xl.visible = false xlbook.windows(1).visible = false xlsheet dvalue = .range(srwrange) end xlbook.close , true set xlsheet = nothing set xlbook = nothing set xl = nothing 


Popular posts from this blog