Answer Questions

• Zokkan Protecting formulas in cells

  Hello, Other than coding formulas, is there a way to protect a cell in an excel spreadsheet, no mater, if the sheet is protected or not, so that formulas can not be erased or overwritten Thanks Chrstdvd Is there a particular reason why you can not protect the sheet Hi, Not that I know of without protecting the sheet. What does 'coding formulas' actually mean Well Andy, I mean that I have a macro that has code like this Range("H22") = "=Sum("A5:A16")". I had the idea to just make a macro that repopulates the cells with the formulas prior to the Save command. That would at least have the formulas ready for the next days work. I will not go into why ...Show All

• winterxu416 Urgent HELP!!!!! VB in MS Excel

  I have a data file in Excel which contains a lot of information for different hospitals. I want to create separate Excel files which contains the information specific to one hospital - I don't want hospitals to see data from other hospitals. Ideally I would like one click that will generate the reports for me I am not sure how to go about this. I have some VB code but for business objects and it doesn't work in excel. Please help!!!! The problem is with recording a macro is that every month the data for each hospital changes. Example: For Jan Hospital X would have two lines of data but then for Feb same Hospital X would have five lines of data. Example Data: Hospital ...Show All

• Christian Hecht Windows 2003 Checked build problems

  Greetings, I'm trying to install a checked build of Windows 2003 Server with SP1 from our MSDN CD dated Nov 2005. When I run Windows Update in an attempt to update the platform, IE crashes. If I try to download service packs for IE, the installer complains that it won't install an unchecked build. 1. Where can I obtain the latest checked cumulative updates for IE 2. What's the best way to update a checked build of Win2003 SP1 Any other advice on managing a checked build is appreciated. Regards, Terry i am having the same problem with a windows xp checked build. were you able to resolve these problems independently regards. ...Show All

• Michael Per A vector of vectors

  Hi... I need to create a vector of vectors (or a vectors container) using VBA for Excel. How can i do this Thanks.. Thanks for your answer, it was so helpfull. What i finally did is: 1) Create a new user data type Private Const NUMERO_DE_MUNICIPIOS = 12, NUMERO_ESPECIES = 9 Type ContenedorEmisiones Vector(1 To NUMERO_ESPECIES) As Double End Type 2) Declare a Vector with my new data type Dim EmisionesAnuales() As ContenedorEmisiones 3) Finally i use it like this: For j = 1 To AgnoFinInv - AgnoInicioInv + 1 For k = 1 To NUMERO_ESPECIES EmisionesAnuales(j).Vector(k) = Emisiones(k) Next k Next j An that's it. A Collection ...Show All

• JohnJustice How to fill worksheets with HTML

  Hi guys, I have a workbook which holds approx 5 worksheets, every sheet is a result from a transformations (XSLT). I've written a vba code that turns this transformations in html outpurs, now I'm desperally wondering to distribute every html result in each different sheet. Maybe I'm probably clutching at straws but, if you don't ask you don't get. In my VBA this string (sHTML) gets the transformation XSLT in an HTML format sHTML = xmlDoc.transformNode(xslDoc) I already tried this Application.Goto Plan1 ActiveCell.Value = sHTML ...and this Plan1.Range("A1", "E10") = sHTML But nothing fills this HTML output in one of my worksheet. Will be this impossible to do I just ha ...Show All

• theFranz How can I store a merge field value as document metadata?

  Hi, I'm looking for some ideas on how I can achieve this: I have a Word Template that is used in a mail merge. When the merge happens, I want to store one of the the merge field values into the document in such a way that I can use this value later from a VBA macro. Can anyone give me ideas on how I could do this Thanks. Thom In case this is any help to anyone else... I managed to achieve what I wanted by adding code to the Document_New and Document_Open event handlers that took the value I wanted directly from the merge Datasource and stored it as a Document.Variable. This Document Variable is copied into the new document instances that is created during the merge. Thom ...Show All

• Bartosz creating hyperlink through vba

  hi, i'm facing a bit of a situation that's been driving me nuts for about 12 hours now. in a nutshell, i have a lot of data in access, where i use vba to crunch numbers, and from the same project, i open an existing excel file (thereby now using both excel and access functionality from the same vba code), where i need to paste and format the crunched data (reports) to look pretty, and be user friendly. in the user friendly part, i dynamically need to create hyperlinks from one cell to another cell (in the same workbook, and some even within the same sheet). it seemed straightforward enough, but i have tried EVERY possible approach...using the (worksheet).hyperlinks.add function, as well as trying (worksheet).(cell).formula = "=hyperli ...Show All

• ParityBit267563 Making connection from one Access database to another.

  I have a mdb file called the CustomReportsModule.mdb, and a Data.mdb file. I am trying to create a module within the Customom Reports Module to connect to the data.mdb (which is used only for data storage), and execute a select query. Then I want to create a table based on the query's results. I've been trying to use ADODB, but can't seem to really wrap my head around what to do. I have been searching the net, but haven't found what I think I'm looking for. Any help is appreciated -Thanks! Mike, I has a specific question in regards to the Set CMD usage and wanted your opinion on something. Leo Romero PDSN I found my own answer, but can't remember where exactly. I kn ...Show All

• MMMalik combine 3 combo boxes values into one string

  Hi all, I have a table of data which can filter out my desired information after i selected a range of date, for example 1-Jan-2006 to 15-Jan-2006, in a combo box. I can only choose date being stated in the combo box, not much flexibility. Now, i want to change the format of the combo box. Instead of one combo box which show the date, i want three combo boxes which show "Year", "Month" and "Day". I can choose any year, any month and any day i want and it will filter out. I am thinking of a solution by combining the values of the three combo boxes into one string, one line "1-Jan-2006", and start to filtering. Is this the only way to do it or is there any better ways to do this Below is my existing VB ...Show All

• Bluehunter Special action required for one item in a listbox

  Can anybody please help with the folowing request, To add an item "other" to the array (the easy bit) and when a user selects this item, an input box pops up and allows the use to type in text and then for it to get listed in the same cell location. Many thanks for any assistance. Option Explicit Private Sub CommandButton1_Click() Dim i As Integer Dim s As String 'ActiveDocument.ListBox1.Clear s = "" For i = 0 To Me.ListBox1.ListCount - 1 If Me.ListBox1.Selected(i) = True Then s = s & Me.ListBox1.List(i) & ", " End If Next i ' If Len(s) > 0 Then s = Mid(s, 1, Len(s) - 2) ActiveDocument.Unprotect ActiveDocument.Tables(1).Cell(9, 2).Range.InsertAfter (s) ActiveDocument.Protect ( ...Show All

• Pete_M If... GoTo

  Hi, I struggle on this one. I want to search a workbook for a worksheet named 'STAT'. If that is found the function shall GoTo 'Start:' else I want it to GoTo 'Manual_Pick:'. Here's the code as I wrote it. It works fine when there is a worksheet 'START' but if there's not it doesn't GoTo Manual_Pick. Dim ws1 As Worksheet For Each ws1 In Worksheets If ws1.Name = "STAT" Then Worksheets("STAT").Select If ws1.Name = "STAT" Then GoTo Start If ws1.Name <> "STAT" Then GoTo Manual_Pick End If Next Star: ...some code... Manual_Pick: ...some code... Any ideas Best regards \Jonas Ehh stupid of me thanks! Not stupid at all. Everybody makes ...Show All

• Mehmet Erdogdu Please help me write a code to retrieve a data file from another location using macros in excel

  I'm streaming data onto a txt file, I want that file to be retrieved when I start excel (loadfile)command.Please help.I'm new to VB and Macros You can place your function in the Workbook module's OPEN event Private Sub Workbook_Open() ' Your code here End Sub This event will be triggered and then you can perform your action. For how to write the function to retrieve the data from a text file, there're many resources on the Internet. Hope this can help you a little bit. ...Show All

• Deco Running script

  Hello not sure in what forum to ask this question but I was wondering if it is possible for the task scheduler in windows xp professional to do something while no one is logged on to the comuter Great thanks for your answer! Do you have any tips on links that tells you how to write an easy script for the task scheduler Thanks!! Thank you very much for your answers. However I just heard that there was something called Task Scheduler but I do not where on the computer that you can find it. I found something in the Control Panel called Scheduled Activities but I suppose that refers to the task already created. Where can you find the Task Scheduler Thanks again! ...Show All

• Elango311325 Problem automatic opening of .doc's with WebTools elements fails

  Hi Folks ... Ok, opening a .doc file with a button and converting it to rtf ist simple. But currently I'm facing a very interesting problem. I use a VBA Script to open a specific .doc file on my local hd. This works fine, but when this document contains for example an input field (from the WebTools) the following code fails without an error message (or better with an empty vba error box) on the documents.open(.. line. Dim wordApp As Word.Application Set wordApp = New Word.Application wordApp.Visible = True Dim wordDoc As Word.Document Set wordDoc = wordApp.Documents.Open("c:\test\MyDoc.doc", _ AddToRecentFiles:=False, Format:=wdOpenFormatAuto) ... The problem occurs on Office XP and 2003. Any ideas ...Show All

• Jarodtweiss Help Deploying VBA changes across hundreds of Word Temlates

  I have been asked to "clean up" existing Word templates that have VBA code in them. Basically what I need to do is to remove the old code that is currently in the ThisDocument class module of the template and replace it with the new code. I've exported the "good" code to a .bas file and I have worked out how to import it back into the Word Template but the only problem I have is that I am importing it as a new module and the original code for the template is stored in the ThisDocument module. I don't know how to either clear the ThisDocument module programmatically (using VBA) or how to replace the contents of it with the "good" code. There are hundreds and hundreds of these templates and I am looking fo ...Show All