PDA

View Full Version : Reading MS Excel


Shiamak
02-27-2013, 03:30 PM
is it possible to read a column and line number in MS EXCEL using VBP?

kinook
02-27-2013, 03:37 PM
http://www.google.com/search?q=read+excel+cell+vbscript

Shiamak
02-27-2013, 03:49 PM
How do you I read the value in a macro or bunch of macros?

kinook
02-27-2013, 03:56 PM
I don't understand the question.

Shiamak
02-27-2013, 04:11 PM
I don't understand the question.

I am trying to read an excel file that contains .config values (to be repalced in .config file), hence I want to be able to read specific sections of ms excel file containing VALUEs and put those values in VBP global macros hence once I have read the whole excel spreadsheet into global macros, I can use these macros to replace values in my .config file.

Hope this is bit more clear.

kinook
02-27-2013, 04:26 PM
See the attached sample.