Search results for query: *

Ages I've used this fantastic forum, but my job has changed to a more technical one! , I'm trying to use Outlook Tasks to manage tasks for different customers. Each customer is set up as a Category and if I remember to set the category before saving, it works fine. However I often forget and I'd...

Resubmission to correct forum. Some advice please. I am updating some corporate Visio documents and somehow the contents of the Tags property is getting updated to its original contents if I delete it and save. Oddly enough, if I try to replace with a new tag, that appears in before the 'old'...

The subject pretty well says it. I've been using Document variables in Word to 'hide' variable data. Is there any equivalent in Excel or PowerPoint? Thanks Simon

The following code which asks the user if he wants the version changed before saving, works perfectly well, apart from the fact that it crashes with a 'Microsoft Excel has stopped working' error message when quitting the subroutine. I've trapped it and it crashes after executing End Sub...

I am trying to use VBA to do a FindReplace within a subset of sheets within a workbook and the code like this below works fine as long as the 'Within' parameter in the Find and Replace form is 'Sheet' Dim Rng As Range Set Rng = ActiveSheet.Range("A1", "ZZ1000") Rng.Replace...

A closed earlier thread (thread707-1438142) discussed the use of BeforePrint with Print Preview. It seems that it used to work with Print Preview, but I have found that it doesn't seem to be invoked with Excel 2010. Has anyone found a way round this? I am using BeforePrint to update the header...

Firstly - apologies if the answer to this has been posted before, but I've searched and can't find it! I am using Excel 2010. I have a multisheet workbook that prints fine to a physical printer when using 'Print Entire Workbook'. However if I change the printer to pdf (I have Abode Acrobat X...

We have a process where external files (usually word docs) are embedded into Excel worksheets. I want to be able to detect when such object is inserted. My current thought would be to count OLEObjects before and after some change, but Workbook_SheetChange isn't triggered by inserting an object...

Hi I am trying to do some variable reporting using VBA with MS Project. I want to extract all task fields (i.e. those fields that appear when you insert a column) in order to create a drop down list of them as options and then use that selection to extract data from the project tasks. I have...

Dear All I've read thread68-1305138 but just want to make sure that I'm not missing something. I like using keyboard shortcuts in Word and have just found that Excel is very limited in this respect. Can I really only assign using 'Ctrl+'? There's far more flexibility in Word and what's more...

Apologies if this is a dumb question, but I've surfed and can't find the answer. The following tasks have a calendar which start at 08:00 and finish at 17:00 and lags are all FS 0d. Task 1 1day task Finish today @ 17:00 Task 2 (successor to 1) 1 day starts tomorrow at 08:00 Task 3 (successor to...

I don't think this is possible, but still an interesting thought. My project has significant boards that will be making Go/No-Go decisions before Go Live. The first meets on a Tuesday. Is there any way to constrain it so that it retains the dynamic relationship i.e if it gets pushed to the...

I'm now using Word 2010 and prefer to use Advanced Find instead of the Navigation box that appears with Ctrl F and then the dropdown options. I have customised a ribbon and added the command Advanced Find to it, but when I try to use Customise Keyboard Shortcuts, Advanced Find isn't available...

We have a large macro-enabled Excel 2010 workbook (c4MB), full of formulae, that is updated weekly but is unwieldy to use for my limited purposes. I am trying to extract a 'lite' version for only 4 sheets, containing only values and formats. Paste Special Value works fine, but on some cells...

I'm trying to tidy up documents by removing any replicate paragraph markers and have found that the last paragraph marker is non-standard. I'm using Find and Replace and because I don't know how many replicates I'm going to find, I need to use .Found and a Do loop to keep cycling round. See code...

Below is an extract of some code that runs in Word 2007 calling Excel 2007 that works fine. Set AppExcel = CreateObject("Excel.Application") SpreadFullName = "C:\Users\Username\Workbook.xlsm" SheetName = "Worksheet" With AppExcel ' Open Spreadsheet, hide and activate...

I have written code which goes though a document checking that the right font etc. has been used. When it finds an error, it calls the Sub below: Private Sub Add_Comment(ByRef CommentRange As Range, CommentStr As String) CommentRange.Select Selection.Comments.Add...

I have bookmarked a number of tables within a Word 2007 document but when within VBA I select such a bookmark and test them I find that Selection.Information(wdWithInTable) is False! The reason I want to do this is that I need to do some processing on the contents of certain tables and I'm...

The TimescaleEdit method formats the timescale in Gantt view. Is there any way to extract the properties that this method can change? I'm writing a macro that tidies up the output for printing/view and would like to be able to set the Timescale to say Year, print and then return to the original...

Has anyone encountered a bizarre observation and hopefully offer a solution. I have an application that has successfully extracted timescaledata from at least 20 different project plans produced by other people. I have just received a plan that is accountably is missing values if I compare them...