Answer Questions

• Paul Hales download a file via internet and save it locally

  Hi, I would like to have a script that download a file (a word document) from internet (http/https) and save it on local PC. I've already found how to download a file: ************************************************************ Dim WinHttpReq Set WinHttpReq = CreateObject("WinHttp.WinHttpRequest.5.1") WinHttpReq.Open "GET", "http://", False ************************************************************ but then, I don't know how to save th ...Show All

• flamingwoodchuck VBA source code

  Hi all. I need to do my final year project in Excel using VBA. The project is in such a way that i can generate curves using Excel. I have been searching for the samples source code for cosine, sine and FFT source code, but to no avail. Could anyne please advise me on this I am a newbie to VBA, so i'm rather lost now.. Thanks in advance. Thanks Gnomie, It works.. :)) By the way, is it possible to draw the cosi ...Show All

• mikeparris Need help with Split function in VB 6.0

  Dim CMArray(),CMLine As String 'CMLine = "I,CM,S, ,90,1;I,CM,F, ,91,1" CMArray = Split(CMLine,";") This gives error Type missmatch. I want to split CMLine with above containts(which keeps changing in size) to be split using ";".   Please help. As Markus H said, you must declare CMArray() as string. The code is as follows ============== Dim CMLine As String Dim CMArray() As String ...Show All

• DavBrook Custom file description keywords: read/write in VBA via API

  In Windows Explorer, I can select a file, go to properties, and under 'summary', I can input keywords into the description, for use later when searching for the file. I would like to be able to read/write these file keywords via VBA. I assume I need to access the Windows API, but more than that, not sure what library etc. I would need to use. Can anyone advise me how do to this            & ...Show All

• josh55 Transfering data from a textbox in one file to a textbox in another file

  Hello, I need to be able to transfer text data from an ActiveX control (a textbox) in one file to an ActiveX control in another file. Currently, I can move the textbox data to the spreadsheet in VBA as follows: Range("k5").Value = TextBox1.Value and then I tie the TextBox LinkedCell property in the secondary file to the cell in the primary file: '[primaryfile.xls]'Worksheet1'!$K$5 I would like to be able to do this in one step ...Show All

• Saranya Changing Outlook email settings with VBE

  I would like to change the "Leave a copy of messages on the server " option in Outlook with Visual Basic Express. The Visual Basic Express code would change that setting for all or some of the email accounts. Ideally, it should be possible to do it on computers on a network. Does anyone know how this can be done Thanks, Antonio Hi Brenda, Thank you for your detailed reply. ...Show All

• Xcelsion Error after added a formule in cell with VBA

  HI all, I have a problem in a VBA project. I need to put in a cell a formle like "=RC[-2] - Janvier!AH8" (Janvier![AH8] must be dynamic with different sheet name and cell) Here the part of my code I used : absence = MthNamebefore & "!" & Cdecol & J rag2 = col & i & ":" & col & i Range(rag2).Select formul = "=RC[-2]-" & absence ...Show All

• Jerome.Robert assigning event handler subs to a dynamically created control?possible? how?

  Hi, I want to have some controls existing in any newly created workbooks/worksheets. So I create a combobox when it is necessary with OLEObjects.Add method. But then I want to catch events happening on this control so the Private Sub ComboBox1_Change() procedure should be created for it from a program. Is it possible Strange to me, that I cannot assign an event handler even through the user interface, while it is possible ...Show All

• Hugewally Collections of control - evaluating the name of a control that has been "pressed"

  Hi, I have created a form in Excel, upon which is a multipage control, with a set of combo boxes placed on. One combobox is populated by a pre-defined list of text, which upon user selection runs a macro that defines the population of a second combo box.......like a choice - sub-choice set up. The user is able to add and delete pages to their requirements, which also add and deletes the combo boxes on each page, however the user will always be p ...Show All

• A.M. Using user form to create list of files to be open

  Hello, Need your help on a problem I have - it's probably easy, but I don't have much experience with VBA yet and can't get around it. I'm trying to create more user friendly of excel report that uses three different text files as the source of data (file names and location changes - it depends on the user who's running the report). I wanted to use a form to allow users to choose the location of the files before they run the macro. So the who ...Show All

• Ajit Sheth Excel Unprotect WorkSheet problem in Excel 97

  Hi all, I have a problem when i open the Excel workbook from another Excel workbook to reset a value in a specific cell. Both workbooks are the same. When Workbook is opened manually, it will run the code in workbook_open, which is unprotect the workbook and worksheet to assign a value in a specific cell, it can be run properly in both Excel 97 and 2003. However, when i using workbook1 (running code) to open workbook2, workbook2 cannot unp ...Show All

• Michael K. Barnett 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

• Windows Latvian Langpack Date Problem

  I have a date field on an Access form and I do not want the user to be able to put in a date that occurs in "last week's reporting period" (explained below). Our reporting period goes from Monday to Sunday........so for example since tommorrow is Monday (the start of the new reporting period), I do not want the user to be able to put in a date for the prior 'Monday to Sunday' period. I wanted to see if there was a way to enforce ...Show All

• Anand_Vithal Word 2000 section page numbering bug? Any workaround?

  Hi, In a Word template macro I need to renumber page numbers of section 1 of the active document. Code is as follows:     With ActiveDocument.Sections(1).Headers(1).PageNumbers         .NumberStyle = wdPageNumberStyleLowercaseRoman         .HeadingLevelForChapter = 0         .IncludeChapterNumber = False    &nbs ...Show All

• ColleenR 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 But in this c ...Show All