Wanted to change the value in an MSAccess-field, but despite that no error message shows up, this minimum task does not do the job. Any idea anybody? Let>constr=provider=Microsoft.Jet.OLEDB.4.0;Data Source=DARP_DB.mdb DBConnect>constr,dbH UPDATE tblbuchdaten SET DataSelected = REPLACE(DataSelected,"...

Ok, these questions already help a bit. Well, I am using the latest MS version. And yes, I am running it inside a greater VBS script, using VBRUN. [snippet=] VBSTART Function GetData(Quantity,Sonderangebot) Const ForReading = 1, ForWriting = 2, ForAppending = 8 Dim SQLString Dim Value Dim TextLine D...

Tried to figure it out myself, but it shows the same behaviour.

Once I run it in the MS editor it complains about the line

function max(a,b)

Calling it a syntax error ...

Next, I do not get, why the line is commented, which should transport the data from db to csv?
Hints appreciated ...

Exporting from Access via VBS works well, now I need to modify a value. A currency field "price" is to exported not as is, but risen to a minimum. So, if usually I would have to export 0,01, I want this to become at least "3", if it is "3" or higher already, leave it untouched. I came up with this: ...

Wanted to pick data from a website comparing prices - this may be quick or dead slow. // Extract pricing and forum of top result // Used the IE Element Wizard to extract data here IEGetTagsByAttrib>{"http://www.recyclingmonster.de/verkaufen/buecher"},SPAN,,T,valueArray //top result is valuearray_1 L...

I reworked the code for a different website, that ought to work now. This is my first attempt to transfer data from a list into web forms and it works all right so far. //if the xlsx file is not in the same folder as the script, modify the path in this line: Let>XLSPath=%SCRIPT_DIR%\test.xls //Start...

Ok, I take it that my planning was no good. Now I access the db directly and have parts of the mosaik, where I want to go to. That is meant for price comparison (oh, what a brand new idea ...) I already have another working script to extract data from the db, thus I just copied myself the first part...

Well, I used the wonderful IE Element Wizard to extract text from an ID: results_avg_price - but it inserts code containing the website address including that specific item, where I had expected it to grab only the value presented in that ID. Reading the comment, one can define where the text would ...

Thanks for the first hint, that is a neat help! About the database: Actually the data comes out of an Access database, I had started with csv, since that was easy to follow ... I am still a beginner with this. :oops: So, that rewrites the last question: Would there be an example, a beginner could fo...

Hi, for once I have a somewhat unspecific question: I do manage to send data from a csv file to a website (thanks for the xltowebform how-to-zip in the support section). And it works to send content from different columns or rows to different fields. But now, I would like to pull the desired data ou...

And that solved it all ...

That is because I had excluded the text lines on top. So these are the lines it complains about, if I try to run it in the editor, but it works fine, once it is compiled.

Let>x={Round(%x%)}
Let>y={Round(%y%)}

So, problem solved.

This is the complete code, in here it complains about line 21 and 22. Invalid parameters to round. But shouldn`t it have all? Let>ImageFile=test.jpg Dialog>ImageSizeDialog object ImageSizeDialog: TForm object MSImage1: tMSImage AutoSize = True end end EndDialog>ImageSizeDialog SetDialogProperty>Imag...

Sorry to return so late - no nothing works.

Even in your example it complains about line 11 and invalid parameters.

I am lost ....

I am not making progress on this one, maybe my explanation was too fuzzy. http://www.zeitenwanderer.de/images/cut.jpg As one can see, these pictures are not always neat and straight and there might be a shadow in the corner. Instead of making them transparent in the beginning, I left them on the ori...