Page 1 of 1

Import data to excel from the given folder

Posted: Thu Jun 05, 2014 7:47 am
by Komal Jadhav
Can i import data to excel from the folder? eg: i have folder named Path which includes diiferent file names. and i want all the file names in that folder should automatically displayed in excel sheet which i am using to bound variables from my Script.

Re: Import data to excel from the given folder

Posted: Thu Jun 05, 2014 8:40 am
by mzperix
Hi Komal,

this is more of an Excel programming related question. You have to use Macro programming to make this happen.

Here is an MSDN how-to about getting the file of a folder: http://msdn.microsoft.com/en-us/library/kf41fdf4.aspx

And to start macro programming: just use macro recordig, do some stuff in excel, and look the generated code. After that just use google. Make sure to include "vb" in your search term.

Kind Regards,
Zoltan

Re: Import data to excel from the given folder

Posted: Thu Jun 05, 2014 10:28 am
by odklizec
I think what he looks for is updating an existing excel data connector with some new data? I'm afraid, there is not an easy way to do so. I would suggest to check this post...
http://www.ranorex.com/forum/updating-e ... t4820.html