LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default VBIDE.Codemodule.addfromfile putting code in wrong place

Dear all,

I am using VBIDE.Codemodule.addfromfile "NameOfFile.bas" to append a
procedure to a VBComponent. The problem is that in this VBComponent I
have variables declarations and one in the middle that is Public, and
the VBE engine is appending the procedure several lines above this
declaration, although the first procedure is several lines bellow. Any
suggestion?

Thanks,
GM
 
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
Check for Complie Error in VBA code via VBIDE ExcelMonkey Excel Programming 1 September 27th 09 01:20 PM
CodeModule.AddFromFile problem Frederick Chow Excel Programming 0 March 23rd 06 06:04 PM
Putting a formula in place one time for the entire spreadsheet jacob Excel Programming 2 August 3rd 05 01:26 AM
Putting a formula in place one time for the entire spreadsheet jacob Excel Programming 6 May 6th 05 03:39 PM
modifying code using addfromfile method PaulR Excel Programming 2 March 18th 05 11:10 PM


All times are GMT +1. The time now is 06:47 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"