Answer Questions

• SYED HANIF SH Lost... Face on a milk bottle lost

  Hello everyone. I am a new programmer and new to this board, as you might have noticed from: (choose one) 1)Incorrect placement of thread 2)Horribly easy question I am in High School with aspirations of becoming a game programmer, and have a bit of a problem. I am using VBA for a game, and I am trying to, for lack of a better term, Group controls together. my question is this: Is there a way to group 2 or more imageboxes o ...Show All

• smoky6880 Serial Port communication from Excel 2003

  I am trying to write a simple VBA macro that reads Text data from a Serial port and puts it into an Excel 2003 spread sheet. The solution needs to work from a standard installation of Office 2003. I cannot use add-in modules since the envrioment has been locked by the SysAdmin. Can I make calls to windows API to communicate with the port from Excel Is there some sample VBA code that shows how to do this ...Show All

• VJV Generating a Printable Document based on Styles.

  Hi, (Please excuse me if this isn't the correct place.  this is my first post.  If I am in the wrong area - could someone point me inth right direction) Anyway - this is my problem. I manage a User Guide for an Service Development Scripting Language that runs on my companies Telecoms Platform. This Language is used by both Internal Development Staff to write call-flows and by Customers to develop thier own Appl ...Show All

• TFD2001 Avalon Adaptation

  Scenario Lets say that Avalon is released for XP (and in Longhorn) on time, Holiday season 2006, and that it is accepted as “wonderful” like we all know it will be. Question: How rapidly will it make its way onto the corporate desktop What percentage of corporate desktop machine will have Avalon install one year later, two years Are there any moderately reliable figure that we can use in our sales projections Anything will be helpful Tha ...Show All

• mjhadden Microsoft Document Image Printer - MODI Registry Settings

  Does anyone know what are all the available registry settings for MODI Through much searching in google (msn search finds nothing) I've found the following the following ' Write to File Only (uses current save folder and Note####.mdi as file name) SetKeyValue HKEY_CURRENT_USER, "Software\Microsoft\Office\11.0\MODI\MDI Writer", "PrivateFlags", 1, REG_DWORD ' Don't Show Popup Window SetKeyValue HKEY_CURRENT_USER, "Softwar ...Show All

• wgreer After_Save Event???

  Hi to all. I have a problem. For some sheets, I set to invisible before save. Now, I need set to visible the sheets after save, but there aren`t a After_Save Event... How can I solve my problem Any idea Thanks & Regards. I would try to use the BeforeSave event to cancel the users request to save, and do your own saving routine. I suspect you may need to set a global variable so that you can determine if the save reque ...Show All

• siwi Sending a variable from excel module to an add in module

  Hi All, I have an add in module, which include a sub that should get a string variable. i have few workbooks which should use the addin module, and each workbook should use it with a different value of the string i want to send the vairable from the local workbook i am aworking at to the addin module and sub. any idea how i do it thanks Shay Hi Shay, You can call an addin m ...Show All

• Ali Reza Pooneh Problem With Code That Writes a Change To Itself

  I have written a sub that modifies the code in the if statement of a functon in a different module. Trouble is that during runtime, I haven't found a way to get the equivalent of a Compile VBAProject to occur so that the behavior of the function actually changes on the fly. Even though the code is changed by the technique, the behavior when called always stays v1 > v2. Isn't there a way via the VBIDE classes or something to get the recompile ...Show All

• Ted MD How do I do to work with two XML files in VBA

  Hi, I'm doing a simple use of XML and trying to display the results in MS Excel. in the moment I have one XSLT that compares datas between two XML files and I'd like to know how to do to view the final datas from this comparation, in Ms-EXCEL, to be worked by other sheets. By now I don't have any idea how to do it (work with 2 xmls + 1 xslt), I already  do transform using an XML and a XSL file and it works nice, but now Coul ...Show All

• HAMID SHAHID passing data from a form to a module

  I have the following module Option Explicit Public Currency_Sold As String Sub AutoShape1_Click() UserForm1.Show Cells(10, 11) = Currency_Sold End Sub In UserForm1 I have Public Sub OK_Click() Currency_Sold = Currency_Sold_Code.Value MsgBox (Currency_Sold) Unload Me End Sub When I clik on the AutoShape1 button in the spreadsheet I do get the correct value of Currency_Sold in the MsgBox, but it i ...Show All

• old_nick12 How To Transfer Data to ADO Data Source from Excel with ADO

  Hye Is it possible to write/udpate data into a table in Access-database from an Excel-workbook using ADO I wonder if anaybody can help me Regards Fiftyfive Yes it is. ADO is a COM object that can be used in any Office application to update a Database. There a bit to it and don't have much time right now so many this post might continue on for a while. The first you want to do is create a reference to ADO in Excel. Tool ...Show All

• Tijoy Open a Word Document

  Hello i need to find out how to open a word document from my access database any one know a good solution. i have an ole object and you can drag and drop the file onto it but i need a way to have it load up in Word so it can be read/written/printed via word 2003. You can use Word objects to open a word document Make sure that you include the Word 9.0 Object Library and then add the following code Dim oWd as Word.application ...Show All

• Gunjan Moghe Fastest Processor for Running Excel VBA Macros

  i have written a series of complex VBA macros in excel as part of a system to generate hundreds (even thousands) of data reports from large data sets. on my old desktop (p4 @ 3.2; 3gb ram) some of the macros take hours to execute - i even let them run overnight. i wanted a new computer that could run them in much less time. so we invested 5k in a new desktop (dual core xeon @ 2.8; 4gb ram; twin 15k rpm hard drives). i ran a simple macro ...Show All

• Velimir How do you test a user's input for alphabets?

  Hello programming gurus! Is there anyway to test if a user's input contains only alphabets Thank you! Wonderful! Thank you Derek and Chris! Just thought I'd share that I ended up using OR instead of AND. Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) If KeyAscii < 65 OR KeyAscii > 90 Then 'invalid input, set to zero (ignore ...Show All

• Brad House Edit Data in Access

  Hi, I currently have a MS Access 2002 database, and it has a table with the fields "Part", "Quantity", "Date", and "Comments". Thie "Part", "Quantity" and "Date" data are extracted on a weekly basis from another MRP database. However, I have to manually copy the "Comments" data over because it is not part of the MRP database. I wrote some simple queries to see ...Show All