-
- LCS 2005 Not Showing Options in Administrative MMC
by carbon64
- 2 Replies
- Last post
by MS ISV Buddy Team
- I recently installed Live Communications Server 2005 Standard on a Windows 2003 Server which is a member of our domain. Everything seems to be working correctly with Messenger 5.1 however when I try to Use the Administrative snap-in it only shows the text Live Communication Server 2005. It does not give me a tree structure with options and nothing appears under the actions menu options. I logged i
-
- Difficulty using the Findrecord Method
by JBNV123
- 5 Replies
- Last post
by JBNV123
- Hi, for some reason if I use the code following (changed for my spefic data of course) I do not get the desired record to display, in fact I get only the record I am currently viewing to display, ie it is as though nothing is happening. This code is supposed to search for the record with "Joe" in the "FirstName" field and display it and also store the record number of interest
-
- Worksheet_Change and Undo buffer
by Luctifo
- 2 Replies
- Last post
by Luctifo
- Hello,
Did anybody found a way around the "Undo" buffer clearing when firing any VBA code
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
-
- Problem passing a range as argument
by Douglas Penna
- 3 Replies
- Last post
by Douglas Penna
- Hello there,
I'm developing a macro do do some calculations on a worksheet, but I always get a problem when I pass a Range as an argument to my function.
My code is simple, and here it is:
Sub Main() Dim Range_do_Comeco As Range Set Range_do_Comeco = Worksheets("Plan1").Range("AD2") MyFunc(Range_do_Comeco ) End Sub
Sub MyFunc(ByR
-
- Verifying completion of a file's creation from VBA
by kenmcd4
- 1 Replies
- Last post
by DMan1
- I need a way to monitor a file in a folder (created by an external application, such as Word or Acrobat), and verify that the process of writing to the file has completed (in Windows 2000 or XP). I.e., that the file is finished, and can be opened by Excel. It's easy to verify that the file exists, and what it's file length is, but the file length continues to increase as the file is written to (es
-
- Highlight Row depending on cell - Excel VBA -
by Reuben B
- 3 Replies
- Last post
by kent kindberg
- Hi All
I need some help with this code ......
I have a sheet full of data, Col A , B & C full of data and col D is 1 or 0 ... I need to highlight all rows in red whenever there is a 0 in Col. D when i press a button (that i know how to create !)
I don't want to use conditional format as the sheet slows down drastically using this method !!
Thanks
-
- MS Office document and image writer print driver & port
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
-
- How to automatic to logon web server?
by Perry Choy
- 0 Replies
- Last post
by Perry Choy
- I want to auto logon a web server, when i browse the web page that prompted pop-up windows required to enter the username and password, whether or not a functions or API to doing somethings for this requirtment. Thank you very much!
-
- Excel 2003 Macro to VB .Net v7
by Bakersacres
- 4 Replies
- Last post
by M,Ramesh
- All, I've seen bits and pieces of this topic, but not enough to get me there, so here's my situation. I've created a set of Macros in Excel 2003, that I want to turn into a .exe that can be called from a DOS window with a set of command line parameters. I would think the first thing that needs to be done is to save the Macros as a VB Project, but I don't see how that is done &
-
- vba code lookup and match - need checking - help
by keilah
- 1 Replies
- Last post
by Cringing Dragon
- I have somehow managed to put some code together to complete a task that i have found some difficulty with.
Match and delete a row from table. Need some help fixing the code..........
ArrNames = Array("creation1", "creation2", "creation3", "Creation4", "creation5", "creation6", "creation7", "creation8", &
-
- windows vista program files protection
by sharadam
- 4 Replies
- Last post
by sharadam
- Hai all, i am installing my application at c:\program files\ APPFolder. At the time of installation, default settings are stored in config file at c:\program files\ APPFolder\configsettings.xml . when i made changes in application , i am updating all settings to an XML file . when i unistall my aplication i am removing xml file. when i reinstall my application as admin , again config file with d
-
- how to use variable to automate selection of a worksheet
by sree
- 6 Replies
- Last post
by sree
- Hi all!!!!!!
Thank you in advance for helping me with this.
I need to know how can i use a variable in VBA to read data in a cell which should be the worksheet name of one of diffrent worksheets in a diffrent workbook.
To simplify- i have two workbooks [Book1.xls and Book2.xls]
i need to run a macro to read A3 in sheet 1 of Book1 and store it in a variable A.
-
- Format text in MsgBox
by une
- 5 Replies
- Last post
by une
- How do I format text that is presented in message boxes. I have looked for what I know as escape characters, but like a lot of things maybe MS calls these something else. I want to for example add newlines and tabs. Changing font would be handy also, as would the ability to add images. If you can help on the fonts and images fine, but at the moment I really need to be able to add newlines and tabs
-
- Outputting to a Listbox
by UniRyan
- 7 Replies
- Last post
by Andy Pope
- Hi;
I have a list of data, and need for values outside a lower and upper bound to be flagged up to the user. I was thinking of outputting to a listbox, but cant get the code to work. I was wondering if anyone had any ideas for possible code, or a better way of outputting to the user.
Ryan
-
- VBA Macro created in Word Template not running when template is launched in Internet Explorer
by S Prasad
- 6 Replies
- Last post
by S Prasad
- Hello:
I have a Word template that contains a VBA application. This application is launched through a macro and runs fine when I double click and open the template using MS Word. However, when I tried to open the same WORD template file in Internet Explorer (this is the final requirement), it fails to launch the application or run the macro. I am already using the following code in the ThisDoc
-
- Problem on passing an Array to a web service
by Dan_Dy
- 5 Replies
- Last post
by John Oliver (UK)MSP, VSIP
- Hi,
I¡¯m stuck in figuring out how to pass the array for KeyValueMap in the XML below for a prticular web service I am trying to invoke. ANY HELP WOULD BE MUCH APPRECIATED!
I¡¯m using Microsoft office 2003 and I¡¯ve downloaded and installed Microsoft Office 2003 Web Services Toolkit 2.01 into into my PC.
At the bottom of this message is the content of the WSDL which I
-
- Range
by Bortch
- 4 Replies
- Last post
by Bortch
- Hello,
I'm developing a macro to do some calculations on a worksheet, but I always get a problem when I pass a Range as an argument to my function. I need to pass the range as argument.
For example:
Sub Name()
Dim A As Range
Set A = Worksheets("Sheet1").Range("CD4")
MyFunction(A)
End Sub
Function MyFunction (ValueDoRange As Range)
etc...
End Fun
-
- Error 1004 - "Unable to set the PaperSize property of the PageSetup class" in Access 2003
by Payback
- 1 Replies
- Last post
by Rod Wing
- Good Day, I am experiencing a '1004' error "Unable to set the PaperSize property of the PageSetup class" when I attempt to set this property to "xlPaperLegal" on an Excel spreadsheet in Access 2003. I am using the following code to set this property; xlwks.PageSetup.PaperSize = xlPaperLegal The code used to define the xlks follows Dim xlwks As Object Set xlwkb = xlapp.W
-
- VBA macro prevents from closing file
by asophie
- 3 Replies
- Last post
by asophie
- I entered a VBA macro to update automatically pivot tables when clicking on a spreadsheet. I want this macro to run only in a very specific file "abc.xls". Here is the macro:
Sub Auto_Open() If ActiveSheet.Name = "Resource Allocations" Or ActiveSheet.Name = "Investment List" Or ActiveSheet.Name = "FTE Over-Under Alloc Report" Then Application.On
-
- calculate_worksheet event
by Jonas.S
- 2 Replies
- Last post
by Jonas.S
-
I have solved this in another way but if someone knows how to do it with calculate_worksheet event I would appreciate the knowledge!
Hi All,
How can I use calculate_worksheet event just for checking some certain cells on a sheet I want it to check E45:G45 which are updated from other cells. When the range E45:G45 change I want to run a macro.
Thankful for help
-
- Calling a function from a DLL
by Douglas Penna
- 6 Replies
- Last post
by Mezhick
- Hello there,
I wrote a DLL in C++, and I'm trying to use it in Excel. When calling the the function, I used the code, at the begginning of the module:
Option Explicit Public Declare Function preco _ Lib "OpcAmericanaDll.dll" _ (ByVal Spot As Double, ByVal strike As Double, ByVal Ks_fixados As Double, ByVal t_dos_strikes As Double, ByVal t_final As Double, ByVal t_inicial As
-
- Searching / Hilighting OCR text in Office Document and Imaging
by wajhi
- 14 Replies
- Last post
by Prathap
- Hi,
I have been given following Tasks using MS Document Imaging 11.0 API
Read TIF perform OCR on it
Show it in AxMODI.AxMiDocView
Searching / highlighting text in AxMODI.AxMiDocView using MODI.MiDocSearch class in TIFF file and Highlight search result i
-
- referenced memory error
by rham
- 0 Replies
- Last post
by rham
- a dialog box appears saying The insstruction at "0x269e7875" referenced memory at "0x269e7875". The memory could no be "read". Click OK to terminate program. Click cancel to debug the program.
-
- 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