Answer Questions

• lunaa 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 Hi, You do not say what the actual problem or error is. Or what code you are using. I did notice from my very limited testing that the width of the textbox does not appear to be automatic. I had the same problem when I took my applicatio ...Show All

• MechiF Sum of hours for month following submission date only

  Hi - im a little stuck on one part of my system. Thanks to the help of others i can now get users to enter a submission date into the activity system that then restricts them from editing any activities prior to that submission date ( a field called 'datelastsubmitted'). However on that end of month submission form i also need to show the sum of all hours for the month that is to be submitted next. By this i mean that if a user last submitted on the 31/10/2006 then the next time he comes to submit he will see the sum total of activity hours he /she has entered for November 2006 i.e 01/11/2006 to 30/11/2006. The field is called 'availablehours' and the code i have written does sum up the availablehours for the user but im unsure as to how t ...Show All

• Thibaut Barrère Reset a computer in Active Directory with VB.NET

  Hi I'm building a application that manages some topics of Active Directory like OU's and CN's and I need to reset a specified computer. If somebody know how I can do that please tell me Thanks ...Show All

• StUdEnT in distress cutting down this code? help?

  Hi im writing  a form to transfer a manually inputted value from 2 cells into a table(in another sheet) but a different colomn depending on what day is selected... now the value of cell B1 is the name of a person from the dropdown list 15 names in total so B1's value could be 1-15, the value of cell C1 is the day of the week (there are options to select on the form for each day) 1 - 7 is obviously monday to sunday, then the button which launches the code and copys the data making it simpler for me to log the data. now this snippitt below works but i can see this becoming one mamath code and am hopeing someone can help me make this code alot smaller maybe using arrays or a predone func ...Show All

• kru How to re-connect an Excel.Application variable to a disconnected Excel instance?

  Hi, Automating Excel is wonderfull. I program it quite offen and I quite enjoy it. I have a question: When a program with new a Excel.Application is broken and stopped, the created Excel instance will be deattached to any VBA variable. In this case, I need to be "End Process" manually in the window task manager. I do this more than 50 times in one day of programming. Without doing this, I once had found more than 20 Excel instances in the task manager. It is terrible. I tried following, the program broken at J=27 in my 1Gbyte RAM notebook. Dim J As Byte, mExcel(1 To 50) As Excel.Application For J = 1 To 50 Debug.Print J; Set mExcel(J) = New Excel.Application Next Stop My question is how can I scan all curre ...Show All

• da Vinci Does WER work for Outlook addins?

  Hi, My company's product is an addin for Microsoft Outlook. It seems to me that WER is geared toward applications and drivers. It's unclear to me whether or not it's possible to receive Outlook crash dumps based upon the addin that (may have) triggered the crash. ...Show All

• Alan Z RunTime Error '2001'

  Hi, I am getting " runtime error '2001' you cancelled the previous operation " in my VBA code for MS Access. The database is saved on the server and linked to a table of another database which is also on the server and used by many users. But when i put everything locally then i wont get this error. Pls help! Thanks in advance Cheers Rohit I beleive it has something to do with the bookmarks becuase I comment out that line above and everthing didn't work as it did with using the bookmarks, but I didn't get the error messages.  I was doing the above code when requerying my records on my form to get rid of ones that didn't meet the criteria I had set...this be ...Show All

• swlee Data pickup Issue

  Hello Every body, I face a problem about data pickup from datasource. ok i try to explain it first. Some my ui have different combo box. comboboxes contain data like Panel, Reader, Badge etc devices. each combobox contain single object data. in left side of every combo, one check box item is there. if combo box will checked then combo box will be enabled and show its data other wise not. In that senario user may check all checkbox or not any singel check box. It totally depends on the user. In that senario what i did, I pickup all data from database and bind it to the combo box when form first time loaded. that means loading time of form i request to my business layer to give me all data. Is it correct approach. Thanks for advance help. ...Show All

• Tom De Cort Matrix syntax

  I want to create a multidimensional array in VBA. My code is: Dim strDataMatrix(0 To 10, 0 To 2) Does that mean ....(rows,columns) or ....(columns,rows) I know how an ordinary array works and everthing but what comes first in the multidimensional array, the number of rows or columns Any help very much appreciated! I have gooled this but with some results that do not seem coherent with other VBA functions e.g. Offset or common mathematical notation. Therefor I need to be sure of how it works. Thanks! Hello AndersBank, It is up to you whether it is rows,columns or columns,rows. You will be filling the array. If I had a cell range for example, 11 rows down and 3 columns across. I would Dim it as ...Show All

• laja saving data in a userform without saving the workbook

  Hi, I have an excel VBA project which interacts with the user entirely through userforms (built it in excel rather than VB since I want to access underlying data from excel sheets for the calculations). How can I export all the data and calculations on a particular userform into a txt file or other file There may be multiple userforms open, and saving will just save one of them, loading will load the data from file, initialise a new userform and load the data into it, all without upsetting the other userforms or the underlying workbook. I'm thinking that I can use one sheet of the workbook as a scratchpad, so when the macro is called, write the userform data onto that sheet, then save the sheet only as a text file by Sheet2.Sa ...Show All

• Ronaldlee Ejalu Selection of only one object

  I have a macro that lets the user first select a number of charts and then when the user presses a button the charts sizes and color are eing changed. The problem is that it does not works if I only have one chart selected. When I have two or more it works fine. My code (relevant parts) is: Public Sub arrayLoop() Dim obj As Object Dim currentChart As Object For Each obj In Selection If TypeName(obj) = "ChartObject" Then Set currentChart = obj Call linjeDiagramKnapp(currentChart) End If Next End Sub In this sub I check the selection to see if the selected objects really are charts. I assume that there is something wrong here on the first line of the For-loop, but I do not know how it should be ...Show All

• LPastor row height

  Hi, I have been given an excel template. This template gets populated with values in cells appropriately. The task is that if a value is not present in a cell of a row then hide or delete that row. something like zero suppression. I was thinking about setting the row height of that particular row to 0 in the load event. If this is ok, then what is the code for this requirement please Solved it as follows: Dim i As Integer i = 27 For Each c In Worksheets("Sheet1").Range("C27:C57").Cells If IsEmpty(c.Value) = True Then 'Rows("43:43").RowHeight = 0 Rows(i & ":" & i).RowHeight = 0 End If i = i + 1 Next ...Show All

• Jules23 seek for a file

  Hello I want to seek for a file in a directory from Visual Basic and to know if is opened or closed. Hi Below is from the help text, it will help with finding out if the file exists. No sure how to check if the file is open. Function ReportFileStatus(filespec) Dim fso, msg Set fso = CreateObject("Scripting.FileSystemObject") If (fso.FileExists(filespec)) Then msg = filespec & " exists." Else msg = filespec & " doesn't exist." End If ReportFileStatus = msg End FunctionFunction ReportFileStatus(filespec) Dim fso, msg Set fso = CreateObject("Scripting.FileSystemObject") If (fso.FileExists(filespec)) ...Show All

• mr4100 Loading Select data through the linked tables

  I have an access front end whose tables are linked to an sql server data base. when the database loads is there a way to select certain data to load through the linked tables. For instance Say I wanted the liked tables to load only the data for the customers in the state of Connecticut. I know I can do this with queries but I want to know is it possible to do with linked tables directly. In access you only have the capability to link to the entire table...however as you suggest you can create a view that will only show you the criteria that you set for the query ...Show All

• Tailor insert a picture into an excel template

  I am creating a template in which i would like the user to be able to click a command button or image button, and for the file open menu to open for the user to select an image off his/her harddrive and insert it into a cell. I would also like the image to be inserted to fit a certain size restriction within the cell so it will not cover the entire screen. Is this possible and if so, could you all point me in the right direction Thank you What i meant to ask is, if i created a cmd button called "clear picture" how would i clear it out is there an expression similar to the image1.picture = LoadPicture() that instead can clear the picture something like image1.picture = removePicture ...Show All