-
- Displaying the description of a function and each of the variables within "function arguments" window.
by ikeriba
- 0 Replies
- Last post
by ikeriba
- Dear all,
When I want to insert a function into a cell, I press "insert function", I select the function that I need from the list, and a new window is displayed with a brief description of the function, and also the description of each of the variables in the function.
How can I add this descriptions for my own functions
Thanks!
-
- Excel VBA - Copying Recordset to Array
by HMote
- 1 Replies
- Last post
by Luiz Claudio - MVP
- I for the life of me cannot figure out how to do, what I figure, should be a simple task; I need help on how to copy the contents of a recordset to an array in VBA. I have my recordset ready to go, but I have no clue on how to copy it's contents to an array.
In my routine, I want to access this array to find out if a date already exists in the db before inserting the new data, so I only ha
-
- Implementing time synchronization through VBA
by mnptl
- 1 Replies
- Last post
by mnptl
- I am developing a small application that needs to include an audit trail function, with date and time stamping. To ensure that the time stamp is valid, I would like to either (1) force the local machine to synchronize with an external, trusted site (such as time-a.nist.gov), or (2) go and grab the time directly from an external, trusted site.
How on earth can I do this with VBA
S
-
- VBA and .Net
by Jeff54
- 1 Replies
- Last post
by Andy Pope
- For Excel (2007), is there a plugin that allows one to develop macros in VB.Net or C# or do we need to stick with VBA (VB6)
-
- Directss Install
by Edday
- 4 Replies
- Last post
by AzmathMoosa
- hey i have written a program in Excel using VBA and it used a module called DirectSS which is like the application.speak but is much more customisable (speed, tone, visual) which is why i used it. When i got home, i went to work on it and DirectSS isn't installed on my computer. I have googled quiet abit and found next to nothing on DirectSS. Does anyone here know how to install it or where to get
-
- BSM 2005
by Tony Spaulding
- 0 Replies
- Last post
by Tony Spaulding
- Will BSM 2005 pull data from Excel for display
Thanks,
Tony
-
- Docmd.OpenReport
by vosmerkin
- 0 Replies
- Last post
by vosmerkin
- I'm opening the report with the command Call DoCmd.OpenReport("rptCollection_Userwise_Receiptwise", acViewPreview, , strFilter, acDialog) where strFilter = "DATE_RCPT BETWEEN #09-06-06# AND #09-06-07# AND TIME_RCPT BETWEEN #07:00# AND #20:00#" or strFilter = "DATE_RCPT BETWEEN #09-06-06# AND #09-06-07# AND TIME_RCPT BETWEEN #07:00# AND #20:00# AND USER_ID='Admin' AND AC
-
- Finding out the Modules (VBA) Access password...
by Lant
- 1 Replies
- Last post
by Spidermans_DarkSide - MSP, VSI
- Hi there, I'm working in project which has a system in MS Access. And we have to provide some enhancements on that, but the coding area (called Modules) into this MS Access file is protected by a password... and anyone knows this password. I have already found few good programs which finds out the password from .mdw file, but they don't work fine with the VBA (Modules) password. So... I'm here...
-
- Sharepoint 2007 help
by Sisco22
- 2 Replies
- Last post
by MS ISV Buddy Team
- Hey everyone, Is there an easy way to migration sites and data from Sharepoint 2003 to Sharepoint 2007. Each version is on a seperate server. Thanks!
-
- Counting words
by une
- 10 Replies
- Last post
by une
- Does there exist a predefined function that counts the number of words in a string
-
- How to activate a listbox selection using Excel VBA?
by Kven
- 14 Replies
- Last post
by Andy Pope
- Hi,
I am very new to VBA Progamming. I have created a tool which checks for error in excel file. The below is my problem.
First i will select a file using Openfile method. Then the combobox will display all the sheets which are present in the selected excel file. Here i will select a excel sheet and run a code to check errors. The procedure will check the errors and shows how many errors
-
- iexplore.exe - Application Error
by bennett1016
- 14 Replies
- Last post
by rreynard
- I get the following error message when I close my internet explorer.
The instruction at "0x62304320" referenced memory at "0x62304320", The memory could not be "read". Click on OK to terminate that program.
Any ideas what is causing this
-
- A macro to count the number of macros in a woorkbook
by slimshamus
- 4 Replies
- Last post
by tracycan
- Hello all,
I need to loop through a bunch of excel workbooks, open them, and determine if there are any macros in the workbooks, and if there are, how many.
I know how to loop through the workbooks and open them. But how can I display the names of the macros that are defined in the workbook This must be possible.
Thanks!
-
- ListBox Item Color
by Basha Sk
- 4 Replies
- Last post
by Basha Sk
- Hi All,
I am having two Listboxes. The ListBox1 is having some items and the ListBox2 is used to display the SubItems of the ListBox1 items. If i select two items in ListBox1 then these two items subItems will be dispalyed in ListBox2. So How can i differentiate these subItems with respect to their Parent items. Is it possible to set ForeColor to each item of a ListBox. Thanks in Advance.
-
- browsing OWC via client side problem
by chunli
- 1 Replies
- Last post
by MS ISV Buddy Team
- I have an issue when browsing Microsoft Business Scorecard Manager 2005 from another laptop, the PivotChart built with Microsoft Office Web Component version 12 can not connect to the Data Source, that is OLAP Cube built with Microsoft SQL Server 2005 Analysis Service. There is a warning sign in the OWC frame showing the error description: Failed to get data. If available, errors returned from the
-
- iexplore.exe - Application Error (EVERY TIME I CLOSE IE7) :(
by sapphireoceans
- 14 Replies
- Last post
by Jillytodd
- Hi, I am absolutely clueless as to why this keeps happening, but it is driving me insane!! The exact error message reads: 'The exception unknown software exception (0x0eedfade) occurred in the application at location 0x7c81eb33.' Could anyone shed some light on maybe what the cause is and/or how I can fix it Thank you in advance to anyone who reads and/or offers any information. Laura x
-
- How to write this code?
by lyp_sj
- 1 Replies
- Last post
by magicalclick
- Hello:
I wanna embed a variable i1 into Rows("i1+1:i1+1").delete code. How can I write this code correctly Thanks so much!
B.regards/Yaping
-
- CRM 3.0 : Changed Contact view under customization but CRM do not reflect
by DreamerZ
- 1 Replies
- Last post
by ManMis
- Changed contacts view in advanced find, lookup, active view, my active views under settings: customization
but CRM did not reflect the changes
anyone can help to resolve
Thanks
Hee Teck
-
- How do I count only the worksheets from the ActiveSheet to the last sheet?
by MyLady
- 4 Replies
- Last post
by MyLady
- Hey,
Case: Let¡¯s say I have a workbook with ten sheets and have selected a sheet somewhere in between the ten sheets.
How do I count only the worksheets from the ActiveSheet to the last sheet
Can anyone show me how to do it with a code
Regards
Cathrine
-
- WER wish list for developers 8-)
by Claus Brod
- 14 Replies
- Last post
by Joel Stein
- Jason Hardester posted today about some of the decisions made at Microsoft around WER, and concluded with a call to action to collect requirements for WER from a developer point of view. I'm glad to oblige (And thanks, Jason, for your helpful post.) My main issue with the current implementation of WER, particularly on Vista, is that it makes it hard for a developer to find out whether a crash rep
-
- Microsoft Document Image Printer - MODI Registry Settings
by Cheval
- 8 Replies
- Last post
by JoeDee
- Does anyone know what are all the available registry settings for MODI Through much searching in google (msn search finds nothing) I've found the following the following ' Write to File Only (uses current save folder and Note####.mdi as file name) SetKeyValue HKEY_CURRENT_USER, "Software\Microsoft\Office\11.0\MODI\MDI Writer", "PrivateFlags", 1, REG_DWORD ' Don't Show Popup Wi
-
- Variable no longer retaining value when using Word 2003
by William Klein
- 1 Replies
- Last post
by William Klein
- I'm having a problem with a Macro that is a Word Template. Under Office 2000 this macro works when users started getting Word 2003 things started to break. Here is what is happening.
The main Word Template essentially contains a menu which branches off to several other templates depending on which menu option you choose. Here is some sample code.
Public Const c_TemplateDir = "P:
-
- Class / Object in Excel 2003
by Daniel Murta Barros
- 3 Replies
- Last post
by Jon Peltier
- hi people,
It's my first time here...and, i need help.
How can i make objects (module class - with atributes and methods) in excel 2003
I don't find help about this.
Thanks!
-
- MS Office document and image writer print driver
by GTH
- 14 Replies
- Last post
by Mary3480
- Besides removing this feature from Office during setup, is there a process to remove this virtual printer from 300 users with roaming profiles on an active directory network We are having an issue with this printer assuming the "default printer" selection for our users. As a work around we have changed their default printer, but after they reboot or log off / on it has defaulted back to
-
- Can I disable keys in Excel while a cell is selected?
by Gurileck
- 4 Replies
- Last post
by Gurileck
- I have made use of the onkey function in vba to disable most keyboard shortcuts, however if the user is in the middle of entering text into a cell, he can press any of the disabled shortcuts and they will work. Is there any way to make them stay disabled