Hello guru's,
i am not sure if it can be done but any thing is possible for the guru's
Column A Column B
I 10
I 90
A 30
B 40
C 50
Type: Posts; User: ashu1990
Hello guru's,
i am not sure if it can be done but any thing is possible for the guru's
Column A Column B
I 10
I 90
A 30
B 40
C 50
try setting the files into the variables to work on them eg:-
dim wbk as workbook
set wbk = workbooks.open(path)
or set wbk = activeworkbook
i have made this for text comparision you can compare with height,width and more. for comparing with your local machine image
try this
Sub test()
Dim pic As Shape, a As Shape, b As Shape...
this is because you are using some of the reserved words of acess DB try checking the DB titles or the words which are used in the SQL statement
Hi fox,
:peacesign:
just intersted to know new things jamil whats to export all inbox into a worksheet and map the difference between 2 replis is this the task.
did not know what exactly he wants...
Hey thanks transformer.. :rolleyes:
i did the both adding space and the brackets together so forgot :wakeup: to mentioned that thanks for the reply..
for those searching the same answer;
i got it working the reason error occured was due to no space given after each "=" ;)
cheers :cheerclink:
try this before calling the function
if instr(your text,"characters") > 0 then
'''do your stuff'''
end if
this will help you to find if char or no char are present in the text
hi would like to give a try what exactly do you need?
Hi All,
i am trying to run a update code from vba through adodb connection my Db is .MDB,
while runnign the update query i am getting "syntax error in update statement" error please help
As i...
Hi guys,
I am stuck into a following thing i have 3 amount where i need to calculate the sum of three amount and the answer should be zero i tried using loop but no sucess :confused: any...
At last i completed it with lots of R&D and googling i got it worked posted the code for your refrence.:cheers:
Set myHTMLDoc = ie.document
Set myHTMLFrame2 =...
Hi fox thanks for the reply when you can be home im at office till 8:30 IST so if you get me some code to click on the tabel urls and to change combobox value
in ie i checked from my end i am...
Mr fox i got the code running for taking element id from frame and tabels but when clicking the button throught element id code runs but does not click on the button on ie below is the code which i...
Try This Easy and works every time;)
Sub test()
Range("A1").Select
Do While ActiveCell.Address(0, 0) <> Range("A65536").End(xlUp).Offset(1, 0).Address(0, 0)
If LCase(ActiveCell.Value) =...
Hi Fox tried the code but it says object doesnt support the property or method wherein i tried with the innertext but didn't worked.
as its in a frame on a table does firstly i have to get the frame...
Hi thanks for the reply as its a company link it wont work on your pc as i have attached a image of it and posted the whole source code please if you can provide me the code to click the cutton which...
assign the file name to a string and then activate it.
wbk = activeworkbook.name
windows(wbk).activate
Hi
i am really stuck bad in ie automation where m not able to select an combobox option with the element id can any one help.
i have puted the html code i got from the web page please help me on...
riga = Range("A:C, G:G").find