Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / September 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
runtime err 76 on some laptops26 Sep 2006 14:56 GMT3
on some laptops the following fails with a 76 run time eror on the copyfolder
line
       Set FsO = CreateObject("Scripting.FileSystemObject")
       sourceFolder = "CMA_Camera_Pictures"
Bug in Excel 2003 involving ActiveX Controls on worksheets26 Sep 2006 14:49 GMT4
I have discovered that there is a bug in Excel 2003 (and Excel 2002), which I
think has propagated since Excel 97.  I have found references to this bug for
Excel 97 (with workarounds identified), but the bug still exists and worse,
the workarounds identified for Excel 97 do not ...
creating command bar26 Sep 2006 14:47 GMT3
Ive looked up the help and created a custom toolbar which is created upon
opening the workbook.
How do I:-
1) Destory this toolbar on closing of the workbook.
Dynamic forms in a macro userform26 Sep 2006 14:23 GMT2
At the moment i am trying to dynamically type out a form.
By inputting the id of a user in textbox1 it looks in a1 to a2000 for the id.
So say the value of a16 is returned, i want it to be able to write the value
of b16 in textbox2. the same as if a256 was given b256 would be ...
excel rand() negative26 Sep 2006 14:06 GMT2
When I run the equation =rand() sometimes I get a negative number, when I
should get a number between 0 and 1.  Am I doing something wrong or is this a
glitch?  I am running excel 2003.
Identifying embedded object # and location26 Sep 2006 14:05 GMT1
We have an embedded object in our worksheet at location say D18.  
Programmatically, how do we identify what object is at that location.  There
may be more than one embedded object on the worksheet so how would we address
that?
Stripping spaces using a formula, not VBA26 Sep 2006 13:56 GMT3
I know hwo to do it using VBA but was asked to perform using only
formulaes, so if anyone could help me?
A field in the spreadsheet contains a string built up by up to 8
numbers separated by various numbers of spaces,
PC date format (M, MM vs. MMM) messes up formula...26 Sep 2006 13:51 GMT3
We have over 200 Excel files on a server (for different areas of the
company) that include the formula below. Our computers, by default, have the
windows date setting of M/d/yyyy (or some may have MM/dd/yyyy?). Our
organization just changed policy to avoid day/month vs month/day ...
Verify Phone Number26 Sep 2006 13:42 GMT1
~~~WOW, this accidenlty went to Access Newsgroup.  Must not have been paying
attention this morning!!~~~~
Is there a method for verifying first if the data entered is a valid number,
then if it's a valid phone number?  By Valid phone number I mean is it 10
how to print all the criterions at once26 Sep 2006 13:36 GMT1
When I use the "AutoFilter", I want to print at once all the possible
criterions of one filter, without the necessity to choose and print the
criterions, one by one.
Thank for your time
DDE connection26 Sep 2006 13:35 GMT1
I have a simple macro that commuincates with another program by using a dde
connection. the problem is that I get an error message almost every time time
I run the program fo rthe first time (ie a DDE connection was not established
prior to my running the macro). Thus it may be ...
Hyperlinking26 Sep 2006 13:32 GMT3
I can't find out how to hyperlink to a specific sheet in a file, so I am
trying to write some event code, so when a particular cell is selected it
opens the file and selects the correct sheet.  Should I be able to do it
through hyperlink or is code the only way?
How to retain the size of excel file after using saveas26 Sep 2006 13:30 GMT1
           I am facing some size related problem with excel
workbook....
                 I have a workbook at specific location. I am opening
that file and using saveas option to save it in a different folder. but
Worksheet_Activate26 Sep 2006 13:24 GMT2
There is an excel with 2 sheets sheet1 and sheet2 with their respective
Worksheet_Activate
methods. on going from sheet1 to sheet2 and back(in debug mode)  the
respective Worksheet_Activate methods are being invoked.
Save workbook26 Sep 2006 13:17 GMT1
Is there a way to save the current workbook, or worksheet without the code
module.  I am currently forcing the save as method so my main file does not
get overwritten.
Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.