Programming Forums - Easy Question on VB for Excel

Programming Forums (http://www.programmingforums.org/forumindex.php)

- Visual Basic (http://www.programmingforums.org/forum18.html)

- - Easy Question on VB for Excel (http://www.programmingforums.org/showthread.php?t=8302)

Aussiemex

Feb 7th, 2006 11:51 PM

Easy Question on VB for Excel

I imported data from excel to another excel workbook using "import external data". However, everytime I refresh de data, the source files locks and noone can open it. Is there anyway to unlock the file or disconnect the ole db. Could i create a macro on vb to disconnect or unlock the source file.
Thanks!!!!

All times are GMT -5. The time now is 7:36 PM.