dcsimg

Search:

Type: Posts; User: el84

Page 1 of 13 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    22
    Views
    281

    Re: Creating new Excel spreadsheet using Vb6

    Thanks. Brilliant! And for example merge range ? Also adding a range (ie @ sum) and repeating a cell (+ a1) Trying out all this stuff now. If anyone can point me at a reference for all this I will...
  2. Replies
    22
    Views
    281

    Re: Creating new Excel spreadsheet using Vb6

    Oh, the other way round then... Normally in xl its A1
  3. Replies
    22
    Views
    281

    Re: Creating new Excel spreadsheet using Vb6

    Thanks all. Getting somewhere. Quick question: I've got Cells(1,1) working but I would like to use Cells(A,1).
  4. Replies
    22
    Views
    281

    Re: Creating new Excel spreadsheet using Vb6

    Yes. Ignorance!
  5. Replies
    22
    Views
    281

    Re: Creating new Excel spreadsheet using Vb6

    Thanks. I hope this does not get moved because most of the replies in other groups seem to assume I am using that dratted 'Net' thing. Further confusion! Thanks for the double posting tip!

    (re...
  6. Replies
    22
    Views
    281

    Re: Creating new Excel spreadsheet using Vb6

    Dupe again. After posting I always get 'You are posting too quickly. Post again in 29 seconds'! I sure like to get rid of that irritation!
  7. Replies
    22
    Views
    281

    Re: Creating new Excel spreadsheet using Vb6

    In answer to your specific questions La Volpe
    Only one worksheet per workbook.
    Creating on the fly using column and row headers from Vb6 strings and figures from Vb6 variables.
    Yes, need to open...
  8. Replies
    22
    Views
    281

    Re: Creating new Excel spreadsheet using Vb6

    Sorry! I didn't mean to repeat that post! I got the message that I was posting too quickly and to try again. Thanks for your super-rapid response La Volpe. I've had a look at the Office section and...
  9. Replies
    22
    Views
    281

    Re: Creating new Excel spreadsheet using Vb6

    I have got as far as adding a reference to Microsoft Excel 15 Object Library. Here is my code so far


    'Exceltest
    'Project > References > Microsoft Excel n Object Library
    Dim excelApp As...
  10. Replies
    22
    Views
    281

    Re: Creating new Excel spreadsheet using Vb6

    I have got as far as adding a reference to Microsoft Excel 15 Object Library. Her is my code so far


    'Exceltest
    'Project > References > Microsoft Excel n Object Library
    Dim excelApp As...
  11. Replies
    22
    Views
    281

    Creating new Excel spreadsheet using Vb6

    I would like to do as the title says, simply. I have studied many previous posts on this and am thoroughly confused.
  12. Re: Copying section with pics and header to start of new document

    Pete

    We have visitors from overseas for about a month, and I will probably have to defer any further experiments until after they've been! Apologies in advance if I fail to respond to further...
  13. Re: Copying section with pics and header to start of new document

    No go. Tried after 6 (need for HOY as well as HOYQ). All other settings lost (inc single linespacing, removal of page breaks and all other stuff which had been working). Also headers do not propagate...
  14. Re: Copying section with pics and header to start of new document

    Funnily enough that is where that was originally put, but it was when I was still trying to move just a string. I'll try again, assuming I do have that replacement code as you intended.
  15. Re: Copying section with pics and header to start of new document

    OK Pete. Thanks for trying. I know the facing page (Head) will be the first one, so I imagine that must be primary. Certainly not even as 1 is odd! I'll go on experimenting. Meanwhile does it look as...
  16. Re: Copying section with pics and header to start of new document

    Might be a good idea so to summarise all the stuff my program does (or should do).

    In order of code
    1 Sets 3 instances of Word Documents (an ORIG doc containing some exam questions), a NEW doc...
  17. Re: Copying section with pics and header to start of new document

    Thanks for the code. Do you want me to move to that forum and continue the discussion with you? Meanwhile, this is how I incorporated your code into what I have. This is in place of #1

    ...
  18. Re: Copying section with pics and header to start of new document

    Hello Pete. You are glutton for punishment responding to me again! Can't send you the live docx, but imagine any Word docx one page document containing a header, some centralised text and a couple...
  19. Copying section with pics and header to start of new document

    I fear at last I may have come across something that cannot be done with Word automation! In this snippet of code, oWrdDocHead already refers to one file that contains a few pics, some text and a...
  20. Replies
    24
    Views
    663

    Re: Word automation via VB6, wildcards

    Many thanks for all your work. I've got this going well. I'll mark the thread closed! See you next time!
  21. Replies
    24
    Views
    663

    Re: Word automation via VB6, wildcards

    All # 18? Even the dims?
  22. Replies
    24
    Views
    663

    Re: Word automation via VB6, wildcards

    OK. My head is spinning right now. The problem is that I am working with a program that opens 3 word files. After every crash I need to go into task master and stop every Winword process. I then need...
  23. Replies
    24
    Views
    663

    Re: Word automation via VB6, wildcards

    Sorry! 'All that code'... Where from and where to? If you've got time Id like to know how those work, line by line (don't ask for much, do I?)
  24. Replies
    24
    Views
    663

    Re: Word automation via VB6, wildcards

    Bit nervous of changing as I am not completely clear which parts to keep and which to change. Also the second qualification you suggested does not seem to work (be an option). Working code is

    Dim...
  25. Replies
    24
    Views
    663

    Re: Word automation via VB6, wildcards

    On my actual source document, there is a carriage return and line feed after (eg) 'p199' Re simplified, do you mean instead of the whole code? (!)
  26. Replies
    24
    Views
    663

    Re: Word automation via VB6, wildcards

    Update 2 and summary !

    Fumbling about in the dark, I've hit on this, and it seems to work! Is this a fluke, lurking ready to pounce Or have I got it?:


    f = Left(Selection.Text,...
  27. Replies
    24
    Views
    663

    Re: Word automation via VB6, wildcards

    !!! See post #14 for update and summary!!!

    Update! I have modified the code thus


    Dim s As Range
    Dim f As String '###?
    Dim pos As Integer '###?
    Set s = Selection.Range
    With...
  28. Replies
    24
    Views
    663

    Re: Word automation via VB6, wildcards

    !!! See post #14 for update and summary!!!


    Update! I have modified the code thus


    Dim s As Range
    Dim f As String '###?
    Dim pos As Integer '###?
    Set s = Selection.Range
  29. Replies
    24
    Views
    663

    Re: Word automation via VB6, wildcards

    !!! See post #14 for update and summary!!!

    Apologies and thanks for bearing with me! I have now retried the code in post #6. I had to Dim two variables: f As String and Pos As Integer. Was that...
  30. Replies
    24
    Views
    663

    Re: Word automation via VB6, wildcards

    I'm a bit puzzled here. Did you post a much longer routine and then remove it? If so, I wonder why. I've modelled my attempt to trap p1 to p199 and substitute a test word Later a blank) on it.
    Now...
  31. Replies
    24
    Views
    663

    Re: Word automation via VB6, wildcards

    Yes, I'll work on that next. Just finished curry and some red wine...
  32. Replies
    24
    Views
    663

    Re: Word automation via VB6, wildcards

    Couldn't resist trying it before going back to bed. It worked first time with no conversion at all! Thanks again!

    Now I've noticed that another routine of mine does not work.
    This one is meant...
  33. Replies
    24
    Views
    663

    Re: Word automation via VB6, wildcards

    Couldn't resist trying it before going back to bed. It worked first time with no conversion at all! Thanks again!

    Now I've noticed that another routine of mine does now work.
    This one searches...
  34. Replies
    24
    Views
    663

    Re: Word automation via VB6, wildcards

    Many thanks for this. It is now about 2:30 in the morning here in Australia and I've just got up briefly. I'll try this later when I properly get up! With my present state of knowledge I'm not sure I...
  35. Replies
    24
    Views
    663

    [RESOLVED] Word automation via VB6, wildcards

    Here's another curly one. I am looking to search a whole document and locate any part of the text that has a number followed by a letter (A-D) and a line feed. I want to null out the letter. I don't...
  36. Re: Removing all page breaks from a Word document

    I abandoned the tilde idea. My optional sections are now divided by continuous section breaks, and after setting thus


    Set oWrdDocNew = oWrdApp.Documents.Add(aPath & "HOY.docx")

    (that's the...
  37. Re: Removing all page breaks from a Word document

    Instinctively I don't believe anything with Word is impossible with Vb6. Probably it would help if I explained the context. In my program I am selecting pieces of one document and assembling them...
  38. [RESOLVED] Removing all page breaks from a Word document

    I am trying to remove all page breaks from a Word document named 'HOY'

    I already added a reference to Microsoft 15 Word Object Library (I am running Word 2013). aPath is the path to the folder...
  39. Re: Stuck on slecting the entire document using Word automation

    Thanks Sam

    Too expensive for me I'm afraid!
  40. Re: Stuck on slecting the entire document using Word automation

    Arnoutdv, thanks. I actually understood your explanation! Before the routine we are discussing I also have a line that copies one file to another (using File System Object). Possibly because of that...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width