Answer Questions

• jptaba macro that hides rows - excel

  hi, i was wondering if there was a way to write a macro that will automatically hide a row based on a value in a cell in excel say, if the sum of a selection of cells = 0, i want to hide the row all together. is there a way to do that thanks. anthony If you need to look at each cell individually you will need to loop through them. If they are in one column and consecutive then this is not too difficult. The b ...Show All

• JohnyTho enabling controls at runtime

  i have a userform with two listboxes, and six optionbuttions. the options buttons are split into 3 pairs of two. at the outset only the first pair of option buttons is enabled. the following code tests to see if more than one selection is made in a listbox, and if it is, then enables a relevant pair of option buttons. Private Sub Listbox1_change() 'check to see if there is a multiple selection Dim i As Integer Dim Acount As Integer Acou ...Show All

• Brewer_J .NEt and industrial automation

  Hi all, I want to get information or links to read about combination the .Net framework on the industrial automation. I mean SCADA and HMI or OPC in . Is there any classes or components that deals with these issus s there and open sourse tutorials of these systems Regards... Per one of our internal support engineers: Our ISV buddy’s question: ===================== I want to get information or links t ...Show All

• to_hitesh Exporting a table from an Access File to another Access file

  Hi, Im trying to export a particular table from an Access file using VBA to another Access file.   Help please. PSD Hi, Before I can escalate this to our support team, what version of Access are you using thanks, -brenda (ISV Buddy Team) actually, that's what the support engineer just suggested. :-) thanks for jumping in! here's some additonal info: We can use transfedatabase to do it. ...Show All

• ewok66 Display a drawing on an MS Access Form

  Hi there i would like to display a drawing (test.dwg) on my form in a vb code. The form has an Bound Object Frame - OLE1 area. So when the i press an button it should display the diagram itself (not the link) inside the Bound Object Frame and be able to zoom in and out and edit. Thank you Per our support engineer: Base on my understanding, our buddy wants to insert "SmartSketch.Document" object (a ...Show All

• PatrickR Put E-mail In From Field

  Dear All, Please Help me , I need a VBA code to Put certain E-mail in From field before sending any E-mail Automatically Dawy You can use the "SendOnBehalveOfName" property: Sub MailMe() Dim outApp As Outlook.Application Dim outMail As Outlook.MailItem Set outApp = CreateObject("outlook.Application") Set outMail = outApp.CreateItem(olMailItem) outMail.SentOnBehalfOfNa ...Show All

• Peter Poirier Sql Server 2005 Resource Kit

  Hi all,   how do I view the slides that accompany the webcasts on the DVD. I can hear the audio stream fine but just get 'page not found errors' for the graphics. Hi, If you could provide some additional details about the system that you're running, we'll try to track down what might be causing this issue for you. Thanks, Brenda (ISV Buddy Team) I just found out that all of the Webcasts ...Show All

• AL... 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 Here's the latest from the engineer: I understand that you are having some trouble creating and posting Outlook it ...Show All

• Francisco Rivas Autosave using VBA after n minutes

  Question: Using Excel 2002 SP2, I use VBA to drive a database of currently 15,000 records which automates a number of tasks such as letters, faxes, etc. Problem is, is that I don't know how to create an autosave function. I've integrated a save button instead but would like it to autosave after, say, 10 minutes. The only thing I can think of is to give the workbook shared access. I don't want to do that. Any assistance will be appreciated. Cheer ...Show All

• wolfoftheair Copying email contents into Excel Spreadsheet via an Excel Macro

  Hi, I'm trying to automate a contest that I'm in charge of. I get contest submission emails from our website and I've set up outlook to put them into a folder. I tried to write a macro to open the emails (that have a 2 column, 7 row chart with the fields names in the first column and the entrants data in the second column), copy the content and paste it horizontally in an excel file, but can only get the macro to do exactly what i've done. it wo ...Show All

• Cabadam 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

• WernerKossack How to remove Application members from the global namespace

  Dear Support, We recently implement the Application.Left property to move the application main window similar to the Office Application.Left property. Afterwards we encounter the problem that the 'Left' and 'Left$' symbols now are resolved to the Application.Left property instead of to the VBA.Left and VBA.Left$ methods. I noticed that the Office '98 VBA implementation suffered from the same artifact. This has b ...Show All

• maniac How to open Access files and export them to Excel

  I need to open multiple Access files and export several colums to Excel. The problem is that the file extension is not a typical access one and that I need to choose a table from several tables for each file. Then I need to merge into one excel document. Any help would be appreciated, thanks. What is the file's extenstion and its VB.NET right Do you know much about ADO or ADO.NET I'm sorry ...Show All

• Anders Ryden 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

• Mike_Kla VBA for Powerpoint

  Hi, I have been asked to modify a powerpoint presentation so that from a series of jpg files, one appears on the screen and then after a specific time period disappears and is replaced by another; this being a continuous loop on one slide only - like a photo tour. I have the following code, but need to get it up and running. Any suggestions: Sub ImportABunch() Dim strTemp As String Dim strFileSpec As String Dim oSld As Slide Dim oPic As S ...Show All