Search results for query: *

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

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

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.

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

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.

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...

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 =...

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.

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

>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"...

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...

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...

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...