Answer Questions

• Flopik inputbox method and ranges

  I am having trouble assigning the range given by an inputbox method to the variable targetcells, and subsequently selecting targetcells. any help would be most appreciated. Dim i As Integer Dim CopyCells As Range 'the cells into which links will be copied Dim TargetCells As Range 'the cells that copycells will be linked to Dim CopyAddress As Variant 'the address of the copycells Dim TargetAddress As Variant 'the address of the targetaddress ...Show All

• Chard-Fi Error VB6 when I run application in w2k3 Domain Controller

  HI, I have an application implement in VB6 and when I run in W2k3 Domain Controller give error 713 time execution. please, help me. Any suggestions are very much appreciated. I have the same problem but on WinXP pro. the exact message is: Run time error '713'. Class not registered. Looking for object with CLSID: {00000010-0000-0010-8000-00AA006D2EA4} What do I have to do to solve it ...Show All

• Dar_Sea VBA in Office 12

  Could anyone show some information about VBA in Office 12 Does Microsoft support VBA in Office 12 Are there have any new features or improvements Thank you in advance!   An observation: MS is still supporting XLM in Excel 2003 and reportedly in 2007. I feel reasonably confident that VBA will continue to work for several new releases of Office. This despite the push towards managed code/.net/VSTO. While Microsoft no longe ...Show All

• Peter Barnet plz help to print label for the critical conditions

   plz give  me some codes to print this label.. my table : workorder     Quantity in serialNo     StartingSerialno 101                       20                              1 102                       30    ...Show All

• C4702 read only file opening

  Namrata Prashar wrote: Hi Josh, thanks for the mail. i guess i was not very clear with my description of what i want or alternatevely what i am trying to do with the application. well, let me try again, so that you can help me .... i have an excel application called PDD_NP which is supposed to ask for a directory where it wants the apllication to run. PDD_NP then reads the directories and sub-directories and finds all the ...Show All

• VBgirl Application Error

  Hi experts, We have an application written in VBA. The application is failing with the following log entry in the event log. Faulting application: appname.exe Faulting Module: VBE6 Version: 6.4.99.72 Fault Address 0x000dc6f2 Event ID: 1000 The application is running on Windows XP SP2 with Office 2003 SP2. Help would be much appreciated. Thanks Steve Hi, The following is the code that was causing the a ...Show All

• THERAOT LCS

  My large company is looking at chatting applications, but isn't considering LCS.  Does anyone know if the LCS client is compatible with outside users on windows messanger.  I've used it once in, but i'm not sure if that was not available or just not in use.  I would really rather use LCS, but I think it will be a deal breaker if it won't allow others outside the domain to chat to users in the domain. ...Show All

• Karamasov Calendar control issue in excel

  I wrote a customized spreadsheet in excel 2002 which uses the calendar control. When I used the spreadsheet on another computer I got an error saying that an object was not available. The error occurs where the calendar control should have been displayed. Since I want to use this spread sheet on many computers in the office how can I get the calendar control to work on any of the computers. Thanks Hi Carl, Here ...Show All

• daWiki Copying selected Worksheets to new workbook

  Hi, all. How do I copy only 3 worksheets from a book with 9 to a new workbook . I do not know the name/path of the new workbook because the user will save it where he wants. Please help!, I have tried many things, but it creates a workbook for every worksheet or it happens other weird things. Thanks. Jorge. Hi Jorge, Here's some info from our support engineer: Let’s talk about following Exce ...Show All

• sushi1584 VBA for Powerpoint

  Hi, I have been asked to modify a powerpoint presentation so that from a series of jpg files, one appears on the screen and then after a specific time period disappears and is replaced by another; this being a continuous loop on one slide only - like a photo tour. I have the following code, but need to get it up and running. Any suggestions: Sub ImportABunch() Dim strTemp As String Dim strFileSpec As String Dim oSld As Slide Dim oPic As S ...Show All

• JonneeZ Automatic BCC from Outlook (VBA)

  Hello, I am trying to create a subroutine in outlook to send an automatic BCC to a certain 'mail recipient (a@b.c)' if the subject contains 'xyz'. I have managed to create a subroutine which applys to EVERY mail i send. I want to set it for certain 'subjects' rather if subject contains 'xyz. What do i have to add Please help or guide me to resources. I need to know a subject field which i could compare strings with, i guess. -------------------- ...Show All

• John Morales Outlook tasks - how can I see them?

  Hi everyone, I was wondering if there was an easy way to connect to MS Outlook and get a list of the users tasks... Any sample code would be greatly appreciated. I think I need to add a reference to Outlook 11 object library... or is there a totally different solution to this. Any help is appreciated. Thanks. Hi Brenda. Thanks for the post, I tried it and it gave me an error saying the Outlo ...Show All

• c.v. Trying to get VB to update charts in Excel

  I am trying to write a macro that will update charts automaticly when I enter new information into a cell in Excel. For example: If I have information in cell A1 and that displays as the first data point on my chart Then I add some new information into cell A2 I need the chart to update so that it shows the data points for both A1 and A2. Right now I have to go to each chart, each line and update the row number manually. This ...Show All

• farscape-dev Visual Studio vs SharePoint/Front Page

  What is the 'connection' between these two seemingly unrelated development tools I have been reading some evangelical blogs on the sharepoint v3 site, and it seems as though Sharepoint v3 will offer a lot of "infrastructure" (security, web parts, asp.net) for business-oriented / collaboration / scheduling web sites that may require a lot more effort using Visual studio. From the look of things, it's apparent to me that Microsoft is be ...Show All

• BubbleGirl24 VBA Form in MS Word template to populate fields

  I have a template which contains 9 different fields currently setup as merge fields which is currently being manually populate and I am trying to write a simple User Form which can allow the user to enter all 9 different fields, and then upon the press of the submit button, it populates the fields. I was able to at least design a form with 9 textboxes and a submit button along with appropriate labels, but what I cannot seem to figure out is how ...Show All