loudey
Last Activity: Feb 22 '11, 09:55 PM
Joined: Mar 29 '10
Location:
-
Thanks a lot I really appreciate all the time you have put into this and all the help you gave me. but it doesn't seem like I'm going to be able to get it done so I will just give up on it. thanks again -
just wondering how did you find this iframe. I didn't read through the whole text file ofcourse but I tried CTRL-F in the text file and can not find anything that says "iframe".Leave a comment:
-
that is a very good peice of information. to tell you the truth I'm not sure if it is in a frame or not (I don't know anything about java) but my best guess would be that it is since if you look at my initial code and you look at line 49 it is done the same way and it works.
Now how can I find the frame ID within the source of the site. I have been looking at the text file but I can't find anything. what should I be looking for....Leave a comment:
-
I don't think you can see the whole webpage in the HTML file, however if you click (CTRL-F) in the "site source.txt" and paste "ctl00$ContentP laceHolder1$uxQ uantity" you will find that under "Input Name" and that is where I want to fill in the text box. I have also included a jpeg of what the site looks like if this helps any....Leave a comment:
-
Sorry didn't have access to my work computer over the weekend. Anyway please find the source HTML attached. let me know if you can't open it. (Couldn't attach HTML so i had to zip the file)...Leave a comment:
-
thanks for the reply and sorry I sent you a private message even though you had already replied but for some odd reason when I checked this post earlier it didn't show your reply.
anyway I have been trying to avoid bothering you with the whole code so I have been just copying the part with the problem but that seemed that it have caused more problem than helped. so here is the full code.
...Code:Sub FixQtyMisMatch()
Leave a comment:
-
thanks for your reply, oh sorry I missed up while copying the code
I still have the same issue though, even with the IEDoc variable assignedCode:Dim IEapp As Object Dim IEdoc As Object Set IEapp = New InternetExplorer Set IEdoc = IEapp.document IEdoc.all("ctl00$ContentPlaceHolder1$uxQuantity").Value = 4
thanksLeave a comment:
-
How to fill a text field in internet explorer using VBA?
I have a VBA program that automates an internet explorer process the whole code works except one piece.
when I try using this code,
I recieve an error that says "Run-time error '91': Object variable or With block variable not set"...Code:Dim IEapp As Object Dim IEdoc As Object Set IEapp = New InternetExplorer IEdoc.all("ctl00$ContentPlaceHolder1$uxQuantity").Value = 4 -
thanks Pat this works exactly like i wanted
highly appreciated
LoudeyLeave a comment:
-
Conditional formatting with Iserror
I'm trying to change the background color of cell B15 to red if any of the following cells is an error M15, O15, Q15, or S15. I know i can do it with conditional formatting but conditional formatting does not let you include more than three criteria. if your solution involves a macro do not worry about triggring the macro because i can embed it within a macro that i currently have and it gets automatically triggered whenver the cell changes. so all... -
thanks a lot guys this, both solutions works. highly appreciated.Leave a comment:
-
Split cells in excel using VBA
I'm trying to split a product code into multiple cells but i'm not sure how to go about it. here is an example
(the product code is in A1)
A1=MST5F2
Here is what i want the output to look like
B1=MST
C1=5
D1=F
E1=2
so B1 will always be the first three digits and then beyond that it's 1 digit in every column the product code is always 6 digits. -
VBA Vlookup inconsistent failure
I'm using Vlookup to lookup a "Product Type" in Column "D" vs a given "Product Code" that is listed in Column A. here is the code that I'm using,
this code...Code:'Product Type lookup Set mg = Sheets("Product Code").Columns("A:D") col = 4 'On Error Resume Next ProductType = Application.VLookup(productcode, mg, col, 0) -
Thanks SammyB
I did what you told me and it works like a charm
I appreciate itLeave a comment:
-
BTW i just want to let you know that i see the problem now.
the issue is that I am copying and then deleting (inside the "if" clause) and then pasting. But if the "if" clause have run then the program can't paste because when excel deletes a cell it also tends to forget whatever that it has in the clipboard also
I still don't know how to fix it thoughLeave a comment:
-
I was able to figure it out but here is the code for whoever needs it in the future.
IEdoc.All("Inpu t the name of the field that when it changes it the onchange event should activate").Fire Event ("onchange")Leave a comment:
-
Hi SammyB
Friday would be no problem.
when i replaced line 18 with the two line you provided i got this error now.
"Run time error '1004':
Application-defined or object-defined error"
and yes i started wanting to copy a variable sized range but then found another workbook that contain the information that i wanted but it won't go past row 200 so i decided to copy the whole thing...Leave a comment:
-
Thanks SammyB for the quick response it is actually a little more complicated than what i mentioned i just thought i might be able to figure it out once i get that piece. anyway here is a piece of the code that is able to do what i want however i also want it to check if this item already exist in the database and if it does delete the one on there and copy the new one.
so the following code without the if statment works just fine...Leave a comment:
-
Copy rows untill 0
Hi
I'm trying to write a VB code that can copy the value of the cells between B56 through BB56 to a different excel file (called database). the first file's name can be different names but it will be the file where the macro will be imbeded and run from. also the macro will need to loop in the next colum (for example B57 through BB57) and keep looping untill the value in B(and that column) is equal to zero
any help... -
VB Internet Explorer onchange event
hi I'm making a macro in excel that loads up internet explorer and fills out a form. I'm able to do all of that but i have a hard time to trigger a javascript onchange event that is triggered when a user manuallay types a number in the textbox and clicks outside the box.
here is my code for that text box
' Inserts unit sales price
IEdoc.All("ctl0 0$ContentPlaceH olderMain$uxFtc $uxUnitSalesPri ce").Value...
No activity results to display
Leave a comment: