Recent content by mrsnrub

Edit... my example: copy cell A1, paste in cell A2.

She is simply copying and pasting within a single Excel 2007 worksheet. No other software/media at all. For example, click in cell A1, paste in cell A2. Cheers.

Hi everyone, I have a user who cannot paste in Excel using the right click menu. When she copies cell values then right clicks, both the Paste and Paste Special options are disabled. However, she can use Ctrl+V, or the paste options from the ribbon. This is happening in all workbooks on this...

Thanks for the reply Jason. I know what exception is being thrown, I had changed this code as part of my debugging before posting, sorry. The exception is an RfcAbapException, which is part of the .NET Connector proxy tool that I am using to communicate with SAP. Unfortunately further research...

Hi everyone, I have an ASP.NET application that is calling some custom functions in SAP. One of these functions throws an exception when no data is available, and I catch this in my code. This works fine when I run the application in debug mode locally. However, when this site is published and...

Thanks MiS... please trust me when I say that isn't my code :) From what I can gather the code just does some basic reformatting and summarising for a periodic report. It was the first I had seen of it when it got lumped on my desk a couple of days ago. I wasn't aware of the changes to the...

Thanks for the replies. Glenn, there's no protection or passwords set on the spreadsheet so unfortunately this isn't the answer. What confuses me is I can't replicate it on my machine. It is legacy code from 2003. The code looks to have been created straight from a recording and is very...

Hi everyone, We have a user who has recently upgraded to Office 2007. He has a spreadsheet which contains macros. When the file is opened as XLS or XLSM the following message appears: "Cannot run the macro 'Filename.xls!MacroName'. The macro may not be available in this workbook or all macros...

Thank you all for your responses and suggestions. In regards to the Activex DLL suggestion, the requirement is not cross-application, sorry. I have the same requirement for both Excel and Word, but they will be separate macros. I believe I will go with the suggestion to store these macros in...

I have a situation where a number of files (Excel and Word) all need a particular macro to run when they are opened. I am trying to decide on the best way to do this. I could add the code to a .bas file and import into all applicable files, but if the code needs changing I would need to...

Thanks for the input, these are a couple of good places to start. Cheers.

Hi, this is a bit of general question, I'm hoping for a nudge in the right direction. We have a wiki type WSS site that we use to publish announcements, basic procedures, etc. We also have a SQL based help desk application for logging support requests. I would like to publish certain details of...

Hello everyone, In Excel 2003 when you have comments on cells in an AutoFilter's heading row, they will not be displayed when the worksheet is protected. The only way around this I have found is to allow 'Edit Objects' in the protection, which allows the comment to be editted (may not be...

Awesome, that will do the trick. Cheers.

Hi everyone, I have a spreadsheet template where we dump some hours/minutes data from another application and then manipulate in VBA. The format of the hours in this other application is hh:mm:ss. This cannot be changed. There is no date component, only the time. When the hours/minutes...