Answer Questions

• stak32 Question: How do I hide the Title Bar?

  Howdy... I'm writing a program in Excel and I was wondering how to hide the Title Bar. The one with "Microsoft Excel" and the min., restore, and close button. If that's not possible, is it possible to deactivate the close button Set the forms borderstyle property to none. Hi, Have a look at Stephen Bullen's FunForm workbook. http://www.oaltd.co.uk/Excel/Default.htm I know his code is designed to apply the formatting to a userform. But by changing the code in the class to use the application window handle rather than the userform the effects still work. But be very careful when playing around with application setting. Make sure your code returns the enviroment to the same state you found i ...Show All

• AndyL Microsoft....Is this a joke? (email received from customer service at microsoft)

  Below is the response I received when I attempted to report a bug in IE 6 to the website...In my opinoin, this is outrageous! Hello George, Thank you for contacting Microsoft Online Customer Service. I apologize for any delay in our response to your issue. Due to an increase in requests, our response may be longer than usual. We appreciate your patience. I understand you have identified a bug in Internet Explorer 6 and you would like to report this bug. I request you contact the Microsoft Product Support Services team to submit a report with regard to the bug you have identified in Internet Explorer 6. You may contact them by calling (800) 642-7676. Representatives in this team are available 24 hours a day. You may have to ...Show All

• Geokri Dynamicaly enter Data in Microsoft Access

  I need to be able to enter data in a form feild dynamically in vba. I allready know the value that I want the feild to have. I just need an example of how to do it. I tried changing the default value in a form but thAT did not seem to work. Thanks for the answer. Wait a minute I need more details.!!!!!!!! What form are you refering to A user form OR a datasheet Hi Try attaching your code to an event on the form such as the change event on one of the other fields that are keyed and are required ...Show All

• DMKanz Pivottable Drilldown Lists in wrong order (Excel, Pivottable)

  I am using a Pivottable with external data in my Excel Sheet. On the sheet I included a Button to refresh the pivottable via pv.RefreshTable As there might be some new data, also the values of the drilldown lists may change. So when I initally created the pivot, I had these employees: Mister A, Mister B, Mister D, Mister F. By clicking on "Refresh" some new data comes in, including Data from Mister C and Mister E. So the original drilldown list has: (Show all) - Mister A - Mister B - Mister D - Mister F after Clicking Refresh, the drilldown lists just added the 2 new employees: - Mister A - Mister B - Mister D - Mister F - Mister C - Mister E How do I get them in the correct order, after refreshing the data ( In re ...Show All

• alexey.polovinkin Error Referencing DLL in VBA

  Hi ! I have prepared an MSI Installer for my XLA to be deployed on the server, the MSI contains all the DLL referenced by the XLA. The MSI runs fine but when I try to open Excel on that server it gives me a reference error, I have to *explicitely* go in VBA Editor and set the reference for the erroring DLL, after that the XLA works fine. The strange thing is that in the MSI I have set the path to D:\ Prog Files\... but strangely the MISSING reference in the Refernce dialog box shows C:\Prog File \.... Can this be because the server registry has not been cleaned up or perhaps there are more than one DLL registered Do we need to Uninstall (from Add/ Remove Progs) the MSI from the server (if it was previously isntalled on it) before act ...Show All

• Rob Scanlon DLookup help?

  Hi there - im building a contact management system and require some help. I have previously had help with VBA in terms of defining what users can and cant do within the system when logging in via a username and password which was incredibly useful. Im now at further along the route and now want to incorporate an activity system that will record all hours that employees will have worked against clients. However we have a lot of clients! The users login name('login_name' which is held in 'tblusers') is also entered into a 'leadofficer' field in 'tblcompany' so that we know which user is responsible for managing that client - this is done through a combo box on the company entry form so it looks up the values from the table 'tblusers'. On th ...Show All

• jtalbotfdr 0x62304320 referenced memory at 0x62304320

  How do I fix this ...Show All

• Molon Labe Sum of hours using select statement & VBA

  Hi - ok here is my question: I have an activity recording form that records hours logged against a company. I have added a field called 'sumactivityhours' to the table and the form.  what i would like to do is when a user selects a company from the drop down list (thanks derek and duck thing for your fantastic help with that problem) it automatically populates the 'sumactivityhours' field with the total number of hours worked thus far with that company  so that the user can see the total hours and then writes that information into the 'sumactivityhours' field in the table. as i gradually begin to learn a little more about VBA im guessing that i should create an on exit event on the companyname combo box that re ...Show All

• SimonS_ Reading an Excel workbook without opening the file

  Is it possible to read a workbook and store in a db component without opening it thanks, music Maybe this article by Dennis Wallentin is of use. http://www.excelkb.com/article.aspx id=10039&query=closed+workbook ...Show All

• SPECIALK_BC Attaching Contents of a Folder

  Hi all, Using a macro running on excel, I am trying to attach the contents of a folder in Outlook. The files contained in the folder change, so it is not as simple as writing the code to attach a specific file. I need it to attach all the files regardless of the file name. Is this possible Thanks in advance Hi Catherine, Not 100% why you should get that message. I assume you have Outlook and not another email client. You could try a modification to this line. Set OutApp = CreateObject ("Outlook.Application", "localhost") Hey Andy, When I tried to run your code I got this error message, " The specified module could not be found ". ...Show All

• Heino Office 10 \ winword.exe runtime error

  I have downloaded the service pack 3 but I'm still encountering the problem when I try to open MS Word. MS Excel, MS Outlook , MS Powerpoint & MS Viso all work fine. Any time I try to open MS word I receice a Box vissual c++ runtime library. This application has requested the runtime to terminate it in an unusaul way. Microsoft Office\Office 10\Winword.exe. Hi, I had exactly the same problem with Office 2003 and principally with Word 2003. I noticed the problem only occured after I typed a few words on a document, or when I chosen to open an existing one. So, what's happening after typing a few characters Spelling check ... indeed. The default language of my office installation was in D ...Show All

• Beth Excel: Email Macro help

  Hey All, I have the following macro code Sub Button1_Click() Dim EMail As Object Dim Link As String Link = " <web/file link " 'Filepath Set EMail = CreateObject("Outlook.Application") 'Assign Outlook application to variable With EMail.CreateItem(olMailItem) .To = " <email address> " 'email address .subject = "Update" 'Something for the subject Field .Body = Link .Send End With Set EMail = Nothing ' release memory End Sub As you can see from the code, you click the button and will send the link via email. In the code above what do i need to remove/add to stop the email from sending automatically and actually open instead of sending straight away Please ...Show All

• David-Paris 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

• Zooz VBA function having it's name's case changed in excel

  I am just starting with VBA / excel though I am a moderately competent programmer. I created a function B4FirstBlank() (written exactly like that) that looks at a Range reference and finds the value of the cell before the first blank cell. It works fine but whenever I type it into excel it is rewritten as b4fIRSTbLANK() which doesn't do much for me in terms of readability. I get other strange rewriting of functions too, any guidance on how to sort this out much appreciated. Andrew Thanks for the reply. I've had a good look and it is definitely called B4FirstBlank(). For some reason it is now appearing as b4firstblank(). I have also looked for multiple definitions and while I do have the same function amo ...Show All

• Evan Mulawski opc

  I am trying to develop an opc - da client using .net technology. Have gone through the documents on opc and opc client and all, but am still not sure how to implement it, can someone give me a direction on how to start with it can you please provide some additional details on exactly what you're trying to do and any other relevant info that I can pass on to our support engineer thanks, -brenda (ISV Buddy Team) You can use vb.net or c# with rslinx's COM dll. You just add the reference to RsiOPCAuto.dll to your project and use its classes. To pass an array to a OPC method, just dim the array to n+1 and fill it starting at index 1. The method will return object arrays that you will read s ...Show All