Recent content by Swi

Thanks. This is very similar to the way I was thinking of trying Andrzejek. I just did not know if there was a more efficient way.

SEQ, NAME, ADDR, CSZ, VERSION 1,John1 Doe,1 Any St.,Anytown US 11111,A 2,John2 Doe,2 Any St.,Anytown US 22222,A 3,John3 Doe,3 Any St.,Anytown US 33333,B 4,John4 Doe,4 Any St.,Anytown US 44444,B 5,John5 Doe,5 Any St.Anytown US 55555,C In a quick example, I would like to return the following if...

Requirement now change so I am actually going to read it from a CSV using ADO. Ex. of CSV header - SEQ, NAME, ADDR, CSZ, VERSION Random records would be fine. Just need to work out the query. Set connCSV = New ADODB.Connection connCSV.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &...

Hi, What is the best way to select X records of a version within a database. Ex. - SEQ, NAME, ADDR, CSZ, VERSION I would like to pull X records of each unique version. There could be 2 versions to an infinite amount. Thanks.

strongm is correct. Got it working using his recommendation. Thanks 👍

If you have the code I would like to look at it. Thanks.

Hi, Is there a way to use Printer Print method to Microsoft PDF printer and save as a file without the save dialog? Thanks.

Hi, got this worked out. I needed to use the live URLs. The test ones were not working.

Hi, I was doing some testing and it seems everything is connection fine however I keep getting an 400 error that says Unable to validate HS code(s). I have used their sample on UPS but having no luck. Any ideas? Thanks. https://developer.ups.com/tag/Landed-Cost?loc=en_DK&tag=Landed-Cost...

Hi, I am using the following code to return a web service API call from the USPS. =FILTERXML(WEBSERVICE("http://production.shippingapis.com/ShippingAPI.dll?API=TrackV2&XML=%3CTrackRequest%20USERID=%22"&$E$1&"%22%3E%3CTrackID%20ID=%22"&D3&...

I truly wish I could get good names at the start... Here is a sampling of the formats. Looks like Last Name is always first. Like a government inverse but the suffix is not consistent. DOE,JOHN J DOE,JANE MARIE DOE,JOHN J III DOE JR,JOHN J OLIVER,CHARLIE DOE FAHLER,JANE

Hi, I see the following link for parsing names. https://www.experts-exchange.com/articles/1819/Parsing-Names-in-MS-Office-Visual-Basic-6-and-Visual-Basic-for-Applications.html It does a pretty good job. However, for off the wall formats like LastName,FirstName MiddleName Suffix The only...

Thanks strongm. Appreciate it. I did get it working but with something I had paid for a few years back. https://www.example-code.com/vb6/rest_form_data_upload.asp Thanks. Swi

I found this online but still no luck. BAsically it return a 200 success but if I check the responsetext it is not a response but the whole webpage of the API. Any ideas? Sub UploadFile() Dim url As String Dim filePath As String Dim fileContent As String Dim boundary As...

Hi, I have the following curl but I've never posted a CSV file to a REST API this way. I am stuck on the part shown below. Any ideas? curl --request POST "https:/xxxxxxxx.com/api/reports/upload" --header "Authorization: Bearer {YOUR_AUTH_KEY}" --header "Content-Type...