Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 122
Default easye compile question

Hi experts,

Can anybody explain to me what " Compile VBAproject " means.

- What happens if i do that and why should i do this ?

I found that if i do not compile, my applications won't run on other pc's. Is
that true or...?
Thanks,
Pierre


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200511/1
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,718
Default easye compile question

When you select this optional command VB tries to tokenize your code and in
the course of doing that finds certain kinds of errors such as undeclared
variables (if you use Option Explicit as you should), subs and function that
cannot be found (maybe due to misspelling or missing references), object,
property, method errors like using a workbook method with a worksheet, etc.

--
Jim
"Pierre via OfficeKB.com" <u13950@uwe wrote in message
news:5704cf3d29d1a@uwe...
| Hi experts,
|
| Can anybody explain to me what " Compile VBAproject " means.
|
| - What happens if i do that and why should i do this ?
|
| I found that if i do not compile, my applications won't run on other pc's.
Is
| that true or...?
| Thanks,
| Pierre
|
|
| --
| Message posted via OfficeKB.com
| http://www.officekb.com/Uwe/Forums.a...mming/200511/1


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
HOW CAN I COMPILE 2 SHEETS? Sweeney * New Users to Excel 2 October 19th 09 05:08 PM
compile Duplatt New Users to Excel 5 March 26th 09 01:51 AM
Won't Compile GeorgeJ Excel Discussion (Misc queries) 3 July 30th 07 09:22 PM
Compile Error: Procedure too Large Question Daniel R. Young Excel Programming 6 July 21st 05 08:01 PM
compile error - pls help tango Excel Programming 1 October 28th 04 09:13 AM


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

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

About Us

"It's about Microsoft Excel"