pos

Who can help me, please? I'm getting crazy as the code underneath sometimes works and sometimes doesn't. I haven't got a clue when it is working and when it doensn't ... Function pbnInternet(Condition) Dim objIE As Object, ele As Object Dim pos As Integer Set objIE =...

Hi, I have a VBA code that imports values from other .csv files. I make use of "Offset" to skip the first row in each target file (column headers) and have the titles hard coded in my destination sheet. Problem is: when the entire code runs it automatially deletes all column headers. I...

Hi All I'm currently working on some vba and encountering a issue that I can't find a answer or solution for I have within a workbook several tabs The tabs in Questions are Open POs and PO Orders My code is as follows Sub CopyData() Dim LR As Long, ALR As Long Dim MSht As String, DSht As...

Hello, I'm working in a Datavision Pivot table - not sure if that makes a difference. I'm trying to change my pivot table date based on a cell value but I can't seem to find any code that works. Keep getting a runtime error 1004 "unable to get the pivotfields property of the pivotTable Class"...

Hi, I've got a silly error here and can't think how to fix it. I have the following code that splits a text string for me based on the first space and offsets the string into the adjacent columns, that's all fine. However rather than looping through each cell in my range, it offsets the same...

I have a datasheet with duplicates values in single cell. I would like to delete them using Macro. Example: <tbody> <tbody> 108,125,98,90,113,64,89,71;61,38,57,53,51,30,39;29,25,19,7,5,61,38,57,53,51,30,39,29,25,19,7,5,61,38,57,53,51,30,39,29,25,19,7,5;61,38,57,53,51,30,39;29,25,19,7,5...

I would like to return the date ranges for which products were substituted but I'm having difficulty with the filters. I have a "sub" flag in my Orders table that indicates if a product was substituted (the product ID is different than that in our item master file). I have a calendar table...

Hello, I'm running a round robin tournament with following table: <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <tbody> Group A 1 2 3 4 5 6 7 8 MW ML FW FL FD FA POS 1 Player 1 0 2 1 0 2 2 2 4 3 9 8 1 0.53 4 2 Player 2 2 2 2 2 2 1...

<!--[if gte mso 9]><xml> <o:DocumentProperties> <o:Version>12.00</o:Version> </o:DocumentProperties> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...

Hello - can anyone point me in the direction of an off-the-shelf Excel solution for creating sales orders? I can't find a suitable Point of Sale system for my business and at present we do everything in Excel. The problem (and indeed beauty of Excel) is that there is too much scope for the...