dcsimg

Search:

Type: Posts; User: el84

Page 1 of 13 1 2 3 4

Search: Search took 0.17 seconds.

  1. Replies
    71
    Views
    8,320

    Re: Windows August 2019 Update break VB arrays

    So far it seems that the problem is only with Variants or arrays (both?). Anything else?
  2. Re: Changing the 'recent' settings in the IDE

    OK. Got it! Thanks for persisting. Did not have to get into registry!
  3. Re: Changing the 'recent' settings in the IDE

    No go passel I'm afraid. I notice in that other thread you mention that the method discussed there involves tinkering wit the registry. No thanks! So all in all I will have to revert to clicking...
  4. Re: Changing the 'recent' settings in the IDE

    Thanks Eduardo. Re 1) that's how I do get in each time, but I'd like 'Recent' to work properly, not just in this session but next time I switch on the machine.

    Re 2) When I start up the IDE I get...
  5. Re: Changing the 'recent' settings in the IDE

    Thanks for rapid answer passel. I have the Enterprise version of vb6. Unfortunately, I just get the 'File not found' MsgBox. Clicking on OK gets me a blank screen. Clicking on 'Help' just gets me a...
  6. [RESOLVED] Changing the 'recent' settings in the IDE

    I recently developed a project and its icon appeared under 'desktop' on the desktop (although I have set the Vb6 icon properties to the path I want (\documents\vbstuff\) -- problem 1. I then...
  7. Re: Controlling what can be shown in a drive list box.

    Thanks. Yes. That is what I'm doing at the moment. If C: is chosen I generate a msgbox saying that is an invalid choice and only use fcopy if one of the others is chosen. I just though there might be...
  8. Re: Controlling what can be shown in a drive list box.

    It's not that I'm not interested; it's that I am asking how and the replies so far don't actually tell me! But thanks for your input. I shall search on.
  9. Re: Controlling what can be shown in a drive list box.

    I'm afraid as a permanent beginner, this is beyond me. Any other ideas, using the standard control?
  10. [RESOLVED] Controlling what can be shown in a drive list box.

    In an application I have had running for some years, I use a drive list box in one place to select a destination drive for backups. As arranged the listbox shows C: in the drop down list, and as my...
  11. Re: Creating new Excel spreadsheet using Vb6

    Unfortunately that did not work for me
  12. Re: Creating new Excel spreadsheet using Vb6

    I should add that I have successfully combined column and row as in this different part of my code


    Private Sub CellID(col As String, row As Integer, Capt As String)
    Dim colrow As String
    ...
  13. Re: Creating new Excel spreadsheet using Vb6

    OK. Making great progress here. Here's another challenge, thanks to many helpful fellows. Using the A1 type convention, working fine as in the last few lines of this sample, I want within the loop to...
  14. Re: Creating new Excel spreadsheet using Vb6

    Don't quite get that... Can any of my existing code be simplified and if so how do I know when to use quotes or not?
  15. Re: Creating new Excel spreadsheet using Vb6

    Thanks heaps. That works fine. I notice you do not use quotes around C5 and C6 individually. Are they perhaps not needed in my other lines?
  16. Re: Creating new Excel spreadsheet using Vb6

    Perhaps I should show you kind fellows progress to date. Everything I want so far is achieved EXCEPT summing cells, as shown in the running comments. Any suggestions for that part without changing...
  17. 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...
  18. Re: Creating new Excel spreadsheet using Vb6

    Oh, the other way round then... Normally in xl its A1
  19. 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).
  20. Re: Creating new Excel spreadsheet using Vb6

    Yes. Ignorance!
  21. 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...
  22. 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!
  23. 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...
  24. 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...
  25. 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...
  26. 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...
  27. [RESOLVED] 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.
  28. 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...
  29. 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...
  30. 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.
  31. 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...
  32. 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...
  33. 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

    ...
  34. 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...
  35. 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...
  36. Replies
    24
    Views
    872

    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!
  37. Replies
    24
    Views
    872

    Re: Word automation via VB6, wildcards

    All # 18? Even the dims?
  38. Replies
    24
    Views
    872

    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...
  39. Replies
    24
    Views
    872

    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?)
  40. Replies
    24
    Views
    872

    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...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width