I fixed one error. I didn't notice the space before the C ... ". Columns("A:A").Select"
But now I get "Expected Statement" on this line ".Sheets.Add After:=ActiveSheet"
I am trying to write a VB Script to run a SAP transaction and download to Excel. Then manipulate the output. What I want to do is with the first worksheet (objWB1), is to activate it, select all data in column A, insert a sheet ‘after’ the current sheet, paste and then remove duplicates. Then...
I have to keep track of an item through a sign-off process. When we get an new order for a item, we want send it through all departments for approval and keep track of the who/when it was completed.
Fields that I need are:
Item
DateCreate
EngAppToSchedUser (Engineering Approval to Master...
some very useful stuff written by Duane (thanks Duane if you read this) and have already incorporated in a couple of my databases. However, that is not exactly what I was looking for.
Users have many databases (some sorta complex) that link directly to the tables that I am trying to protect...
I have a situation and don’t know the best approach. I have come into an environment where there are many databases (20-30) using many of the same tables. Example is that db 1 may use tables from 2,4, & 5 and db 2 may use table from 4. Hope that makes sense.
One db in particular has...
Sorry..I want to change the values of CAT$GROUP to the value of the max count.... so I would want to make all 4 of the values for CAT$GROUP for '4138' be 'LVS' since it has the higher count.
Thanks!
I need to count the number of records in a sub-group then update all the records to the value of the max count.
In the example data below I need to change all of the values of group ‘4138’ to ‘LVS’ , since the count is LVS – 3 and LVL – 1.
Now for the tie breaker – If there is a tie then I...
I have linked the “Global Address List” from the Exchange server, however, it seems to only contain the information on the ‘General’ tab. Like First, Last, Address, City, State, etc.
When I open the properties of a contact I see a tab label “Organization.” On this tab it lists a manager and...
Thanks. I had already started writing the Sql select statement and realized the same thing you said... long and difficult to maintain. Thought someone here may have had a quicker solution.
If you don't mind, help me understand your normalization statement. The table is created from an MRP...
I have a query that contains 56 fields: Item, Desc, Wk1, Wk2, Wk3, ... Wk56.
What is the best way to select the Item if any field (Wk1-Wk56) contains a value that is less than zero?
From sample the data below, I need to return the 'Grp' if any value in cItem contains '4' in the 3rd position and a citem begins with '120' within that group.
Grp Item Date cItem
1 123 5/15/00 014236
1 235 9/19/03 120236
1 173 2/23/01 014998
1 126 8/13/02 024329
1 143 1/19/06 014236
1...
...great with a minor modification. Had to remove the AND statement. Also, added an exit to the loop.
iPos = 0
For Each x In Array("_", "/", "-", "*", " ", "'")
I = InStr(3, yourString, x)
If I > 0 And I < iPos Then iPos = I: GoTo Cont:
Next
Cont:
MsgBox "Position = " & iPos
Another...
...the first occurrence of any of the following characters that appear in a string starting in position 3 and return the position.
Characters to find: _ / - * {space} '
I know I can do it with nested if's and instr but believe there has to be a slicker way.
Can anyone help?
I'm using Access 97.
Thanks rubbernilly, although that did not get me what I was looking for, it gave me some additional things I did not know where available.
cmmrfrds... that returns the same thing (on my computer at least) that environ("username") returns. It is what I call the LoginID and not the persons name...
I have searched and reasd many posts here and founf several ways to get the userid and computer name,
Like:
Environ("username")
Environ("computername")
However, I can not find anything on how to find the user's name. ie. like the name used on the top of the start menu in XP.
Is it...
Thanks linney.
Actually, it is a corporate mandate that IE starts everytime the PC boots, don't know why, but I just don't like it and I want to disable it.
That allowed me to accomplish my mission.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.