dcsimg

Search:

Type: Posts; User: incidentals

Page 1 of 13 1 2 3 4

Search: Search took 0.37 seconds.

  1. Replies
    17
    Views
    997

    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,...
  2. Replies
    17
    Views
    997

    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...
  3. Replies
    17
    Views
    997

    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
  4. Replies
    25
    Views
    2,704

    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...
  5. Replies
    25
    Views
    2,704

    Re: How to read data from html ?

    nice piece of work here, but the complexity is why I like to use python and beautifulsoup.
  6. Replies
    25
    Views
    2,704

    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 =[]
  7. Replies
    25
    Views
    2,704

    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 =...
  8. Replies
    25
    Views
    2,704

    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...
  9. Replies
    25
    Views
    2,704

    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...
  10. Replies
    25
    Views
    2,704

    Re: How to read data from html ?

    have you ever written python or used the beautifulsoup module?
  11. Replies
    25
    Views
    2,704

    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...
  12. Replies
    25
    Views
    2,704

    Re: How to read data from html ?

    who is Olaf?
  13. Replies
    25
    Views
    2,704

    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...
  14. Replies
    3
    Views
    507

    Re: Generate .txt file

    as always you need to ask a more defined question, possibly with example record attached for a proper answer.
  15. Re: Need Help For Creating Online Donation

    PayPal have this all covered Go look at merchant tools like I suggested.
  16. 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
  17. Replies
    11
    Views
    3,295

    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...
  18. Replies
    11
    Views
    3,295

    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
    ...
  19. Replies
    11
    Views
    3,295

    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
    ...
  20. 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
  21. Replies
    4
    Views
    388

    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...
  22. Replies
    10
    Views
    736

    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
  23. Replies
    10
    Views
    736

    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
  24. Replies
    3
    Views
    489

    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...
  25. Replies
    4
    Views
    388

    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...
  26. Replies
    22
    Views
    1,727

    Re: Going from VBA to Visual Studio 2015 --

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

    here to help
  27. Replies
    22
    Views
    1,727

    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
    ...
  28. 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...
  29. 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...
  30. 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
  31. 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...
  32. Replies
    21
    Views
    1,020

    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
  33. Replies
    21
    Views
    1,020

    Re: ADDITION in TEXTBOX

    use the cstr version of the code i put underneath

    the text wants a string maybe

    here to help
  34. Replies
    21
    Views
    1,020

    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 +...
  35. Replies
    21
    Views
    1,020

    Re: ADDITION in TEXTBOX

    THE WHOLE PROGRAM WITHOUT ERROR HANDELING...

    given a form with textbox1 and textbox2 and nothing else the following works

    note this is in visual studio 2015 comunity edition

    I am away from...
  36. Re: Problem with scrolling a frame using mouse wheel in Excel using VBA

    The "stops will hang the application" but thats the point a small amount of pain and management for the betterment of the solution...

    I never said leave them in!

    I would remove them as the...
  37. Re: Search for a sting in text files Merge those text files

    do the changes I have suggested help?
  38. Replies
    9
    Views
    1,136

    Re: [Problem] Object collision

    surely the car is being animated that is the track and its the obstacles move across the screen once per program cycle so is that not the simplest place to put the collision test

    simply add the...
  39. Re: A question about my first move into network programming?

    have you considered python and the beautiful soup module

    it makes everything "getable" from an html perspective

    its quick and easy to learn and does a fine job scraping stuff from websites
    ...
  40. Replies
    21
    Views
    1,020

    Re: ADDITION in TEXTBOX

    is this homework?

    the answer is to use text1.change testing for the last character to be a return key and then to collect the values from text1 and simply add then to the value currently held in...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width