Search:

Type: Posts; User: westconn1

Page 1 of 13 1 2 3 4

Search: Search took 3.70 seconds.

  1. Replies
    3
    Views
    72

    Re: append csv into closed workbook

    you have to open the workbook, one way or another
  2. Re: Is there anyway to build x64 exe by vb6ís compiler?

    is anyone who does not speak /read chinese testing the fvb?
  3. Replies
    7
    Views
    180

    Re: ado connection with password

    ask the user (fill in textbox or whatever), then change the login to suit
  4. Replies
    1
    Views
    301

    MsOf365 Re: Outlook Form Content Blank

    if you want to post the form (zip first and attach to post), i will see if i can find the problem
  5. Re: How to auto increment cell value after printing results on each cell VB Excel?

    i am not sure what the printing part in the title refers to

    i can not see from the images how the data is supposed to be related to the order point for each item, i would suggest that a sample...
  6. Replies
    18
    Views
    495

    Re: Upgrade to Windows 10

    there are several threads about installing vb6 on win 10, pay to read some of them, as a bit pf trickery to the install correctly
  7. MsOf365 Re: VBA Access Form - Open For Print Preview Only - Do not show form after print

    did you try closing the form as the next line of code?
  8. Replies
    4
    Views
    326

    Re: Excel VBA - Transpose???

    you mean like

    a = Range("a1:a7")
    Debug.Print Join(WorksheetFunction.Transpose(a), " ")where a is a variant
  9. Replies
    4
    Views
    180

    Re: Import from Excel into Access' table with VB6

    while you and some others may disagree, the policy of this forum would encourage to make a new thread, with links to any previous thread that is relevant, this is up to the moderators to decide
    ...
  10. Replies
    20
    Views
    784

    Re: Paste value special

    you can try to copy the column widths first
    like

    With w
    lr = .Cells(Rows.Count, 1).End(xlUp).Row
    lc = .Cells(1, Columns.Count).End(xlToLeft).Column
    .Cells(1, 1).Resize(lr, lc).Copy...
  11. Replies
    20
    Views
    784

    Re: Paste value special

    based on your sample workbook, I have made some changes to the original code that appears to work correctly
    the saved file appears to have the original formatting, no formulas and size of 29kb

    ...
  12. Re: How to add the value of multi-selected list box vba

    split is supported from excel 2000, but i would suspect that it is a multi column list box, so not required
  13. Re: How to add the value of multi-selected list box vba

    & concatenates the values as you msgbox, you need to add them so use +


    textbox1 = GetSelectedItemsGetSelectedItems should return some value type (integer, long or double) rather than a string,...
  14. Re: adapt vb code to be used with microsoft excel vba

    you can use a lot of vba code in vb6, you should avoid using active anything, selecting or selection object. all ranges should be fully qualified to a application.workbook.worksheet object
    like
    ...
  15. Replies
    20
    Views
    784

    Re: Paste value special

    i think the only way you can achieve the desired result is to copy the worksheet rather than the range, but i seem to remember you had some issue with that too

    you should test to see if you can...
  16. Replies
    20
    Views
    784

    Re: Paste value special

    i think the only way you can achieve the desired result is to copy the worksheet rather than the range, but i seem to remember you had some issue with that too

    you should test to see if you can...
  17. Replies
    6
    Views
    308

    Re: Splitting a Multidimensional Array

    also L by the looks of it
  18. Replies
    6
    Views
    308

    Re: Splitting a Multidimensional Array

    from help, if i am looking at the code correctly, i can see why you wold get a type mismatch
  19. MsOf365 Re: How to open "Save print output as" -window having a file name from variable? MS W

    you can use like

    savfol = CreateObject("shell.application").browseforfolder(0, "Select FOLDER to save to", &H4001, "").self.Path
    strDocName = Replace(strDocName, Chr(32), "")...
  20. Re: querytable.refresh fails and error handling (alternatives?)

    ActiveWorkbook.Queries.Add Name:="Table 1", Formula:= _
    "let" & Chr(13) & "" & Chr(10) & " Bron = Web.Page(Web.Contents(""" & Ticker_link & """))," & Chr(13) & "" & Chr(10) & " Data1 =...
  21. Replies
    20
    Views
    784

    Re: Paste value special

    isn't that a duplicate of post #8, answer in post #11

    did you try as suggested post #10? it does work without error and probably give the desired results
    if you also need to paste the column...
  22. Replies
    7
    Views
    420

    Re: Add permanent string of data to EXE?

    a downside to unique exe files, if you want to be able to do updates to your program
  23. Replies
    1
    Views
    175

    MsOf365 Re: VBA Access Form - Saving Blank Records

    have a look to see if there is any validation event for the text fields, so any that can't be blank prevent saving
  24. Replies
    20
    Views
    784

    Re: Paste value special

    the second will overwrite the first
  25. Re: How to get access field dataformat using ado

    is the field actually a text field or a date type?
  26. Re: Edit conundrum on RTB. Should be simple

    you could test in the form unload event
  27. MsOf365 Re: How to open "Save print output as" -window having a file name from variable? MS W

    show a browseforfolder dialog, or a folderpicker dialog if available
  28. Replies
    6
    Views
    308

    Re: Splitting a Multidimensional Array

    without seeing any code it is a bit difficult to tell, but if the 2d array is a single column values, you can use worksheetfunction.transpose of the array twice to return a single dimension array ...
  29. Replies
    6
    Views
    458

    Re: VBA dynamic table

    you should specify a specific cell rather than activecell, also you need to fully qualify the textbox, to which sheet or form it is on
  30. Replies
    20
    Views
    784

    Re: Paste value special

    that should work, use OR to combine them
  31. Re: Current Recordset does not support updating. This may be a limitation of the prov

    the two 3 parameters at the end are the cursor and locking vales of the recordset, try searching on the appropriate values for read/write recordsets

    you may also need some extended properties like...
  32. Re: Edit conundrum on RTB. Should be simple

    you could have a variable with the opening content, that you can compare with the closing content
  33. Re: [RESOLVED] Vb6 elapsed time in days hours minutes

    of course, as you are converting the double to integer no time part will be kept
  34. Re: Vb6 elapsed time in days hours minutes

    we try not to do that here, we try to help you learn

    you have to integer divide seconds by 60 to get minutes, and minutes by 60 to get hours, keep the remainders from each division for the minutes...
  35. Replies
    20
    Views
    784

    Re: Paste value special

    you can try


    Set b = Workbooks.Add
    w.usedrange.copy
    b.sheets(1).range("a1").PasteSpecial xlPasteValues
    myfile = mypath & Format(Date, "MMM") & " PM Template.xlsx"
    myfile = mypath &...
  36. Replies
    6
    Views
    458

    Re: VBA dynamic table

    you can try like

    Set t = ActiveSheet.ListObjects.Add(xlSrcRange, ActiveCell.Resize(, textbox1), , xlNo)t will return a listobject object variable
  37. Replies
    1
    Views
    199

    Re: Display folderes - Too Small

    the pickfolder is an application dialog, to change its size you would have to subclass the dialog box, which would be fairly intensive to code
    i do note that i can see just about all my outlook...
  38. Replies
    6
    Views
    458

    Re: VBA dynamic table

    yes i am sure it is possible

    what sort of a table?
    which application?
    table in a word document?
    database table in access?
  39. Replies
    4
    Views
    315

    Re: How To Cange Array Type ?

    why would you expect it to be different? you are changing its type, not its value

    s = CLng(24581)
    Debug.Print s;
    Debug.Print TypeName(s)
    s = CSng(s)
    Debug.Print s;
    Debug.Print TypeName(s)
  40. Re: shellexecute versus opening from explorer

    @elroy, no compatibility shims at all, just compile and run

    i get the same issue running from shell, .bat, .cmd, wscript.run
    when the calling program closes then the called program runs, it is...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width