Search:

Type: Posts; User: incidentals

Page 1 of 13 1 2 3 4

Search: Search took 0.09 seconds.

  1. Replies
    13
    Views
    2,203

    Re: News for VB.NET!!!

    looking at the announcement it looks like its simply a separately names space that he suggested working in to protect your original workspace.

    He set it when opening the IDE and was able to use it...
  2. Replies
    2
    Views
    793

    Re: Avaya CMS VB Scripting

    would be nice to see an example how you see avaya information file or otherwise - Its just that anumber of people have been talking about these recently.

    Just thinking out loud
  3. VS 2022 Re: Delete files with the same ending

    match with the last 9 characters of the name or 13 of whole name with ext

    like

    if right(filename,9)="_univ_sqr.jpg" then deletefile(filename)

    assuming that you have a deletefile() function...
  4. Replies
    5
    Views
    1,000

    Re: Counting and finding years

    how many months does the main sheet hold - for sanity purposes?

    you could trigger the archival process when you enter the month xmonths since first month mentioned...

    The process would end up...
  5. VS 2022 Re: Delete folder content or file only

    you could build a batch file and then shell the batch file.

    using file deletion and directory deletion commands

    RMDIR [/S] [/Q] [drive:]path
    RD [/S] [/Q] [drive:]path

    /S Removes...
  6. Replies
    5
    Views
    1,000

    Re: Counting and finding years

    (1) why are you only sending the first month to another different sheet? - why are you not sending all of the months to other sheets?

    you could simply run down the sheet outputting each line to...
  7. Replies
    17
    Views
    1,689

    Re: Inster missing timedata

    you can also abandon the spreadsheet...

    save data as csv

    process the csv adding column 1 value <comma> column 2 value <return>

    simply read the first line in and pass it out to new file,...
  8. Replies
    17
    Views
    1,689

    Re: Inster missing timedata

    for fun try...
    open second sheet and fill it with this row is 1 minute more than the last

    =above+1/24/60
    where above is the cell directly above

    in the second column put a vlookup that looks...
  9. Replies
    17
    Views
    1,689

    Re: Inster missing timedata

    why not fill a sheet with appropriate cells and then find your data within in the sheet and fill column?

    hope that makes sense
  10. Replies
    25
    Views
    7,438

    Re: How to read data from html ?

    I have obviously been messing in too many languages over the 40years.

    I still find the vb cumbersome and clumbsy to read, compared to other languages.

    PYTHON OFFERS A NICE CLEAR APPROACH AND...
  11. Replies
    25
    Views
    7,438

    Re: How to read data from html ?

    nice piece of work here, but the complexity is why I like to use python and beautifulsoup.
  12. Replies
    25
    Views
    7,438

    Re: How to read data from html ?

    first bits done for this project oonly not general solution!

    def texter(t):
    return(t.text)


    # import libraries
    from bs4 import BeautifulSoup

    output =[]
  13. Replies
    25
    Views
    7,438

    Re: How to read data from html ?

    Thats the system up again...

    here is some code to explain why its easy to use python for the decode part.

    # import libraries
    from bs4 import BeautifulSoup

    doc =...
  14. Replies
    25
    Views
    7,438

    Re: How to read data from html ?

    I would honour you with an example, but, I say this in all honesty!

    My F***ing machine has now, and I mean, just now decided it cannot save the scripts from idle to my system so that I can run it...
  15. Replies
    25
    Views
    7,438

    Re: How to read data from html ?

    I am going to have to talk about the op and olafs comments together.

    op ... you can read the file into your program line by line or as a block
    you need to walk through the block to...
  16. Replies
    25
    Views
    7,438

    Re: How to read data from html ?

    have you ever written python or used the beautifulsoup module?
  17. Replies
    25
    Views
    7,438

    Re: How to read data from html ?

    identify where the data is held and read past all of the stuff befor that point then collect all of the data stuff until end of this data and dump the file.
    then walk through the data collecting and...
  18. Replies
    25
    Views
    7,438

    Re: How to read data from html ?

    who is Olaf?
  19. Replies
    25
    Views
    7,438

    Re: How to read data from html ?

    you could forego all of the fancy stuff and just read the file in as a chunk and chop out the rubbish leaving only the pieces you wish to process... as long as your data is of a fixed and regular...
  20. Replies
    3
    Views
    729

    Re: Generate .txt file

    as always you need to ask a more defined question, possibly with example record attached for a proper answer.
  21. Replies
    4
    Views
    2,263

    Re: Need Help For Creating Online Donation

    PayPal have this all covered Go look at merchant tools like I suggested.
  22. Replies
    4
    Views
    2,263

    Re: Need Help For Creating Online Donation

    enroll as a merchant with pay pal and use the toolset to create donation buttons store the client data and "Bobs your uncle" all documentation supplied by PayPal
  23. Replies
    11
    Views
    8,940

    Re: Removing information from a string? VB6

    the process of modifying a thing that comes in is to output the modification

    whether the change is made to a line in a file or a placeholder in memory the approach is the same

    the op needs to...
  24. Replies
    11
    Views
    8,940

    Re: Removing information from a string? VB6

    op does not need to think about errant lines he states all lines are the same structure

    so read a,b

    will resolve the number with the decimal is b

    so format$(b,"###.0000") would be fine
    ...
  25. Replies
    11
    Views
    8,940

    Re: Removing information from a string? VB6

    oops i thought you wanted all of the data - any way the process it the same just amend the output


    you can read the lines in as varA and varB

    and output varA and varB with separator=space
    ...
  26. Re: [Word] - Run macro when printing merged documents

    the empty cells are in the data before merging or a result of merging?

    ie can you fix the table before merging begins and have a cleaner merge if the problem is "pre merge"

    here to help
  27. Replies
    4
    Views
    1,870

    Re: Userform_Initialize problem

    you have formed a mutually exclusive zone often termed mutex where the control of what is happening is managed to prevent unexpected/expected but unwanted interactions

    a common way to do exactly...
  28. Replies
    10
    Views
    1,582

    Re: Permission denied

    add debug.print or a msgbox and use it to expose the app.path so you can see where the stuff wants to go

    here to help
  29. Replies
    10
    Views
    1,582

    Re: Permission denied

    where exactly are you copying to?

    some destinations are prohibited like C:\ for example as the root is where important stuff is kept

    here to help
  30. Replies
    3
    Views
    725

    Re: VBA for Migrating Excel DataTables

    I would need to see the format of the data to really help

    you can generate a new format that includes all formats and juts use the parts that are stable for the data conversion.

    you should try...
  31. Replies
    4
    Views
    1,870

    Re: Userform_Initialize problem

    try triggering the change with another control or with the last control in the sequence.

    I have a form that must update when the user needs it to so i have a change control that when changed calls...
  32. Replies
    22
    Views
    3,240

    Re: Going from VBA to Visual Studio 2015 --

    can i see the form and some data if thats ok?

    here to help
  33. Replies
    22
    Views
    3,240

    Re: Going from VBA to Visual Studio 2015 --

    the first part works fine and I added a wee test to show the selection of "b2"


    Excel.range("b2").Select()

    nothing but the file placement changed from d:\test.xlsx to c:\test\test.xlsx
    ...
  34. MsOf13 Re: Delete fields that were not modified

    the bullet points will be part of the document layout and they must be seeing the carriage returns of line feeds left by your process

    we would need to see a little more code to help


    here to...
  35. Re: Need help converting code for use with CSV to Excel file

    CSV - comma separated values - a comma appears between entries in this file

    you could use tabs or any other separator if you push the format your way

    simplest capture from csv to excel is...
  36. MsOf13 Re: Delete fields that were not modified

    do you email all 20 bits to each email recipient or is each bit for a different email?

    here to help
  37. Re: To display 'False' in column B for excel vba

    I think your explanation is muddying the problem

    you have not said what the columns/fields hold and simply saying c and d and now a does not help us to understand your needs

    words like unique...
  38. Replies
    21
    Views
    1,954

    Re: [RESOLVED] ADDITION in TEXTBOX

    there you go a proper combined solution...

    well done us!

    now do not forget to rate the replies that helped and close the thread ( mark as resolved )

    here to help
  39. Replies
    21
    Views
    1,954

    Re: ADDITION in TEXTBOX

    use the cstr version of the code i put underneath

    the text wants a string maybe

    here to help
  40. Replies
    21
    Views
    1,954

    Re: ADDITION in TEXTBOX

    use passels version with to overcome the differences between .net and vb


    Private Sub Text1_KeyPress(KeyAscii As Integer)
    If KeyAscii = vbKeyReturn Then
    valTotal = valTotal +...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width