I am looking for a Corel off-line code generator. I mean, to build it without using a dedicated site to import a picture.
Everything I could find on the issue is very old and none of the links work.
Is it available, in our community (or somewhere else), such a working example?
I tried transforming a code designed for Excel, I did it, but it has some problems in case of long strings, or in case of special character use. In Excel also...
Can somebody point me in the right direction?
Thanks in advance!
Maybe you could to look here
But I cannot access the site...
Can you see the page? Would it accept only a specific IPs range?
I stopped the antivirus, I do not have any restriction in Firewall...
Running Windows Diagnostic, it returns "resource (strokescribe.com) is online but isn't responding to connection attempts.". "The remote computer isn't responding to connections on port 443."
Can you connect now (in this period of tine) to the site?
My projeto Stil a live
Yes, I can.
see attached pdf
If I got it right: If you can read out from Corel the result of a formula from an Excel-sheet, you get what you want?This is pretty easy:Take care, that in your Corel document under VBA Options / References "Microsoft Excel xx.x Object Library" is checked.For this simple code it's necessary, that Excel is running and the workbook in question is open. It needs to have a sheet named 'Test' where in the 2. row and 4. column a formula shows a result.Type then the following lines:Sub TestIt()Dim W As Workbook, XlsApp As Excel.Application, CurSheet As Excel.WorksheetSet XlsApp = GetObject(, "Excel.Application")For Each W In XlsApp.Workbooks If W.Name = "Test_200503_01.XlsX" Then Set CurSheet = W.Worksheets("Test")Next WMsgBox CurSheet.Cells(2, 4).ValueEnd SubNow you should see the result!