Search results for query: *

(I posted this elsewhere accidentally - apologies). I am trying to set up a customised ribbon in Microsoft Project 2010. Most of of it works fine but I am unable to get my dropdown button to function. Specifically, I cannot get the index of the selected item (or the item number for that matter)...

I am trying to set up a customised ribbon in Microsoft Project 2010. Most of of it works fine but I am unable to get my dropdown button to function. Specifically, I cannot get the index of the selected item (or the item number for that matter) to be returned. I get an 'Automation Error' with...

I have discovered painfully that references to task properties in the form of Activeproject.tasks(ID).name and even TS(ID).name after the required 'Dim TS as tasks Set TS = ActiveProject.tasks' are hugely expensive statements to use. I have also learnt (see previous post) that the...

Hi, I am desperate for some help. I have VBA code that processes 80 high-level phases or WBS elements, each consisting of 40 rows, within the Microsoft Project task list. It takes about 75 seconds to process EACH of these phases when they are assembled in one file, which is incredibly slow...

Hi In Excel, I want to be able to hide the 'tools - options' area or prevent users from reaching there so that they cannot reveal row and column headers etc. I tried protecting the workbook but this does not work. Any help would be appreciated. Thanks

Hi, I have not had this need before but I have a display which exceeds the height of the viewable area (so that things are readable with my selected zoom size). I want the user to be able to scroll down to the bottom of the area but no further. Freeze panes does not seem to be able to do...

I have read some of the responses to similar questions regarding Worksheet_Change routines that allow macros to be activated upon change to a cell. However, when I run this, (say the following), I get a 'argument not optional' message. Can anyone help? With thanks Private Sub...

Hi there, Can anyone tell me how to cause a Microsoft Access report to be printed at the press of a button in Excel? Would love to know. With thanks

I am using Excel Solver under control of VBA. When I have a constraint with an upper and lower bound, one of these is lost. For example if A1 contains a decision variable and I have A1<=1 A1>=0 the second one simply disappears when using VBA. I would really appreciate advice on how to get...

Hi all Using VBA in Excel, I want to intercept a mouseup and mousedown event for a command button dragged off the control toolbox and placed in the spreadsheet. I have used the declaration Private Sub CommandButton1_mousedown(button, shift, x, y) and also the version with "Byval button as...

Hi I have written some VBA code which occasionally needs to sort data in a hidden worksheet. I find that I need to unhide the sheet before the sort can occur and then rehide it. The sort action causes the screen to flicker and jump around where most of the rest of the routine is pretty...

Hi, I have a continuous form as a subform and want the user to double-click one of its fields, causing a small form to pop up to provide easy editing capability. As far as I can recall this worked fine when I first created it but now I cannot get any event-driven response...

I am working with Microsoft Access. Can anyone tell me how I attach a hotkey combination (e.g. Ctrl m) to a macro or a bit of VBA code in order to activate the macro or code? I would appreciate any help provided here. Thank you

I am aware that there are various codes around in VBA to zip and unzip files in relation to the Winzip utility. However, I need to know how I can write VBA code that will decompress a Windows compressed file/folder. Any help would be greatly appreciated. Thank you

Presuming that I can generate a DLL file using VB something (Express 2005 maybe - can't do it in VBA I understand??), how do I use this in an Excel application. For example, can I call one of the functions in the DLL file from a regular macro. How do I load a DLL. Is is similar to an xla...

Hi I have VBA code behind an Excel spreadsheet that does database queries (mostly DAO but some ADO) and also places and pulls values from cell locations around an Excel spreadsheet. The problem is that the program can run for minutes on end if the spreadsheet is large. My question is: Is...

I have a need to fill a very large number of Excel cells with values from a database table. When I use the Range.Cells(row,col) method I find it is very slow, requring over 30 minutes to complete the process. Does anyone know whether or not there is a faster method? I would appreciate help...

HI I have written some VBA code and loaded it into the Enterprise Global file in Microsoft Project Professional. All works fine except when I open project files, I get a VBA message that says "File Not Found" . I get this also when I simply look at the list of macros under "Tools Macro...

Hi Using VBA, I want to be able to examine a formula in an Excel cell and generate a list of cells referred to in it. Anyone know how to do this? With thanks in advance

Hi there, Does anyone know a way of telling in VBA code what type of data a given spreadsheet cell holds where the type would be either numeric (like 36) text (like "Saturday") or formula (like "=A1*2") Would there by a property of the cell which would reveal this or do we have to write code...