"Shell "Exit"
On Jun 21, 9:03 am, len wrote:
> I am shelling out a command in VBA to run someone's java class by
> calling a batch file. The class runs fine and produces the output I
> need, but the end of the code leaves the DOS window open with the
> command to enter any key to close.
>
> How
placing the ID# somewhere on a worksheet and just
having the code open the other form which looks to that place on the
worksheet for which data to look up?
What exactly is your difficulty?
-Damion
On Jun 1, 3:48 am, Jabar Batcha wrote:
> Hi,
>
> I want build a macro open a Userform sh
ers or longs.
You'll also need to assign values to firstrow and lastrow
Unless you have an equation in Column A or something that changes its
value based upon what row it's in - this will be a never-ending loop.
-Damion
On Jun 3, 7:20 am, Rajesh D wrote:
> Dear All
>
> Please he
To break the links, record yourself doing a find and find next.
Search for [
Put that in a loop.
Insert in the code a copy, paste special value for that cell and then
search for the next one.
Eventually, the loop will end when it can't find [
Or if you are advanced enough in VBA you can use the s
