Search results for query: *

I need to simulate the mouse over a window of another application. I mean to trigger Mouse Move event... When I manually move the mouse over that specific window another window appears. I can determine the handle of that specific window, I know its X and Y, Top and Bottom positions and I can set...

I use an Excel 2007 addin (xlam) and in order to change some control labels, tips, images its XML code contains an 'onLoad' procedure named "Initializare": Public rIBB As IRibbonUI Sub Initializare(Ribbon As IRibbonUI) Set rIBB = Ribbon End Sub Most of time it works well except some...

The next script finds the open session of Excel and call procedure 'MyProc'. It works without passing an argument. I mean the procedure is called if I do not add ', x'. When I tray to pass the argument it looks that it is a sintax probmem in the code... x = "q" Set ExcelDeschis =...

I have an Excel VBA application which sometimes needs to catch the event of removable drives adding (inserting in USB). I found in MSDN a monitoring WMI script sample able to trigger the adding or removing event: strComputer = "." Set objWMIService = GetObject("winmgmts:" _ &...

I have an addin needing to set the drive where the back-up to be done. It should be an external media (HD or memory stick). I know how to identify/check if it is external media and I have the next function in order to Browse for a folder: Function GetDrive() As Variant Dim fldr As...

I made an Excel addin which has been distributed to a lot of people in the company. It handles data and all creations and modifications are logged in a text file named with dll extension saved in System32 folder. The log data are returned copying the dll content in a text file in temp folder and...

I use two User Forms in Excel and I pass some information from textBoxes of Form1 in textBoxes of Form2. I can select a specific item in a listbox (using ListIndex) but I need to call the listBox_DblClick event. I tried the code: Frms!Form2.ListBox1_DblClick but without success (I made the...

I installed an Excel 2007 add-in which makes a new Tab in Ribbon and a custom popup menu in Quick Access Toolbar. With Excel opened I can open/install or close/uninstall the add-in without problem. When I open VBE, even if I do not make any modification, Excel (application) close/exit without...

I use Vlookup function to bring some values from another Excel sheet. Lookup_value means numbers, but formated like text (Data -->Text to Columns-->Text) in both sheets. What is strange is the fact that I receive 87 values for such codes but not for two of them. Both formated in the same...

Is there a way (code) to monitor the video card temperature. There are tools just showing the temperature but without recording it. I have a problem wiht my video card which crashes above a specific temperature (I think...). Thanks in advance

I have a text box keeping the IP of the visitor. I obtain IP in a text box ('ipaddr') of a form named 'myform' using the next script: var ip = '<!--#echo var="REMOTE_ADDR"-->' function ipval() { document.myform.ipaddr.value='Your IP: '+ip; } I would like to detect if the file is opened from...

Is it possible to run a vbscript like a service without using Srvany.exe? I mean I can create the service but when I try to start it I receive an error message (8). I can see the created service but when I manually try to start it "Error 193: 0xc1" appears... (is not a valid Win32...

I mean I need to make a log about the deleted files/subfolders and new ones which appear inside the surveyed one. The time of deletion or creation must be also logged (even if it is not exactly the real one in case of deletion...) I know only to issue an initial log file containing all...

If I wont to do something after a specific time of computer inactivity how can I determin this time ? Thanks in advaance, Fane Duru'

1. I use: "=MATCH(1E+306,A:A)" in order to find the last value in a A:A column. 2. I use: "=MATCH("*",A:A,-1)" in order to find the last text value in A:A column. Is it a way (formula) able to find the next empty cell in a column? I need an Excel formula. With VBA it is easy but I need that...

How can I read a value (ex. exchange rate) from a web site and return it on an Excel cell? That have to be done even if the value is in a table, in a textBox or brought at the opening of the page from a database.... It is convenient for me a solution in VB, too. Reading the HTML source...

I have Visual Studio installed on may computer so I'm able to use Winsock control on a form in VBA Excel. For making the file work on computers which does not have Visual Basic installed I bynari memorized MSWINSOCK.OCX on a sheet of Excel and I am able to rebuild the file in the System...

How is it possible to copy and paste an embedded object from an Excel worksheet (a picture). With the code: &quot;Sheets(1).Shapes(&quot;Pict&quot;).Copy&quot; the embedded object is loaded in the Clipboard Memory. If I wont to Paste it manually I can. There has to be some API able to...

Is there an API or something else being able to give me a list with the users logged on to a speciffic domain in a Local Area Network ? Thanks ! Fane Duru'

How can I paste an object from Clipboard ? I suppose using some API calls... Does anybody know how to do that ? Thanks