dcsimg

Search:

Type: Posts; User: westconn1

Page 1 of 13 1 2 3 4

Search: Search took 0.39 seconds.

  1. Replies
    17
    Views
    295

    Re: VBA Run time error 9

    once you dimension the array with a fixed size (like 1000,3000), it is a static array and can not be redimmed

    redim the array just before you want to assign values to it


    if your object has a...
  2. Thread: xls to csv

    by westconn1
    Replies
    4
    Views
    162

    Re: xls to csv

    what exact problem are you having?, what part of the code if any does work?

    as far as i can see, the first line should fail as the constant is not the full filename, probably should be using...
  3. Replies
    11
    Views
    178

    Re: Weekday returns wrong result

    you can use the weekdayname function like



    personally, i prefer a formatted string, in most cases
  4. Replies
    3
    Views
    140

    Re: Using Excel with VB6

    probably pay to check what you write as it still has error, copy and paste from the code is good, so can see any real errors

    i had no other problem with the code you posted, but there maybe...
  5. Re: VB6 program generates 3706 Provider error with 64-bit Office 365

    so i wonder which version you can install if no office installed?
  6. Replies
    3
    Views
    140

    Re: Using Excel with VB6

    one problem i can see is you have no path separator between strdirectory and strfilename when you open the workbook

    on testing your code, after changing path an filename to suit and fixing above...
  7. Re: EXCEL VBA Help With Array & Controls Please

    as the error suggests, you have not assigned any object to C

    maybe more like

    For B = 1 To Passing_Variables.TbuttonQnty 'Start of the for Loop for the amount of Buttons
    set C = me.controls(a...
  8. Re: [RESOLVED] Import UTF-8 from CSV to Excel and specify Worksheet

    lol, i had this answer, but was too slow to post

    i had been trying to make it work just specifying column 4 to text, which according to documentation should work, but appears to be incorrect, all?...
  9. Replies
    17
    Views
    295

    Re: VBA Run time error 9

    i think my previous post covers your immediate error problem, you have to make sure the array(s) is big enough to hold all the data
    you need to redim the arrays to the size of the width and height...
  10. Replies
    17
    Views
    295

    Re: VBA Run time error 9

    you need to make sure your array is beg enough to hold all the values being assigned to it, else you need to make sure you do not try to address values outside the range of the array

    as you do not...
  11. Re: Import UTF-8 from CSV to Excel and specify Worksheet

    have you tried specified the range to text
    else you could try

    strline = "'" & replace(strline, "," , ",'")before assigning the value to column 1, this would force all values to text
    hard to say...
  12. Re: Import UTF-8 from CSV to Excel and specify Worksheet

    did you try just opening the csv file in excel (workbooks.open)? then copy the sheet into the existing workbook (sheets(1).copy) before or after whatever sheet in workbook
  13. Replies
    19
    Views
    348

    Re: i need help in coding in vb

    what does this mean?

    there is 2 errors in your workbook code
    sheet1 is actually sheets("peridot") so you are copying the rows to themselves, just different columns
    a newly added...
  14. Replies
    19
    Views
    348

    Re: i need help in coding in vb

    what is the last row of data? and what value is lastrow? do they match?
    Does peridot last row column H contain the correct value?
    with this code, if any rows do not contain the correct value in...
  15. Replies
    28
    Views
    249

    Re: VBA error

    the first part indicates that the values returned from the file would most likely be doubles, so the variables to contain them should be a double, but that you could alternatively use a variant...
  16. Replies
    28
    Views
    249

    Re: VBA error

    which parts in particular?
  17. Re: How do I get a screenshot of an entire Form, not just what is visible in the wind

    microsoft had a vb sample for printing different screen areas, but i believe the link is now gone

    i will attach the original download, you can see if it helps at all171587
  18. Replies
    28
    Views
    249

    Re: VBA error

    longs and integers can only hold whole numbers,
    looks like the values should be doubles, but variants would work too

    try to avoid double posting, it is a fault in the forum that has never been...
  19. Re: Build one list out of two with Excel VBA

    is the data always in series for the 2 sheets? or is that just in this example? and real data would be random

    maybe something like, first, before the loop, insert the additional column,range("...
  20. Re: List count whats the difference here

    if you want to find one instance (either the first or only) of a specific criteria, then when found, process then exit for, if you want to process all instances that match the criteria then you can...
  21. Re: List count whats the difference here

    if you are going to make a loop that conditionally deletes items from any collection or list then you should use the top example, for all other cases, it does not matter, but if you are using some...
  22. Re: [excel 365] autocomplete drop down that runs runs additional code based on value

    you could try moving the value change code to a non-event driven procedure, you could then call that procedure from either the worksheet_change or the worksheet_selectionchange procedures, pass...
  23. Re: Learning : How to Grab string from left or maybe right

    you can use instr to test if one of those values exist in each line, you may need to add leading and/or trailing spaces to only find whole words, eg. so 1941 does not find 1941r, if instr > 0 you can...
  24. Re: MSXML2.ServerXMLHTTP60 with TLS 1.2 support XP POSReady

    are you running either the ide or the exe elevated? that could possible account for the difference in version
  25. Re: VBA to move ppt object to a specific location

    i think that would just change the position of the slide in the presentation, you should try more like

    ActivePresentation.Slides("someslide").shapes("shapename").left = 99...
  26. Re: MSXML2.ServerXMLHTTP60 with TLS 1.2 support XP POSReady

    w10 pro

    i can test it on xp later

    edit: on testing in xp, i also got the same results for both the ide and an exe, both returned TLS1.0
  27. Replies
    8
    Views
    829

    Re: shell command help

    /k specifies to keep the command window open
  28. Replies
    2
    Views
    204

    Re: Creating a simple loop vba

    to search subfolders, you need a recursive procedure, see...
  29. Re: MSXML2.ServerXMLHTTP60 with TLS 1.2 support XP POSReady

    on testing with the sample project (no changes)

    both seemed to work the same for me in ide or compiled exe

    IDE...
  30. Replies
    8
    Views
    829

    Re: shell command help

    from the appearance of the code, you are trying to cd to a file rather than a folder, but i am not sure that is really what you want to do, if you want to just call the batch file then as you are...
  31. Re: How to determine the number of rows, columns, and size

    does it say anywhere that the number of rows and columns would be equal, unless all # of squares would have to be a square, what proportion of rows to columns, i am sure there is not enough...
  32. Replies
    9
    Views
    332

    Re: File extended attributes

    you should be getting this information before or when the files are uploaded, once they are uploaded the information is no longer retained with the file

    depending on the method used to upload the...
  33. Replies
    9
    Views
    332

    Re: File extended attributes

    microsoft shell controls and automation

    or browse for c:\windows\syswow64\shell32.dll
    but i have never not seen it in the list of available references
  34. Replies
    9
    Views
    332

    Re: File extended attributes

    while shell automation will get some additional attributes from file in a folder, it would be the folder they currently reside in, i doubt there is any property that will indicate the original user...
  35. Replies
    8
    Views
    332

    Re: View code for user form

    even vb6 forms don't have code till you put some, but as with vba userforms there are event procedures that, will appear as soon as you click on them in the drop down, the you can put the code you...
  36. Re: Focusing a running program discriminated by its caption

    did you try appactivate?
  37. Replies
    8
    Views
    332

    Re: View code for user form

    a data entry form does not have any code
    you would need to work with a userform, but even then there really isn't any code till you put some in
  38. Replies
    8
    Views
    332

    Re: View code for user form

    i am not sure that a dataform is the same as a userform, i would believe that it is just another view of the work sheet to aid data editing

    also i found this and thought i should add a warning here
  39. Replies
    8
    Views
    332

    Re: View code for user form

    developer tab > View code

    or alt F11 (left alt only)
  40. Re: How do i remove all know space from string

    those character probably indicate a unicode character, that can not be displayed, while they do not display correctly they may be a required part of the string
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width