Search results for query: *

Ok, I wrote the script below to rip files from a CD and if the filename match a regular expression them move the file to network folder A and write to a file otherwise move to network folder B and write to an error log. My disk drive is D:\ and everything works fine however when I gave this...

Nice this worked perfectly. Thanks

Umm I didn't think of that. I will try it; I may need a little sample code, but let me try to figure it out first. Thanks Skip!

Is there a way of limiting the number a macro can run? Maybe writing to a separate text file until a certain number is reached? I have some macros that I would like user to run a limited amount of times.

This is another way which may be cleaner since it deals with the Google page elements without sending keys Sub Main() Dim Sys as Object, Sess As Object Set Sys = CreateObject("Extra.System") If Sys is Nothing then MsgBox ("Could not create Extra!.System...is E!PC...

This code works for me, just change the references to the screen to suit your system Here is the complete code: Sub Main() Dim Sys as Object, Sess As Object Set Sys = CreateObject("Extra.System") If Sys is Nothing then MsgBox ("Could not create Extra!.System...is...

I figured it out. Just like the previous post, I needed to wait before clicking the form Here is the working code: Case is = "UP" Set IE = CreateObject("InternetExplorer.Application") With IE .AddressBar = False .StatusBar = True...

I wrote an Extra! macro that goes to different shipping sites and enters screen data into their tracking forms. All of them work but for some reason in the UPS site I cannot figure out how to "click" the track button. Maybe someone here knows how to. Here is an excerpt of my code which only...

This is what I use: While objIE.Document.ReadyState <> "complete" ' Do Nothing Wend or: While objIE.Busy 'Do Nothing Wend

This may be over my head but I will try it I'll let you know how I managed. Thanks

I have a script that will read each file on a folder and create a text file which contains the filename and path for each file in the folder.I would like to change this scrip to create a comma delimited file using the filename as the data source for example my file name is: F2MA 212001800A2 F01...

I just tried running another excel macro that always worked and I got the same error. I think it had to do with me running 2 sessions while I was testing the your macro. I restarted my machine and now it runs fine. Still needs a few tweaks but no errors I thank you Skip for you patience and...

Funny you mention that, on my other macros that work from excel I've never have to reference the Extra! Object Library. On this case I did reference it and still got the same error. Your excel data and screen mapping sample is exactly what I need. If you go back to my second post with my...

It didn't like that either. Error: User Defined type not identified. Weird because I have other macros that write to Extra running from Excel 2003 with the same Object statements from before and they work. I don't want you to go crazy. You pointed me to the right direction with the loop and I...

Error on If Sess0.Screen.GetString(1, 2, 4) = "FEBM" Then If I Remove that IF statement then the same error will occur on Sess0.Screen.PutString MyRange.Cells(Row, "B").Value, Lrow, 3 I guess it has something to do with the Sess0 object

Yeah that's what happens when you steal code from other posts without fully understanding it. I cleaned it up but I now get a Runtime Error 91 / Object Variable or With Variable not Set I'm coding in Excel if that matters...code below: Sub FACTSQuote() Dim Session As Object Dim Sess0 As...

Almost there, I'm getting a Syntax Error on: for each r in .Range(.Cells(.[A2], .[A2].end(xldown)) Here is my updated code to with the right Extra objects: Sub FACTSQuote() Dim Session As Object Dim Sess0 As Object Dim System As Object Set System = CreateObject("Extra.system") If...

Thanks Skip, This is what I have so far (working only for 1 column for now) and by no means finished. And yes your assumptions are correct. I will give your code a shot, and again Thanks. Sub FACTSQuote() Dim Session As Object Dim Sess0 As Object Dim System As Object Set System =...

I'm stuck and reading other related posts is just confusing me more. I have a spreadsheet with 3 columns (ID | P/N | QTY) with a variable number of rows. My Extra! screen can take up to 4 records per screen for example: 1st record ID (row 10 col 3), P/N (row 10 col 8), QTY (row 11 col 10) 2nd...

I think my code is pretty sound. The only time it would go on a infinite loop is if a user sends keyboard commands to the session while the macro is running (I know I can hide the session while it runs but my users are not savvy enough to kill an application that they can't see) or the session...