Answer Questions

• ChandraP Add code in control image in time of execution

  (First of all they forgive me my English) Good, to all I am grateful for his help I have a routine that adds in a sheet a few Images control If he finds the word Graphis what I want is, that when the user of clic in an image executes Function ImageLoad does there exist any way of including this routine when the control is created or that, on having clicked in an image, obtains the name I have been trying ...Show All

• Qllie read-only OLEs ?

  Hello all ! I 'm database administrator and I 've a MSAccess db , which contains a tables with OLE objects (most of them are MSWord documents). I 've also some forms , that prevents they fields from changing (read-only forms). But when OLE object field is "executed" (Word document opens) , user can modify something. Then , when user closes form , he is getting an error with saving OLE object. Question: how to prevent OLE object from ...Show All

• getyourbone SaveAs question - Excel

  Hi, I have a piece code that does SaveAs at the end of the program but it always tells me that file already exists and do you want to replace it. I do not want that message to pop up and i want program to just overwrite it. I had in the code both application.displayalerts and screenupdating set to false but still does not work. I had the same code in another macro and it works fine. Any ideas why this does not work. I am exahausted trying to ...Show All

• Sanath4vcpp How can I determine if a character is number?

  Hello all, I am new to VBA. I am writing some macros which manupulate strings. Do you know any built-in function of VBA (Excel) which checks if a string or a character is number or character Do you know any web url which contains useful VBA functions like the onw that I am asking Thank you in advance, Kostas Use the Val(string) Function. Try MyNumber = Val(string) ' the string being your c ...Show All

• Dragan Jankovic minimize to system tray

  Dear All, How to minimize my access window to the system tray using VBA code Thank U 4 help. MS ISV Buddy Team I made a DB, When I open the DB, The Access Application Window becomes hide, just a form appears as stand alone window, and I made a button on that form, when click it, the application window minimize to the system tray, but when I click on the icon in system tray, the Application window and the form appear, I dont like th ...Show All

• Totenkopf Querying ActiveDirectory with VBA in Excel

  Hello folks, I want to run a macro when user open an Excel file, I want to ask user input for his/her account information (user/password) which stored in ActiveDirectory (Windows 2003 server). Is this doable with VBA in Excel 2003/2003 TIA, Brgrds. ...Show All

• callvishnu SQL Server 2005 Resourse Kit exception

  Hi, When i try to view any of the webcasts by clicking "play", i get the following Visual Studio just in time debugger error: An unhandled win32 exception occured in iexplore.exe[4624]. I can also see the following error in the winnt application error log. I am running winxp with sp2. Event Type: Error Event Source: Application Hang Event Category: (101) Event ID: 1002 Date:  25/08/2005 Time:  7:08:50 ...Show All

• shadow-k8 Read data from excel through VB.NET

  Hi friends, I need to read symbols(like ALPHA,BETA,MEU) from excel and show it in a data grid through VB.NET.Later insert it into Oracle 8i DB. I am able to read entire data but i am getting 'a' instead of ALPHA symbol and 'b' instead of BETA symbol. I am querying excel via OLEDB provider.The following snippet is using for accessing excel. Dim MyCommand As System.Data.OleDb.OleDbDataAdapter Dim MyConnection As System.Data.OleDb.OleDbConnection ...Show All

• Houari Runtime error '13' - type mismatch problem! Again...

  Hey all Thanks to the help of the forums here i thought i had most of my code working however, this infamous 'runtime error 13' keeps cropping its head up on only 2 of my 10 sub routines! :( Ive spent most of my work day searching through forums and google but i am no closer to finding a solution. The 2 functions that it is affecting are important and i need to get them sorted else i may as well scrap my two days work! Ive posted the co ...Show All

• abdm Passing commands to unix from VBA EXCEL

  Can any one tell me how can i pass commands to unix from the VBA EXCEL programming Thanks in advance --KK Per one of our support engineers: Yes, it’s doable. Basically, we have following ways: Telnet ================== 1.        I suppose most of the UNIX system supports Telnet protocol. We have to leverage WinSock API to build a telnet client. Here’re ...Show All

• PaulPT custom toolbar error

  I built a custom tool bar for my applicatoin. It works ok on PC Excel. But I got an error message on a Mac Excel: Run-time error '-2147483640(-7FFFFFF8)': Method 'FaceId' of object 'CommandBarButton' failed If I comment out the        .FaceId = 642 Then the error message becomes Method 'OnAction' of object 'CommandBarButton' failed The original code in VBA look like this: ..............    Private Sub Cr ...Show All

• adi fm20.dll

  The thing is that I need to redistribute fm20.dll with my program which uses it my VisualBasic project. But since this dll ain't redistributable I'm in a little confusion. It is senseless to ask people that will use my program to have MicrosoftOffice installed... Then I read about Microsoft ActiveX Control Pad and thought that my problem was solved....but unfortunatly I couldn't find it using 'Search Microsoft.com'...So as I already said I'm in ...Show All

• ElroyJ VS Code Editor

  Hi, I've seen numerous examples people implementing the Windows Forms Designer in their application, I was wondering if it's possible to do something similar with the Code editor too   I would like to offer my users the capability of writing their own plug-ins.  It is ok if VS has to be installed on their PCs. I've asked this question many times before, and just had a lot of deer in headlights faces stare back at me. Cheers. Paul ...Show All

• Steve-0 pasting in excel

  I get this error when i paste into excel after typing in some text and selecting some cells to copy and right click to paste in. any ideas System.Runtime.InteropServices.COMException (0x800A03EC): Paste method of Worksheet class failed at Microsoft.VisualBasic.CompilerServices.LateBinding.InternalLateCall(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack, Boolean IgnoreReturn) ...Show All

• Whatisid Calling procedure upon deactivate

  I am using the following code which gives me a run time error 1004 "Select Method of Range class failed" when the yellow line is executed from the worksheet_deactivate procedure. However, the code runs fine when executed directly from the Save button. This code is located in the Item Entry worksheet module. Can someone explain why and how to get this code to execute. I am guessing it has to do with the worksheet being deactivated. However, by de ...Show All