Anthony's VBA Forum Index Anthony's VBA Forum
Where the knowledge is shared
Menu
 Anthony's VBA Forum IndexHome Page
 Anthony's VBA Forum IndexForum Index
FAQFAQ
MemberlistMemberlist
UsergroupsUsergroups
RegisterRegister
ProfileProfile
Log in to check your private messagesMessages
Log inLogin/Out

Quick Search

Advanced Search

Links
Consulting
Products

Who's Online
[ Administrator ]
[ Moderator ]


Search found 9 matches
Anthony's VBA Forum Index
Author Message
  Topic: how many cols of strarr had splited??
bshaen

Replies: 3
Views: 22118

PostForum: Portfoilio Optimization   Posted: Tue Jan 18, 2005 11:56 pm   Subject: how to know total record in text file
cool.. thank Data.

except using the c=c+1 in every input record. what the method else i can using to know tatal record in text file
Question
  Topic: how many cols of strarr had splited??
bshaen

Replies: 3
Views: 22118

PostForum: Portfoilio Optimization   Posted: Mon Jan 17, 2005 8:54 pm   Subject: how many cols of strarr had splited??
strarr = Split(str1, " ")

i would like to ask, how we know, how many cols of strarr had splited?? what the method i can get the total n of strarr?? <<strarr(n)>>

and i want split th ...
  Topic: how can vb recogrite how many col we need to display??
bshaen

Replies: 5
Views: 28270

PostForum: Portfoilio Optimization   Posted: Mon Jan 17, 2005 12:52 am   Subject: how can vb recogrite how many col we need to display??
sorry, can u futher explain of the instring function with example???
  Topic: how can vb recogrite how many col we need to display??
bshaen

Replies: 5
Views: 28270

PostForum: Portfoilio Optimization   Posted: Sun Jan 16, 2005 9:32 pm   Subject: how can vb recogrite how many col we need to display??
how the coding i can apply???
casue i know
.TextFileConsecutiveDelimiter = True
but i don't know how to specific to 2 space??? can u give me some idea of it? thank
  Topic: how can vb recogrite how many col we need to display??
bshaen

Replies: 5
Views: 28270

PostForum: Portfoilio Optimization   Posted: Fri Jan 14, 2005 5:51 am   Subject: how can vb recogrite how many col we need to display??
test.txt
1 A A Flute 1.00 1.00 1.00
2 A1 A1 FLUTE 1.00 0.00 1.00
3 AB AB Flute /Double Wall 1.00 2.50 1.00
4 ABC ABC Flute ...
  Topic: possible for us use the vb to open application
bshaen

Replies: 7
Views: 31983

PostForum: Portfoilio Optimization   Posted: Thu Jan 13, 2005 11:17 pm   Subject: possible for us use the vb to open application
yes, i would like to import external data into excel from read the data from text file. that ok, i will try the site later, thank your advice... Smile
  Topic: possible for us use the vb to open application
bshaen

Replies: 7
Views: 31983

PostForum: Portfoilio Optimization   Posted: Tue Jan 11, 2005 10:28 pm   Subject: save marco as exe?
that is possible for us to save the marco to exe format??? if that is possible, can u guide me some idea. thank!!
  Topic: possible for us use the vb to open application
bshaen

Replies: 7
Views: 31983

PostForum: Portfoilio Optimization   Posted: Tue Jan 11, 2005 9:56 pm   Subject: possible for us use the vb to open application
thank a lot, but i have try it by the simple coding just now, but that pop up a error: which is run-time error '429'. activeX component can't create object.

this is the simple coding i tried.

P ...
  Topic: possible for us use the vb to open application
bshaen

Replies: 7
Views: 31983

PostForum: Portfoilio Optimization   Posted: Mon Jan 10, 2005 10:22 pm   Subject: possible for us use the vb to open application
it's possible for us to use vb to read text file and open it in excel. and make it in exe format so that we can directly open the exe to open the excel?? can u guild me some idea.. thank!!
 
Page 1 of 1
All times are GMT - 4 Hours
Jump to:  


Powered by phpBB © 2001, 2002 phpBB Group