Quantcast

Maximum PC

It is currently Mon Sep 01, 2014 5:33 pm

All times are UTC - 8 hours




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Got some questions for you excel and visual basic Guru's
PostPosted: Mon Aug 09, 2004 10:24 am 
Klamath
Klamath

Joined: Wed Jul 21, 2004 5:31 pm
Posts: 275
Hey all. Ive been working on some stuff lateley, and I need a few bits of info on visual basic and excel

first off; when you are editing a macro in visual basic, is there a way to determine the size of the macro (disk space it will take up) while you are editing it, or just simply a way to find out after you save it

Also, if you have a saved sheet, that you delete the macros from, and resave it, will it still be the same size?

Lastly, is there a way to determine where all the space is comming from on an excel sheet? (im trying to fix one at work that is 2.5 megs!!)

This is all on office 2000 btw =). Thanks in advance


Top
  Profile  
 
 Post subject: Re: Got some questions for you excel and visual basic Guru'
PostPosted: Mon Aug 09, 2004 12:11 pm 
Northwood
Northwood
User avatar

Joined: Sun Jul 11, 2004 12:35 pm
Posts: 2039
Location: Houston, TX
havocdragon wrote:
Hey all. Ive been working on some stuff lateley, and I need a few bits of info on visual basic and excel

first off; when you are editing a macro in visual basic, is there a way to determine the size of the macro (disk space it will take up) while you are editing it, or just simply a way to find out after you save it

Also, if you have a saved sheet, that you delete the macros from, and resave it, will it still be the same size?

Lastly, is there a way to determine where all the space is comming from on an excel sheet? (im trying to fix one at work that is 2.5 megs!!)

This is all on office 2000 btw =). Thanks in advance


you might give the "Programmer's Paradise" a shot with this topic.


Top
  Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC - 8 hours


Who is online

Users browsing this forum: No registered users and 8 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group