thanks again
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent,
What is PFA?PFA is Please Find Attached
On Monday, November 11, 2013 3:49:38 PM UTC-8, Bill Q wrote:
What does pfa mean ?
On Monday, November 11, 2013 2:01:37 AM UTC-5, ravinder negi wrote:
pfa
*From:* excel-...@googlegroups.com [mailto:excel-...@googlegroups.com] *On
Behalf Of
is
Application.WorksheetFunction.VLookup(MyItem, myRange, 3, False)
End If
Exit Function
NotQty:
GetPrice2 = Application.WorksheetFunction.VLookup(MyItem, myRange, 4,
False)
Exit Function
oops:
GetPrice2 = Info not found: MyItem
End Function
It works, maybe not graceful...
hth
Bruce
On Sunday
I am needing to create a project that needs to talk to other users
that are woring from a common file.
I have found the following code that loos lie it may be a good place
to start, but I keep getting errors.
Compile error: can't find project or library
and it highlights wschat
I run from 2
I have the need to work with IE8 and TABs. I have found out how to
open a new tab, but how can I control which tab I am working with?
Thanks
--
--
Some important links for excel users:
1. Follow us on TWITTER for
I am trying to automatically delete items from an in house intranet
website.
I have the code that works upto the point of delete button pressing,
and I have the code that works to press the next confirmation button.
Each portion has been tested and works fine.
The problem is that the code STOPS,
This should be close!
[code]
public web_Handle as object
sub callwebsample
opentheweb(google.com)'open the web
for i = 1 to 200
newPage =' assign the web page here
web_Handle.Navigate newPage
'wait for the web
While o_WaitforWeb.Busy
DoEvents
Wend
While
This should help you! You will need to also reference the html and ie
libraries in your VB Editor
public web_Handle as object
sub callwebsample
opentheweb(google.com)'open the web
newPage =' assign the web page here
web_Handle.Navigate newPage
SaveWebFile(Web_Handle)
'wait for the
I am creating a program that does daily QA of our products. I work for
a phone company and we sell differnt lines, with differnt options
What I need to do is to convert one speadsheet where the features of
the phone lines are in a list, one feature per row
Simplified input file
PhoneNum
555-
I have the following code:
[code]
Sub CommandButton1_Click() 'create a new window
Dim web As String
Dim AccountCol As Integer
Account_Col = 5
Switch_Col = 7
web = Sheets(sheet3).Range(B1).Value
DoBrowse1 web
End Sub
Sub DoBrowse1(url As String)
Dim TargetFrame As String
Set BTS =
10 matches
Mail list logo