Activity Stream

Filter
Sort By Time Show
Recent Recent Popular Popular Anytime Anytime Last 24 Hours Last 24 Hours Last 7 Days Last 7 Days Last 30 Days Last 30 Days All All Photos Photos Forum Forums Articles Articles Blog Blogs
  • John Spikowski's Avatar
    Today, 00:27
    John Spikowski replied to a thread Excel COM question... in COM
    If you need a hand either e-mail me or catch me on the #AllBASIC IRC.
    58 replies | 1213 view(s)
  • Gerald Sutherland's Avatar
    Yesterday, 23:53
    Petr, You're probably right. I have tried that approach and all I get is errors, so I'm definitely not doing it right. ;-) I am a relative...
    58 replies | 1213 view(s)
  • John Spikowski's Avatar
    Yesterday, 23:45
    John Spikowski replied to a thread Excel COM question... in COM
    You should probbably join the Script BASIC forum (send an e-mail to support@scriptbasic.org) where Dave would be more helpful on a real world effort...
    58 replies | 1213 view(s)
  • John Spikowski's Avatar
    Yesterday, 23:37
    John Spikowski replied to a thread Excel COM question... in COM
    That well is known to have run dry. You should look at alternatives to expand the functionality of TB. Just saying ...
    58 replies | 1213 view(s)
  • Petr Schreiber's Avatar
    Yesterday, 22:00
    Petr Schreiber replied to a thread Excel COM question... in COM
    Hi Mike, the concept, if interesting at all, would be more from thinBasic module creation stand point. As for COM, just a little magic possible...
    58 replies | 1213 view(s)
  • Petr Schreiber's Avatar
    Yesterday, 21:52
    Petr Schreiber replied to a thread Excel COM question... in COM
    Gerald, maybe you should retrieve reference to Range itself and then you can cast something on it - like John shows in his code. So instead of...
    58 replies | 1213 view(s)
  • mike lobanovsky's Avatar
    Yesterday, 21:39
    mike lobanovsky replied to a thread Excel COM question... in COM
    Thanks for the info Petr, I hope I'll be able to grasp the concept though I'm not a PB user. TurboBasic was the last BZ product I laid my hands...
    58 replies | 1213 view(s)
  • Gerald Sutherland's Avatar
    Yesterday, 21:38
    John, That looks pretty good. ;-) I wanted to work on that and see what I could do ... but ... I can't get Script Basic to install without...
    58 replies | 1213 view(s)
  • Petr Schreiber's Avatar
    Yesterday, 21:33
    Petr Schreiber replied to a thread Excel COM question... in COM
    Hi Mike, it is much simpler. If Eros will have time to develop what I need, I will make the module most probably available at GitHub. It is...
    58 replies | 1213 view(s)
  • mike lobanovsky's Avatar
    Yesterday, 21:28
    mike lobanovsky replied to a thread Excel COM question... in COM
    Petr, Dim xApp As Excel_Application Is your new COM methodology trying to read TLB's (type libraries) or does it use simple include files to...
    58 replies | 1213 view(s)
  • Petr Schreiber's Avatar
    Yesterday, 21:10
    Petr Schreiber replied to a thread Excel COM question... in COM
    Hi Gerald, the change I need Eros to do would be beneficial not just for this module, but for many others - road worth a little dev pain :D The...
    58 replies | 1213 view(s)
  • John Spikowski's Avatar
    Yesterday, 19:20
    John Spikowski replied to a thread Excel COM question... in COM
    Here is the final submission to Jerry's code challenge. I was unable to show applying format to the sheet as Jerry's code assumes the sheet existed...
    58 replies | 1213 view(s)
  • Gerald Sutherland's Avatar
    23-07-2014, 23:02
    I think I'm getting closer to where my TB COM problem is. Obviously, it's that I don't understand the TB syntax ... partly at least because there are...
    58 replies | 1213 view(s)
  • Gerald Sutherland's Avatar
    23-07-2014, 18:37
    Thanks John, That's what I needed ... an example that did more than just open a file and drop some values into it. ;-) The cell manipulation is...
    58 replies | 1213 view(s)
  • John Spikowski's Avatar
    23-07-2014, 17:47
    John Spikowski replied to a thread Excel COM question... in COM
    Here is the Script BASIC submission to the Jerry Excel Code Challenge. I didn't complete all the cell manipulations or add in the error notification...
    58 replies | 1213 view(s)
  • Gerald Sutherland's Avatar
    23-07-2014, 16:21
    By the way, sorry about the haphazard Excel file in my sample. I was just trying to demo the PB Excel commands and was throwing them into almost any...
    58 replies | 1213 view(s)
  • mike lobanovsky's Avatar
    23-07-2014, 05:46
    mike lobanovsky replied to a thread Excel COM question... in COM
    Yes Petr, That's pretty cool indeed. In fact that's exactly what I was hinting at in my messages. Are you reading the TLB's?
    58 replies | 1213 view(s)
  • Gerald Sutherland's Avatar
    22-07-2014, 23:45
    Petr, That looks interesting ... and a lot more friendly from my point of view. :-) However, you are working at a level I'll never be able to...
    58 replies | 1213 view(s)
  • Petr Schreiber's Avatar
    22-07-2014, 22:53
    Petr Schreiber replied to a thread Excel COM question... in COM
    Hi Gerald, I am close, but I would need further assistance from Eros on the SDK. This is just a basic demo: uses "Excel" Dim xApp As...
    58 replies | 1213 view(s)
  • Gerald Sutherland's Avatar
    22-07-2014, 22:43
    The pantry has been scoured and I'll try it again. If this works ... this zip has the include file as well ... Looks good this time ... I think....
    58 replies | 1213 view(s)
  • John Spikowski's Avatar
    22-07-2014, 21:56
    John Spikowski replied to a thread Excel COM question... in COM
    Stale cookies. :D
    58 replies | 1213 view(s)
  • Gerald Sutherland's Avatar
    22-07-2014, 21:25
    I seem to be having problems with the forum ... I sign in, then try to post and attach a file ... and it says that I am not logged in. :-(
    58 replies | 1213 view(s)
  • John Spikowski's Avatar
    22-07-2014, 20:55
    John Spikowski replied to a thread Excel COM question... in COM
    Go Petr! Don't worry, you got Mike and I covering your back if what you have cooking doesn't pan out.
    58 replies | 1213 view(s)
  • Petr Schreiber's Avatar
    22-07-2014, 19:50
    Petr Schreiber replied to a thread Excel COM question... in COM
    Hi Gerald, I am looking into alternative solution - it might end up as big win or... fail :D But the good news we will know this night. I have...
    58 replies | 1213 view(s)
  • Gerald Sutherland's Avatar
    22-07-2014, 18:29
    I have taken one of the PB Excel examples and modified it with a few items that are generic rather than directly associated with my project. In...
    58 replies | 1213 view(s)
  • Gerald Sutherland's Avatar
    22-07-2014, 16:35
    John, I can probably cobble together a piece of code that demonstrates some of the PB COM syntax and results, but I can't post anything that...
    58 replies | 1213 view(s)
  • John Spikowski's Avatar
    22-07-2014, 03:52
    John Spikowski replied to a thread Excel COM question... in COM
    Jerry, Can you post / attach some code (PowerBASIC maybe?) so we can try to help out? That's what makes the BASIC community interesting is there...
    58 replies | 1213 view(s)
  • Gerald Sutherland's Avatar
    21-07-2014, 22:46
    Petr, Please correct me if I am wrong, but while having and Excel file open ... and then saving a short script to an external VBS file (from...
    58 replies | 1213 view(s)
  • Gerald Sutherland's Avatar
    21-07-2014, 21:29
    Oops! I guess you meant VBA. ;-)
    58 replies | 1213 view(s)
  • Gerald Sutherland's Avatar
    21-07-2014, 21:29
    Thanks Petr, Actually, I have never used VBS ...I have been using VBA (Excel macros) to find the details of what I need to translate into PB. I...
    58 replies | 1213 view(s)
More Activity