Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: casg
  • Order by date
  1. casg

    Global variable

    Again, thanks, global seem what I was looking for. The other one is promising in general. I'll test both on Monday.
  2. casg

    Global variable

    Again, storing in files is a bad idea (TM) because of legal issues.
  3. casg

    Global variable

    I know it may sound very newbie... but how can I create a global variable usable for serveral macros? I mean some macros update that variable while others use its value.
  4. casg

    Using data in a macro from notepad

    No, I changed it to objSystem and the error is just the same.
  5. casg

    Using data in a macro from notepad

    No, I haven't pasted the declarations, but they were there and the error wasn't about types but the "automation error." thingy. Anyway, the EB-driven macro(script) is just impressive.
  6. casg

    Using data in a macro from notepad

    This has worked perfectly, thanks : 'Excel Object Dim Excel_Obj As Object, Excel_Sheet As Object Set Excel_Obj = GetObject(,"excel.application") 'gets excel assuming it's open Set Excel_Sheet = Excel_Obj.ActiveSheet 'get the open sheet Dim TotalRows, Counter As Integer...
  7. casg

    Using data in a macro from notepad

    No way, I've followed this steps: - I've recorded a macro - I've openened the macro editor - Using tools->references I've added the "extra automation tools", I even can browse the objects in the objects inspector. - I add this code to the newly recorded macro: Set System =...
  8. casg

    Using data in a macro from notepad

    I'm trying the code posted by shadygrove (in an excel macro) and in the line public system as extrasystem it says :"type not defined by the user" I've tried too, the line: Set Ses1 = GetObject("Session1.EDP") But it says: "depuration error" How can I use an existing extra session in excel.
  9. casg

    Using data in a macro from notepad

    Wow ! you guys are great! I'm eager to code all those things, tomorrow morning ! I 've given purple stars to you all!
  10. casg

    Using data in a macro from notepad

    >Excel VBA would be best choice if you are manipulating info >for each customer in the excel sheet (not what I think you >want if your not saving any of your manipulations). No, I handle info in the Extra session, and I get a final result like "yes, he's a target". I mean, most of the "brain"...
  11. casg

    Using data in a macro from notepad

    Yes, clarification is very good idea , the process is this: we get some listings comprising personal data (which is protected by law), we can see the listings prior to printing them. 'We can see it' means we can copy and paste them into excel, for example, why excel, because, it will split the...
  12. casg

    Using data in a macro from notepad

    hmm, right, that solves what I asked, but, I really meant something else. I mean, I want to retrieve data from notepad.exe without using any file, because of a legal restriction. I want to paste something into notepad and retrieve from it without storing it in a file. It'd be nice also to...
  13. casg

    Using data in a macro from notepad

    Hi, I'd like to feed a macro with data in the notepad, I've read about CreateObjet in other posts, but how would it be ? Where can I find info about methods and properties of the "CreatedObjects"? The data I want to introduce is thus: 1231 1231 22 2 That's a row of numbers, only. I'd...

Part and Inventory Search

Back
Top