Answer Questions

• Derek Smyth LAN vs WAN

  Hi, We are using EAServer with JSPs in our application.The problem is that one of the procedures (database procedure) used in the application returns more than 2300 rows and at the backend i.e in the query analyzer its execution time is about 40 secs but while running the application in LAN environment it takes 10 mins or so But in the WAN environment the Internet Explorer gives a timeout error after 3 mins. ...Show All

• reya276 VBA code to search and modify in Word

  I am very new to VBA for word. Please excuse. I am trying to search for text that meets a the following criteria. The "#" reps any number, "T" reps any Letter. "TRACKING NUMBER: #TTT############## " The idea is to find all "tracking number"'s that meeds the text and number "format". I then need to modify the number by modifying the letters and adding two numbers. The result is below. All track numbers need to be modified. "TRACKING NUMBER: #TTT##############-## " You help with this is greatly appreciated. Rob The search is more of a format search. ex. ###AAAA#########. These represent wild cards for text and ...Show All

• Ljhopkins Contacts who Customize MapPoint

  Over the last year I have developed a few VB.Net applications that customize the use of MapPoint 2004. I see a lot of value that these sorts of projects can bring to Logistics Planning and Operations. I'm based in Vancouver Canada and I'm wondering if there are other people or businesses that are currently promoting MapPoint as a customized solution. I would be happy to share the work that I have already done and discuss my ideas for the future. Thanks, Carlo Hi Carlo, I have a question for you, i'm trying to write an app for my dads delivery company which has 15 vehicles and delivers around 150 packages everyday, I think the best way to do this would be to devide UK into sectors(territories ...Show All

• mklaey Live Communications Server Kerberos implementation

  Hi, I am interested in writing a simple java client that can talk to my Microsoft Live Communications Server. I am running into some problems with Kerberos authentication. I can get past the initial authentication by getting a session ticket via Java's GSS-API implementation. However, from analyzing packets Windows Messenger sends to the LCS server I see that after the initial authentication, every message must have a "Proxy Authorization:" header that includes a "response:" parameter that I am assuming must be calculated based on the preveious "Authentication-Info" header parameters such as "rspauth:" "srand:" etc. I was wondering if you could give me info on how to calculate the value fo ...Show All

• Knoxford How to copy pivot table RESULT from Access to Excel

  I need to produce a highly formated pivot table report in Access and can only achieve so much. However, if I could programatically select the pivot table (equivalent of keys [Ctrl]+ ) then copy and paste into Excel, I can use VBA to format the report in Excel. My problem is that I cannot find a way to programatically select the pivot table in Access. I have tried Sendkeys "^A" as a last resort but this doesn't work. Exporting to Excel doesn't work either as it exports the pivot table, not the result . Hi Rick, Have you had any luck resolving this problem I am also trying to copy the results from a pivot table control and paste the results into Excel. KD ...Show All

• Northern Rob Error with Excel Application Object

  Hello ladies and gentlmen, this is a very specific error I'm dealing with, and one of the stranger ones I've run across. First of all, I am attempting to open an excel file from MS Access using an Excel Application Object. If Excel is not open, the file will open fine. If Excel is open and there is no workbook open, the file will open fine. If Excel is open and there is a workbook open, then the file will not open. Here is the code I'm using. Set appExcel = GetObject(strFilePath & strFolder & "\" & strFileName) appExcel.Application.Visible = True If blnIsWorkbookOpen(strFileName) = True Then appExcel.Application.Workbooks.Open strFilePath & strFolder & "\" & strFileName ...Show All

• john zhang WER Code Signing Requirement

  Hello, Recently I discovered that the Microsoft Windows Error Reporting program is open to all developers free of charge if two requirements (more or less were met). The first requirement was that upon signing up for the program, the candidate company must send a unique Verisign certificate that represent's their organization's identity (about $100). The second requirement was that the application to be submitted to Microsoft for WER must also have a Microsoft Authenticode signature also provided by Verisign (for about $400). My only question that I have is whether I could go with some other signing authority who participates in the Authenticode code signing program (Thawte for instance), and still participate in the Windows Error ...Show All

• jcarlos.net Powerpoint 2007 textframe.autosize

  Hi, I am have a VBA script to generate a powerpoint slideshow from data in a SQL Server. It works perfectly on office 2000 and 2003 but not with office 2007. After some debugging it appears to me that the offending line is when i set the textframe.autosize property. After looking through the msdn library I noticed that there is no Powerpoint reference manual under 2007 office suites. Can anyone point in in the right direction on this one Thanks Yep... I'm having the same problem. I have now ommitted the autosize line for Powerpoint 2007. I am experiencing a similar issue with our software application which uses OLE/COM to export ...Show All

• GetCode sending emails from MS Word with variable subject line

  Hi, I've searched these forums but have not been able to find exactly what I need. I know how to send emails with VBA in Word, but the only problem I have is that as far as i'm aware the subject line is always fixed in the code (    .Subject = "New subject"   ) What i'm trying to do, is send reports i have reviewed to an email address by clicking a button in the toolbar. The email address is always the same but the subject line shows the customer's name and his account number (so that's different all the time) Is there any way I can get the VBA code to copy the first line of the report (which has the customer's account number and name) and use that in the subject ...Show All

• carlp22 using dll file

  I have created a dll file using VB.net. And I want to use the function of the dll file in VBA. How can I do it Thank you Hi, Try installing your DLL to the GAC, the runtime will find it there. Its very difficult to help you here as I don't know what files you've copied where and/or whether the machines have the correct frameworks installed. The reason this isn't working is maybe due to the runtime enviroments. It's just really tricky helping you out on a forum here. P.S. it might be worthwhile creating an managed addin for the office application using VSTO. Hi All, I have a question. what is the cause of the error " File or assembly name, or one of its dependencies, was not found ...Show All

• Dana Lutz Programming Adobe Acrobat Reader 7.0

  I have succesfully programmed Adobe Acrobat Standard 7.0, see code snippet below:- Dim objAcroApp as AcroApp Set objAcroApp=CreateObject("AcroExch.App") ' Starts up Adobe Acrobat Standard 7.0 Dim objAcroDoc as AcroAVDoc Set objAcroDoc=CreateObject("AcroExch.AVDoc") ' Create an object to allow a file to be opened However, when it comes to using the ActiveX Adobe 7.0 Type library with Reader 7.0 it seems it can't be done - DDE technology is the only answer. Has anyone out there got prior experience as I seemed to have strayed into a bit of a minefield ! Somewhere where I can look at code samples would be a great help. Thanks you Robert Snedden, Edinburgh Hi, How ca ...Show All

• Todd Saylor how do i exclude certain directories from a recursive file count/size macro?

  I have a macro that goes through a list of folders and gets me a count/size from them, currently it is using a recursive file count/search method... but i am not sure how to exclude certain folders/files, the folders and files that i want to exclude will always be under the same name... i am trying to exclude these folders: /Bin, /Logs and the file production.xml. Data_Size is the name of the function i am using. Here is the code i am currently using: Thanks in advance for your help Function ShowSubFolders(Folder) As Long Dim whateVer As Long whateVer = 0     For Each Subfolder In Folder.SubFolders         whateVer = whateVer + fnFilecount(Subfolder.Path)    &n ...Show All

• ckrepps Access - Microsoft Forms V2.0 Spin Button bug?

  Hi, I've written some code to select 2 fonts in an access form. I also have a link button which, when pressed, will link the secondary font to the first, but will allow the user to select the font size independantly of the first. I.e. the primary font could be Windings size 12, the secondary could be Times New Roman size 16. When the link button is pressed, the sencondary font would become Windings (along with any additional formatting), but the user would be able to set the font size independently through a textbox/forms v2.0 spinbutton combination. The font size spinbutton/textbox combo is enabled or disabled, depending on whether the link button is pressed (a toggle button). I also have a hidden label that stores the secondary ...Show All

• Bill Martin Running a macro at a certain time

  I would like to have a macro that automatically runs once every day at a certain time. Is this possible and does Excel and the spreadsheet need to be open in order for the macro to execute Any help is appreciated! Ok thanks alot!! Last question I hope, do you have to be logged in to Windows in order for this to work The computer is on at all times but at night when I had planned to let the macro execute no one is logged on to the computer. Would be very grateful for your help! Thank you very much for your answers!! I would use the windows scheduler to open the Excel Spreadsheet at the designated intervals and have an auto-run macro setup so that every time the sheet i ...Show All

• Jeanet Using FindWindow API to Get Focus and Send keys to a window

  I have put together some code in VBA to naviate to a webpage in IE, wait for it to load, find a hyptertext link on the page named "spreadsheet", click it, wait for the "download file" window to load and the go through the process of saving the file into a specific directory using send keys. The problem is, I am constantly losing focus on the windows. My code actually repeats itself 21 times for different webpages I am downloading this spreadsheet from. I need help finding the windows that I need to send keys to. Below is a sample piece of the code to navigate to one webpage: I have put notes to reflect where I am having issues. They are throughout this code and in red Function import_atl_aspec() '(Button As In ...Show All