Answer Questions

• Andy2006 show vba application

  Hi! Guys.. i am using Excel 2003 with VBA 6.3 and i need when user click in excel file at windows explorer, show my VBA userform and not show excel application, like a executable. Anyone know how Thanks very much!! Joao Carlos Hi Derek Your code resolve immediately my problem. Thanks. Think what your needing to do is place events in the Workbook.Open ev ...Show All

• Michpre Excel macro to send email not running

  We have an excel macro that finishes with sending the file as an email. This is working on most people's PCs, but one of our users has Excel just hangs up during this process. We tried uninstalling any office programs, making sure the program files folder was empty and reinstalling the programs. We use Excel 2002 and Outlook 2003. This has worked in the past. I tried logging into my user's PC as myself and ran into the same issue. So ...Show All

• Clay B Buddy hasn't contacted me yet...

  A few weeks (months) ago, I signed up for the Buddy program (great idea!). I got an e-mail stating that there were some matches several weeks after that. I picked a buddy from the list and got that confirmed. However, since then, I have not heard anything at all from my Buddy, who was (if I understand it well) supposed to contact me first. SA. Hello, Please send your name and email address to budsup@microsoft. ...Show All

• Trenor WIA: problem shooting picture

  Hi together! The device is recognized. The digicam shoots a picture and saves it on the the memory card. But the returned WIA.item is always 'nothing'. Is anything wrong in the following code Thanks a lot for your help in advance! Armin --- Public Function shootPicture() Dim dev As WIA.Device Dim CommonDialog1 As WIA.CommonDialog Set CommonDialog1 = New CommonDialog Set dev = CommonDialog1.ShowS ...Show All

• Rigeto Open an excel file

  Hope you will help a beginner .. Here's what I want to do:  In a VBA subroutine, try to open an excel file with a particular name say, P01GAB.xls.  It may not be in the diretory, if not, wait for 10 seconds and try again.  If so, open it and go on to the next thing.  (Eventually, it will be in the directory...)  So, I take it, I need some sort of error trap on the Workbooks.Open command... Thanks much.   ...Show All

• Gary Eldridge Deployement project build ERROR - URGENT!

  Hello Everyone, I wrote a little program in C# to read and write from a ms access database and I wanted to create a deployment project. I followed the wizard and included Documentation, Source, Debug, and primary files to the Setup project. also under detected dependencies I added the Microsoft .NET framework and System.Data.SqlClient.dll. BUT when i try to build it it gives me this warning: Warning 1 Unable to find dependency 'SYSTEM' (Si ...Show All

• ankur mitra Intersection IM and Telephone

  Hello, I have one question concerning the LCS 2005 and MOC 2005. There are 2 persons, person A and person B having the Microsoft Office Communicator. If the person A has launched the Communicator (Person A is on line), and if the person B has not launched it (Person B is deconnected), can the person A see by Communicator if the person B is on the phone or not. In another words, if the person B has not launched the&n ...Show All

• David Priddle xp style to vba forms

  hi, i would like to apply the xp theme to my msforms in (excel) vba.  i have not been able to find any information on doing this.  i saw this done in a stand alone xla so i know it works.  any help would be greatly appreciated. -b Hi, Here's the engineer's response: I understand that it is Windows XP / Office 2003. How do you reproduce the problem I tested on my Windows XP / Office 2003: ...Show All

• AliTavakol Excel Macro - saveas command with current date?

  I'm new to VB and am trying to code up a macro for excel. What I am hoping to do is to save a file in two locations. The getting them to save isn't a problem. However, what I would like to do is have one of the saves to have the current date at the end... ActiveWorkbook.SaveAs Filename:= _ "C:\Documents and Settings\ca5ms\Desktop\BAS05980.P.EFT.EOIIN.UNUMLIF.xls", _ FileFormat:=xlNormal, Password:="", WriteResPassw ...Show All

• Kevin Feasey Run-time error 13, "Type Mismatch" in Excel application

  Hi, The following macro functions correctly in an Excel 2003 workbook. However, when I create a copy of the workbook, the macro generates a run-time error 13, "Type Mismatch" when it is run from the copied workbook. Sub print_schedule() ' ' print_schedule Macro ' Application.ScreenUpdating = False Application.DisplayAlerts = False Sheets("Schedule 1").Select ActiveWorkbook.Names.Add Name:= _ "'Schedule 1' ...Show All

• Brett Shearer Application in the Task Bar

  Does any one explain why the application is not shown in the task bar if the form is shown modally. Is there a better way of handling the code without showing the form modally Hi Shasur, What program/versions are you using Can you provide more details or repro steps on this issue thanks, -brenda (ISV Buddy Team) Here is the VB 6.0 code ...        Screen.MousePointer = vbNormal      ...Show All

• Grendizer Can anyone download VS Team Edition?

  We are a Certified Partner with the ISV Competency. The ISV Competency gives us a license for Visual Studio 2005 Team Edition for Developers but, we can't download that or the Team Server from MSDN. We can download the evaluation editions but not the real thing. Is this a problem for all partners with the ISV Competency or just us Can anyone download the real editions of Team Foundation server and/or VS for Developers Thanks, John Vot ...Show All

• gmone Outlook - Looking up email configuration settings

  Hi, I would like, if possible, to query the email setup settings within outlook 2003 and later. More specifically, I'm actually interested in querying the users email settings to see if they are connecting to Exchange Server and if so, extract the Exchange Server address. Any comments will be very welcome.   Many thanks, Mike Coxeter Hi Mike, Here's some info from our supp ...Show All

• Cher Reading data dll into excel

  I have recompiled a Visual Foxpro table into a DLL using VFP9. It is registered and VFP reads the DLL correctly. The DLL is just a table with code that performs a lookup based on two values and returns a value for use. In Excel, the following code is in a module: Declare Function spec_Field_Value_Function Lib "spec_search" (cThisSize As String, cThisValue As String) Public Function spec(Shape As String, Property As String) As Variant ...Show All

• Mablao Removing Hyperlinks

  Hi I have inherited an excel database with various links somewhere that i cant find. Everytime I open the file it will ask me for the file.Obviously its linked somewhere within the spreadsheet. When I get into the spreadsheet I tried to search for the links but could not find it. Question. Is there a way to show up all the hyperlinks and remove it from the file Thanks Try looking at the list ...Show All