Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default External Variable Declaration


I had seen that, but the problem is that I do not want to insert
module or a procedure, I just want to insert three lines of code (o
execute them externally... it at all possible). The problem is that
donīt know how to replace the lines that already exist in the progra
with the lines that exist in the txt file.

What I really want is something like the C insert command...

--
ehnt
-----------------------------------------------------------------------
ehntd's Profile: http://www.excelforum.com/member.php...fo&userid=1586
View this thread: http://www.excelforum.com/showthread.php?threadid=27355

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,253
Default External Variable Declaration

do you mean s'thing like:

Option Explicit

Public globals(4) As Integer

Sub ReadGlobs()
'Fills the array globals with
'the data contained in a txt file.

Dim i%

Open "c:\globals.dat" For Input As #1
While Not EOF(1) And i <= UBound(globals)
Input #1, globals(i)
i = i + 1
Wend
Close #1

End Sub





keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


ehntd wrote:

http://www.excelforum.com/showthread...hreadid=273553


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding a variable into a range declaration Malvaro Excel Worksheet Functions 2 June 24th 08 06:28 PM
VBA - variable declaration Jeff Excel Discussion (Misc queries) 3 January 9th 08 12:45 PM
External Variable Declaration ehntd Excel Programming 1 October 29th 04 10:50 AM
Global variable declaration! aiyer[_12_] Excel Programming 3 April 13th 04 04:35 PM
Variable Declaration?? Tom Ogilvy Excel Programming 1 August 8th 03 06:45 PM


All times are GMT +1. The time now is 04:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright Đ2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"