Hi,
Take a look at the following links...
http://www.15seconds.com/issue/020130.htm
http://www.computerperformance.co.uk/vbscript/wmi.htm
I am still not very clear about what exactly your are trying to do. That is
may be because I personally haven't done this before. Still I would like to
assis
Hi Ashish
Thanks Unfortunatily i got this formula from you thanks from 3-4 days i
try to finding this formula once again thanks.
i appreciate you will be help me in future
thanks
On Tue, Apr 28, 2009 at 8:43 PM, Ashish Jain <26may.1...@gmail.com> wrote:
>
> Hi Savant,
>
> Try this fo
Hi guys,
I have just installed OpenXL Beta 1.0.0.0 successfully but it's not
showing any addin/toolbar in Ms-Excel 2007. But it's appearing in list
of installed application in Add/Remove Programs.
Can anybody help me please.
Thanks in ADVANCE.
Regards
--~--~-~--~~~--
Dear Ashish
I too have similar problem as Mr. Upendra had. Let me tell you how i
installed.
The mistake i did, i guess, is i ran the setup without unzipping the zip
file. some message like "runtime error, load not complete" appeared. Am
trying to unload and load it afresh but i am not able to unlo
Dear Ashish,
Thanks for your reply. But I have to admit that I am a novice so far as using
VBA code is concerned.
So it would be very kind of you , if you could be a detailed reply on how to
use the solution provided by you.
Thanks & Regards...
Vivek Jain, FCA, DISA (ICAI)
Vivek Shantilal Jain
Hi Grunta,
This can't be done with worksheet formulas, as they will be re-calculated
everytime something changes, as you have discovered.
You will need to use the RND function in VBA to put a value in a cell. Since
this is done only once, the value won't change when the sheet re-calcs.
Regard
Hi,
The following will select the last data column, Row 1:
Cells(1, Columns.Count).End(xlToLeft).Select
The following assigns the last data column number to the variable 'A'
A = Cells(1, Columns.Count).End(xlToLeft).Column
The following will select the last data row, Col A:
Cells(Rows.
Hello
I would like a solution regard to excel formulas / VBA scripting.
The purpose is to assist in generatating unique PIN numbers for users
on our phone system..
The numbers generated need to be a number between 1000 & ...
The basic formula I have used (=RANDBETWEEN(1000,)) does it
i
Akhilesh,
Thank you for your help! I've been studying your code...like I said
i'm pretty new. It was a great starting place for my project.
Jonathan
On Apr 27, 8:59 pm, Akhilesh Karna wrote:
> Hi,
>
> You can find the solution in the attached file. Try putting the values in
> input-range to se
I Have a Macro which contains some Costing Related Report... Now i got
a
problem with the macro that for the next month that the data may vary
and the
Macro doesn't work as the last column & Rows Differ ...So if any one
can help
me to automatically select the Last column and Last row and there by
I currently have a VBA function that, supplied with the name of a
Windows Group, retrieves the names of the members of the group. (it
uses GetObject("WinNT://" & strDomain & "/" & strGroup & ",group"))
Using this info, I do a variety of things, including notification of
changes to the contents of
Hi Prashanth,
Write the below query and let me know if it is working:
Update Test1
Set Test1.Month = Month.Month
Where Test1.Weekno. = Month.Weekno
Regards,
Upendra Singh
9910227325
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Prash
The attached provides a possible solution. If you have any questionslet me
know.
Tom
On Tue, Apr 28, 2009 at 11:19 AM, Tom Jeffries wrote:
> The attached provides a possible solution...If you have any questions let
> me know.
> Tom
>
> On Tue, Apr 28, 2009 at 8:27 AM, ronnie wrote:
>
>>
>> I d
Hi All,
I have an very urgent issue with MS Access, however it might be simple to
you guys.
Please help me, very urgent.
I have two tables: Test1 and Month
I want to update column Month1 from table Month to Month column in table
Test1.
primary key is on WeekNo.
I tried the following ode and i
Hi,
Try wsheet.Hpagebreaks.Count and Wsheet.VPageBreaks.Count.
and wsheet.HPageBreaks().Location.Row
Regards
Ashish Jain
www.excelitems.com
Developer of OpenXL
---
On Apr 28, 9:24 am, "vivek jain" wrote:
> Dear All Groupm
The attached provides a possible solution...If you have any questions let me
know.
Tom
On Tue, Apr 28, 2009 at 8:27 AM, ronnie wrote:
>
> I did this much coding and i am stuck out here can you help on how to
> approach from here.
>
> Sub seating()
> Dim inputrow As Integer
> Dim seatNum As Inte
Hi Savant,
Try this formula:
==IF(OR(AND(ISNUMBER(FIND(LEFT(B2,1),"JCR")),IF(SUM(COUNTIF(C2,
{"DST","LVN","DNM"}))>0,TRUE,FALSE)),OR( ISNUMBER(FIND(LEFT
(B2,1),"AWFUY")),ISNUMBER(FIND("SHORT", G2)),IF(SUM(COUNTIF(C2,
{"BOG","BLM","CMO"}))>0,TRUE,FALSE))),I2-0.01,J2)
Regards
Ashish Jain
www.exce
Hi
Try this link - http://26may.1984.googlepages.com/OpenXLBeta1.0.0.0.zip
Regards
Ashish Jain
www.excelitems.com
Developer of Open XL
--
On Apr 28, 3:45 pm, iactnow wrote:
> I have tried to download openxl several times o
Hi Upendra,
Few Checks for you, please check and hence provide us your valuable
feedback.
1. Did you unzipped the file or ran the setup without unzipping?
2. Were you connected to internet when ran the utility?
3. Does prerequisites(.Net Framework3.5 and VSTO 3.0 RunTime)
installed on your syste
Hi Ashish,
I have downloaded openxl add-in but on running, gives following error
"Setup has detected that the file
'C:\Docume~1\TEMP\Locals~`\VSD3C6.tmp\DotnetFX30\dotnetfx3.exe' has changed
since it was initially published. Clisk OK to retry the download, or Cancel
to exit setup."
Please sugge
Hi Mayank Patel
pl find attach solution file which is what you expect
let me know
S. Jayavelu
9941260857
On Mon, Apr 27, 2009 at 6:54 PM, Mayank Patel wrote:
> Dear Friends
>
> Please suggest the formula.
> sample file is attached.
>
> Thanks to all in Advance
>
>
>
> Regards
> Mayank
Hi All,
I have written a code in excel vba which opens an existing word document,
copies a range from excel worksheet and then pastes that range on the word
document.
Code is working fine, if I paste the range as *MetafilePicture* but I need
to paste the range as *Bitmap*. When I am pasting it as
Hi Satish,
are you sure? You are using the correct version.
My solution may sound unappropriate but please check
rightmost tab in the Office ribbon as given in
its snapshots here:
http://openexcel.blogspot.com/2009/03/screenshots.html
or as in videos here:
http://openexcel.blogspot.com/2009/03/vi
I did this much coding and i am stuck out here can you help on how to
approach from here.
Sub seating()
Dim inputrow As Integer
Dim seatNum As Integer
Dim seat As String
Dim name As String
inputrow = 3
Rowadd = Left(seatNum, 1)
ColAdd = Right(seatNum, 1)
Dim OutRow, OutCol As Integer
OutRow
Dear Friends,
I downloaded the zip folder and double clicked on setup file, the process
said, successfully installed, even then am not able to see "Open XL" icon in
my excel sheet. Can anyone help me to find a solution. Am using Excel 2007.
Regards
Satish
On Tue, Apr 28, 2009 at 2:57 PM, zaki l
I have tried to download openxl several times on two different
computers and I get a popup message saying:
"Title: OpenXLBeta1.0.0.0.zip
The server replies that you don't have permissions to download this
file.
Details
HTTP/1.1 403 Forbidden
OK"
-
Totally agree..!
regards..
On Mon, Apr 27, 2009 at 7:14 PM, Harmeet Singh wrote:
> Hi Ashish,
>
> I must say, Its a killer tool. Keep up the good work buddy.
>
> U r simply Awesome.
>
> What do u all say.?
>
> On Mon, Apr 27, 2009 at 6:57 PM, Ashish Jain <26may.1...@gmail.com> wr
Hi Ankur,
VBA/VSTO Macro Programming don't provide undo of automated tasks.
Application.undo works for manual tasks only where it saves the last
state of
opened workbooks in application.
But still we're working on this issue and future versions you'll find
that this
problem is solved with certai
One problem using Open XL...
Once any function in OpenXL is used it can't be undone using Ctr+Z .
Plz solve this querry
On Mon, Apr 27, 2009 at 6:57 PM, Ashish Jain <26may.1...@gmail.com> wrote:
>
> If you want to do any or all of the following. Visit
> http://www.excelitems.com
> and Down
29 matches
Mail list logo
