Search:

Type: Posts; User: Tom Schreiner; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.21 seconds.

  1. Replies
    6
    Views
    104

    Re: VBA HTML parse

    It's not clear to me what you want. The items under "Customers who bought Ripen at Home Bananas also bought?"
  2. Re: Grabbing HTML data from hyperlinks in excel

    Place the following code in a standard module:




    Public Function GetCompanyInformation(Target As Range) As String
    Static request As Object
    Static doc As Object

    If request...
  3. Re: Concatenate with rows and primary key type scenario?

    I'm not too sure at all that you can do this without some code. However, depending upon the arrangement of your data, maybe a pivot table? Though it would not concatenate your classes. How is your...
  4. Re: Create a honeycomb pattern with the hexagon shape

    tes·sel·late
    /ˈtesəˌlāt/

    verb
    past tense: tessellated; past participle: tessellated


    decorate (a floor) with mosaics.

    MATHEMATICS
  5. Re: Prevent delete based on date condition

    My code example was minimal and does not account for anything beyond your code example. This will at least move in the direction of dealing with a recordset that has no records.



    If Not rs.EOF...
  6. Re: Prevent delete based on date condition

    If I have understood you correctly...




    If rs2!ExpiredDate < Date Then
    MsgBox "That class has expired and cannot be deleted."
    rs.Close
    cn.Close
    Exit Sub
  7. Re: The opposite: Delimited to formatted text

    Dongle, thank you for your kind words. :)
  8. Replies
    3
    Views
    116

    Re: VBA stops in middle of SQL routine

    Good for you. Have a nice day! :)
  9. Re: Update the imported fields with Replace function

    "UPDATE MM_Input SET MM_Input.SI_ICXX =(REPLACE(CSTR(MM_Input.SI_ICXX),"" "",""""))"

    See if that works.
  10. Re: The opposite: Delimited to formatted text

    I gave it a shot.

    https://1drv.ms/u/s!Anxrq_k7ozqailKpT0MVVr_lMywZ?e=ESAlSn


    ...we found one!



    Sub RunThis()
  11. Re: using Hyperlink function to extract Google kilometers into Excel Spreadsheet automatically

    Glad to help a little. :)
  12. Re: Moving Shapes (Arrow) with VBA, Macro, or Formula

    https://1drv.ms/u/s!Anxrq_k7ozqaik9j3_DlHlCE0qu2?e=NjVBR8Howdy. You should be able to adapt this example. If not, I'll ask you for more details.
    Example workbook: 1110650.zip ...
  13. Re: using Hyperlink function to extract Google kilometers into Excel Spreadsheet automatically

    Fox, I tried to run a query in a plain old Google search and it could not find the 2621GB. It did find the first one. I'm not sure if I am going to be able to help you out or not. The Google API...
  14. Replies
    3
    Views
    116

    Re: VBA stops in middle of SQL routine

    VBA does not return specific error info but only a general app error with ADO. I think. In any case, here is your edited procedure that might shed some light on your problem. If not, we can dig a...
  15. Re: using Hyperlink function to extract Google kilometers into Excel Spreadsheet automatically

    Fox, what is an example of a "full Origin and Destination post code" in your country?
  16. Re: using Hyperlink function to extract Google kilometers into Excel Spreadsheet automatically

    The easiest way would be to use Google's distance matrix API. https://developers.google.com/maps/documentation/distance-matrix/intro
    The cost is about $5.00 US per 1000 hits. Another way, I...
  17. Re: Remove strings or special characters from data

    Have you tried saving the pdf file as a text file and then starting from there? What is your intended final output? Give a sample of what your example document should look like when you're done...
  18. Replies
    7
    Views
    986

    Re: Access: VBA to Make a Table from a Query

    From within Access:


    CurrentDb.Execute "DROP TABLE tbl_OTD"
    CurrentDb.Execute "SELECT * INTO tbl_OTD FROM qry_OnTimeDelivery_MetricData;"


    You might want to check for the existence...
  19. Re: move to specific cells automatically after data entry

    https://1drv.ms/u/s!Anxrq_k7ozqag0-DJg3egy0EAgKR?e=oPlC0e
    Try that one and let me know.
  20. Replies
    8
    Views
    1,259

    Re: Maintenance of MS Access Back End

    Are your front ends referencing your back end by way of mapped drives? If so, try using the full network path in your linking.
  21. Re: move to specific cells automatically after data entry

    Hi again. I looked at your workbook and I'm pretty sure that I understand your process. However, I do have a question. Your data validation. Are you attempting to enforce a unique serial# within...
  22. Re: move to specific cells automatically after data entry

    Hi. The code I provided should replace your existing code though it will need some beefing up before all is said and done. As far as using your worksheet as a template, because I don't understand...
  23. Re: Save File name to a cell specific location

    Use this:


    ActiveWorkbook.SaveAs FN, xlOpenXMLWorkbookMacroEnabled
  24. Re: ADODB Insert Query - Modify to Update instead ?

    Does this table contain many records? If not, you could create an ADODB.Recordset, loop through, checking for a match of data2 in any record. If there is a match, update the record. If there is not a...
  25. Re: How to avoid clashes between variable names and built-in VBA function names

    There is no RULE that says that you cannot use a VBA function name in your code. Unless there is ambiguity as in your second example, it's not really a problem because within the scope of your...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4