Kinook Software Forum

Go Back   Kinook Software Forum > Visual Build Professional > [VBP] General Discussion
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 02-27-2013, 04:30 PM
Shiamak Shiamak is online now
Registered User
 
Join Date: 02-07-2006
Posts: 84
Reading MS Excel

is it possible to read a column and line number in MS EXCEL using VBP?
Reply With Quote
  #2  
Old 02-27-2013, 04:37 PM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 6,034
http://www.google.com/search?q=read+excel+cell+vbscript
Reply With Quote
  #3  
Old 02-27-2013, 04:49 PM
Shiamak Shiamak is online now
Registered User
 
Join Date: 02-07-2006
Posts: 84
How do you I read the value in a macro or bunch of macros?
Reply With Quote
  #4  
Old 02-27-2013, 04:56 PM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 6,034
I don't understand the question.
Reply With Quote
  #5  
Old 02-27-2013, 05:11 PM
Shiamak Shiamak is online now
Registered User
 
Join Date: 02-07-2006
Posts: 84
Quote:
Originally Posted by kinook View Post
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.
Reply With Quote
  #6  
Old 02-27-2013, 05:26 PM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 6,034
See the attached sample.
Attached Files
File Type: zip readexcel.zip (2.4 KB, 1755 views)
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



All times are GMT -5. The time now is 03:00 AM.


Copyright © 1999-2023 Kinook Software, Inc.