dcsimg

Search:

Type: Posts; User: pickarooney

Page 1 of 3 1 2 3

Search: Search took 0.37 seconds.

  1. Re: Just want to select a cell!

    Hi Guys,

    First off, thanks for all your efforts. I was away yesterday, so didn't get time to try your code until now.

    Dave, that's quite a different way of thinking to me, I have to say :) I'm...
  2. [RESOLVED] Just want to select a cell!

    I'm going insane trying to do what should be the simplest of operations in an Excel macro, so hopefully someone can tell me where I'm going wrong.

    I have a spreadsheet with several worksheets,...
  3. Replies
    2
    Views
    473

    How to reference Normal.dot?

    I'm writing a macro which copies a style (Default Paragraph Font) from the users Normal.dot template file. At the moment it's hard-coded to point it to my own template, but how can I edit this so it...
  4. Re: How to manipulate index entries ({xe})

    Got a tip from a colleague - I needed to search for Fields of type wdFieldIndexEntry.

    Sub FixIndexEntries()
    Dim fField As field

    For Each fField In ActiveDocument.Fields
    If...
  5. How to manipulate index entries ({xe})

    I have a Word document with a load of tags in the form {xe "index entry 1"}{xe "index entry 2"}. They correspond to entries in the index.

    However, these tags are badly formatted, and I need to...
  6. Re: [RESOLVED] data type/variable no longer recognised

    OK, that makes sense. Sorry I couldn't give rep points to everyone as I needed to spread it around a bit before I could give it again (not quite sure what that's about).
  7. Re: data type/variable no longer recognised

    Thanks for all your replies, btw. The necessary add-in was here:
  8. Re: data type/variable no longer recognised

    I'm sorry, I posted this in the wrong forum, it should have been in the VBA section.


    I promise to do it in future if you tell me what the difference is :)
  9. [RESOLVED] data type/variable no longer recognised

    I'm trying to run a Word VBA macro and am getting an error message I never had before. My normal.dot template got corrupted last week and I had to remake it, so it's probably linked to that.
    ...
  10. Replies
    6
    Views
    541

    Re: Answer not correct

    I think that's still going to give a string, (10+5) as you're passing the plus-sign as a character. I reckon you have to run the Eval function on the same line as the assignment to Formula.
    I don't...
  11. Re: MSWord - readonly and protected, what's the difference?

    So if a file was protected I couldn't for example edit some of the text and save as a new document?
    Thanks for clearing that up :)
  12. MSWord - readonly and protected, what's the difference?

    I'm trying to get a line of code right, but am having trouble understanding the difference between these two things.

    Basically, I want to say, "if the document is readonly, remove the readonly...
  13. Replies
    4
    Views
    588

    Re: Excel Save Help?

    Yeah, it's just a guess though.
    I'm not sure why you need to specify savechanges as True, seeing as you've already saved the file in the previous line.
  14. Replies
    4
    Views
    588

    Re: Excel Save Help?

    Do you have to use double-backslashes for the path, maybe?
  15. Replies
    8
    Views
    471

    Re: [RESOLVED] Strings not equating

    Maybe it's a compound last character, a mixture of carriage return and line-feed?
  16. Replies
    8
    Views
    471

    Re: [RESOLVED] Strings not equating

    I don't know why, but it doesn't work.

    I added this check:

    If Right$(s.TextFrame.TextRange.Text, 1) = Chr(13) Then
    s.TextFrame.TextRange.Text = Left$(s.TextFrame.TextRange.Text,...
  17. Replies
    8
    Views
    471

    Re: Strings not equating

    Ehm, forget that last question. So I added your StringAsc function and called it on both strings within my Sub. They all match up but the second string has one extra character, '13', which I think is...
  18. Replies
    8
    Views
    471

    Re: Strings not equating

    The comparison is still failing when I use this.

    Do I need to create some kind of a form to use the character-comparison code you posted?
  19. Replies
    8
    Views
    471

    [RESOLVED] Strings not equating

    I'm running a string comparison on two strings that are identical in every conceivable way and yet the comparison is failing.

    One of the strings is s.TextFrame.TextRange.Text, where s is a Shape...
  20. Replies
    7
    Views
    4,917

    Re: Global Macro Problem

    Yes, the normal location is c:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART\PERSONAL.XLS
    I've no experience with .NET so I'm not sure how you're supposed to call macros...
  21. Replies
    15
    Views
    1,002

    Re: Insert new line in table

    Where exactly is the string coming from? Are you sure it doesn't have the box character in it before you go pasting it into the table?
    Otherwise try Chr(11) to add a soft-return?
  22. Replies
    3
    Views
    363

    Re: Remove Template/Macros

    Do you actually delete the .DOT file or just delete what's in the Document Template field in Tools, Templates and Add-ins?
  23. Replies
    7
    Views
    4,917

    Re: Global Macro Problem

    I keep all my macros in my PERSONAL.xls spreadsheet, and this opens automatically every time I use Excel and is thus available on the list of macros when I hit Alt-F8.
  24. Replies
    1
    Views
    2,379

    Re: string too long (formfields)

    OK, I found the workaround with a bit of digging on google. Answer here.
  25. Replies
    1
    Views
    2,379

    [RESOLVED]string too long (formfields)

    I'm writing a VBA macro to deal with formfields in Word Documents.
    I need to extract the text from them, translate that and replace the text in the document.
    The first part is fine, I can extract...
  26. Replies
    4
    Views
    243

    Re: Error on French Win2000

    Try changing the regional settings to UK/US. Things like Wild card searches always screw up when I use Dutch RS.
  27. Replies
    1
    Views
    246

    regexp help for a tag

    I'm having trouble formulating a regular expression in a search (in Word VBA) to look for either an opening tag or a closing tag. I can get it to work for one or other but not both.

    I want it to...
  28. Replies
    7
    Views
    387

    Re: Parsing The Path {RESOLVED}

    How would one adapt this so as to extract other parts of the path?
    If I wanted to pull folder1 and folder3 from the above path and assign them to string variables, can InStrRev be used to find not...
  29. Re: Style issues when merging the word documents

    This might work either.


    For Each sStyle In ActiveDocument.Styles
    Application.OrganizerRename _
    Source:=ActiveDocument.Name, Name:=sStyle.Namelocal, _
    ...
  30. Re: Style issues when merging the word documents

    Maybe a macro to change the names of all the styles in Doc2 before adding them to Doc1? That way one style won't be overwritten by another.
    Something like this (to be run on doc2);

    Sub...
  31. Re: Help debug a shape removal/replacement macro?

    Oh, I should probably have gone there a long time ago! Can someone move this?
  32. Help debug a shape removal/replacement macro?

    I've written a couple of Word macros (with some help from forum members, thanks again :) ) to remove and then replace all the text from textboxes in a document.

    Step 1 - extract all text from...
  33. Re: case-insensitive string compare

    Many thanks. :)

    pete - I should get round to testing that other piece of code this afternoon, will let you know how it goes.
  34. [resolved]case-insensitive string compare

    Quickie - just looking for an existing function to compare example and eXamLe which will return true, without having to overload string.compare functions.
  35. Re: Word VB - VBA - accessing all headers and footers

    The problem I keep meeting with accessing the HeaderFooters is that the header/footer/footnote window opens in the bottom and stays stuck.


    For Each sSection In ActiveDocument.Sections
    ...
  36. Word VB - VBA - accessing all headers and footers

    I'm trying to write a VB macro for Word that goes through each header and footer in a document and performs an action (doesn't really matter what, it's the accessing headers/footers that's stumping...
  37. Re: [RESOLVED]Extracting all text-box text from Doc

    Just thought I'd update this with the working code to extract and replace textbox text, in case it's of use to anyone.
  38. Replies
    13
    Views
    2,897

    Re: BROWSEINFO or common dialog?

    Haha, thanks a million Joacim :) A picture's worth 1000 words - next time I'll just post two images: what I have and what I want to make :D
  39. Replies
    13
    Views
    2,897

    Re: BROWSEINFO or common dialog?

    I don't understand. I have no Project menu in my VB IDE, and don't know how I can add a component.
  40. Replies
    13
    Views
    2,897

    Re: BROWSEINFO or common dialog?

    Thanks for all the answers, but I'm in way over my head. I did a terrible job of trying to explain what I wanted, partially because I wasn't sure what I wanted. I'm going to read through the code in...
Results 1 to 40 of 103
Page 1 of 3 1 2 3



Featured


Click Here to Expand Forum to Full Width