I am looking for a way of protecting the workbooks with VBA code. The case is: the student downloads a spreadsheet from a website (WooCommerce) and is able to run it on only one computer with no possibility to send…
I'm trying to send a local photo using VBA or VBScript. The solutions I found are either for sending URLs instead of files, or for other than VBA or VBScript. Sub TelegramAuto() Dim ws As Worksheet Set ws = Sheets("hidden")…
I need to pull the sku (CS060120) from this section of html (edit:) Using VBA tried getAttribute and getElementsbyTag(and Class)Name but I am not able to get the return I am looking for. Anyone know how to do this? <section…
The suite is triggered by a button on Sheet1 of DrillDown.xlsm. The suite uses the following workbooks: wbIn, wbOut, wbTarget. The contents of wbIn are used to identify which workbook file should be opened as wbTarget. The relevant rows are…
I have a VBA file that has been working for years with a POST to API function to create products on Shopify. It has suddenly and for non identified reason stopped working around April 15th 2019. It gives the following…
I'm try to select "max(TxnDate) as txDate, [account name dr], [credit usd]" and I got an error "query does not include the specified expression 'credit usd' as part of an aggregate function" in excel VBA programming but in work find…
I'm trying a VBScript that should open Excel, open a workbook, run a macro and then close everything. Dim objExcel, xlBook Set objExcel = CreateObject("Excel.Application") Set xlBook = objExcel.Workbooks.Open ("path to the xlsm file") objExcel.Visible = True objExcel.Run xlBook.name &…
I have an inventory list which has contains 1000 product with zero pictures, and a sheet which have 300 links of the product pictures in excel, I'm looking for a way to combine the two sheets, so that each product…
I've put together a table to track the success of some SEO efforts. For each row I'd like to compare the starting value with the most recent value. We update this table each week, so it'd be great if it…
I am new to using XML with VBA and I am trying to parse XML responses form the eBay API such as this: <?xml version="1.0"?> <GetSingleItemResponse xmlns="urn:ebay:apis:eBLBaseComponents"> <Timestamp>2016-07-04T06:24:28.969Z</Timestamp> <Ack>Success</Ack> <Build>E963_CORE_APILW_17911290_R1</Build> <Version>963</Version> <Item> <ItemID>232001428891</ItemID> <EndTime>2016-07-13T22:06:14.000Z</EndTime> <ViewItemURLForNaturalSearch>http://www.ebay.com/itm/WW2-Australian-P37-Entrenching-Tool-Cover-/232001428891</ViewItemURLForNaturalSearch> <ListingType>Chinese</ListingType> <Location>Pambula, New South Wales</Location>…