Answer Questions

• bilescu2 VB & VBA - page setup options completely disappear after merging a document

  Hello, I created a VB application which uses Word to merge documents. I used Microsoft office 97 to create these Merge Documents. With These merge documents, I was able to save the setting such as font and how it should print using tray 2 & tray 3. We have upgraded our Microsoft office to 2000. This is where the problem begins...now every time we use the VB application to do the merge---everything seems to work just fine until we ...Show All

• vmishka Excel, Forms, and Charts

  I am pretty much a beginner when it comes to VB. I need help with a project I am working on that has me ready to rip my hair out. Here is the what I need to do: When I open a workbook (excel) I want it to display a form where I can enter in the date and various data. I need that form to add that data that I entered to the worksheet in the coloumn that corrisponds with that particular information. It also needs to copy that row's for ...Show All

• LSanders Send Outlook message via VBA Macro in Excel

  I have some macro code in an Excel workbook. It has been working fine for several years under various combinations of Excel 97, Excel 2000, Excel 2002(XP) and Excel 2003 along with Outlook 97, Outlook 2000, Outlook 2002(XP) and Outlook 2003. We have one new computer that has Office 2003 (SP2) that was recently setup and the macro generates the following error: Run-time error '-2147024770(8007007e)': Automation error The specified ...Show All

• Mark Hollman Working with Outlook Public Folders from Excel

  Can anyone point me in the direction of some example code Instead of sending an e-mail which has a large attachment to a distribution group, I want to post it to an existing Outlook folder. The code will be placed inside an excel workbook, which creates the attachment file. Thanks in advance Hi Brenda Not sure that I made my self clear. I have a Spreadsheet, say Book1.xls, which I create with VBA from Ac ...Show All

• Tom U Authentication schemes in LCS ?

  Wanted to know how it is possible to register with LCS from a SIP client which doesn't support NTLS or Kerbaros authentication schemes Can HTTP Digest Authentication be forced to be used if Authorization header is added in advance in the initial SIP REGISTER request Is LCS interopearble with 3GPP IMS SIP clients Thanks in advance !!! Hi Deepak, Here's some info from the LCS team: ·  &nb ...Show All

• Gema Need Phone Number for Empower Program Included Support

  When I signed up for the Empower ISV program, I was told that I would get the following... * One MSDN(r) Universal Subscription with up to five (5) user licenses for development and testing. * Comprehensive access to the Microsoft software you need to build and fully test applications and XML Web services. * Continuous access to new product releases and public betas. * 10 Free Advisory Service Hours per year * Up to five (5) internal use softw ...Show All

• pmquan Client to SSAS

  I would like to know How I can use OWC11 with ASP.NET 2.0 because the past version we only put the control en ASP.NET page and working, How I can do that with a new version Thanks for your help Flavio are you know how I can use OWC11 with ASP.NET 2.0 because when I try select a control this are disable it's possible use similar last version of Visual Studio 2003 when I try to use OWC11 in ASP.NET. the control is disable ...Show All

• Fola Enterprise Service Platform copying links from specific cells in a worksheet to specific cells in another worksheet

  Would greatly appreciate any help with the following code - am having difficulty assigning the first inputbox range to a variable and making the code work. I have labelled the lines with the problems. thanks. Sub CopyPasteLink() 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 T ...Show All

• TWS cannot save file as

  I can't save any files on any of my other drives. The message comes up as save file not responding. Also szAppname:WINWORDEXE, szAppver:11.06568.0, szModname:hungapp. Why can't you ever get help from microsoft without a fee After all this is their product. This issue seems to be the hot topic over on the Windows Server and IE6 newsgroups. Here's some info that I found on the issue and a few possible solutions: ...Show All

• orchidea Problem about the "Find" function in VBA editor

  Hi all~ When I use "Ctrl F" or choose "Find" in VBA editor, the "Find" pop-up window close and do nothing after I press the "Find Next" button Can anyone help me I use MS Office 2003 and the VBA editor version is 6.3 Thanks! Please~Please help me!!!!! Per the support engineer: Would you please ask out ISV to check the ...Show All

• Aurélien Passing arrays as parameters in VBA Excel

  Hello. This is my first post here. I have googled and rtfm'd the following to death to no avail. Excel VBA under WinXP Pro Problem: I have an array of variants declared thus - Dim avarMyArrray() as variant I have a subroutine into which I want to pass the array. I have attempted the suroutine call thus - Call myRoutine(avarMyArray()) Call myRoutine(avarMyArray) I have attempted to receive the call thus - Sub myR ...Show All

• Leandro Gregory Convert UTC date to mm/dd/yyyy hh-mm-ss

  I have a database which contacts call_times in a 10 digit format (ie: 1003645998) which represents the number of seconds since 1970.  I need something in Access that will convert this for me when I run a query. Really hope there is someone out there that can assist!! Shawn. Hi Shawn, Our support engineer came up with the following for you, but the screen shots aren't coming up. I've done my best to provide ...Show All

• Erich H. Franke Named range in another open workbook

  Can I refer to a global named range in another open workbook from a worksheet module within the active workbook   I have not been able to figure out how to do this. Thanks, that works. Joe D First create a workbook called "farbook.xls" and define a named range called "farname" and in the farname cell enter a value and save and close. Then ente ...Show All

• Chackowsky PPT VBA - Automatic undo

  Is there a way in vba for powerpoint to code an automatic undo. I have a form that is used to create a powerpoint. I have an exit and what i want is on the exit button click (the use the exit button to close without saving) every change done to the presention will be undown automaitcally on the exit click event. How do I do that Thank You. Per our support engineer: Base on my understanding, our b ...Show All

• blaydes99 VBA for Outlook: How to create a Hyperlink via Macro

  Hi everyone! I am trying to use VBA in MS Outlook to create a Hyperlink via a Macro. Can somebody please help me Please, please, please... Here is what I'm trying to do: The situation is, that I often get emails saying sth like: "Your file is at h:\file collection\marc" Normally I would then mark the path, copy it and paste it into the windows explorer. This works fine but I was thinking about how i can spead this process up with a mac ...Show All