| Thread | Last Post | Replies |
|
| runtime err 76 on some laptops | 26 Sep 2006 14:56 GMT | 3 |
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 worksheets | 26 Sep 2006 14:49 GMT | 4 |
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 bar | 26 Sep 2006 14:47 GMT | 3 |
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 userform | 26 Sep 2006 14:23 GMT | 2 |
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() negative | 26 Sep 2006 14:06 GMT | 2 |
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 location | 26 Sep 2006 14:05 GMT | 1 |
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 VBA | 26 Sep 2006 13:56 GMT | 3 |
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 GMT | 3 |
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 Number | 26 Sep 2006 13:42 GMT | 1 |
~~~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 once | 26 Sep 2006 13:36 GMT | 1 |
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 connection | 26 Sep 2006 13:35 GMT | 1 |
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 ...
|
| Hyperlinking | 26 Sep 2006 13:32 GMT | 3 |
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 saveas | 26 Sep 2006 13:30 GMT | 1 |
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_Activate | 26 Sep 2006 13:24 GMT | 2 |
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 workbook | 26 Sep 2006 13:17 GMT | 1 |
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
|