Dear Ashish,
Is there any version which is compatible with Excel 2003 as i am using Excel
2003.
Best Regards,
Jitendra Kumar
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 Download
Dear Aindril,
Thanks for ur help,
but this formula is not giving desired result. please try again.
Thanks Again
Regards
Mayank Patel
ITC LTD
9822978041
9422749110
On Tue, Apr 28, 2009 at 8:55 AM, Aindril De aind...@gmail.com wrote:
Dear Mayank,
You seemed to be almost on track with the
Thanks to all,
A Good news, Me and Ayush, planned to launch it for Excel 2003 (not
for any other previous versions).
It will be soon available to group members.
Please make a note Humans take a step forward, that's how
civilizations grows. This means no support and updates will be
available for
From where can we download VB 33 lesson (39).doc ?
On Mon, Apr 27, 2009 at 2:37 PM, Suyog nashi...@gmail.com wrote:
Hi All,
Refer uploaded VB 33 lesson (39).doc for new comers. Refer all 33
lessons start your VBAmacros.
Thanks
SK
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
Totally agree..!
regards..
On Mon, Apr 27, 2009 at 7:14 PM, Harmeet Singh harmeet.hew...@gmail.comwrote:
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
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
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
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:
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
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 mkpat...@gmail.com wrote:
Dear Friends
Please suggest the formula.
sample file is attached.
Thanks to all in Advance
Regards
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
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
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 yuk.s...@gmail.com wrote:
I have tried to download
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 ronakparekh_...@hotmail.com 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
Hi,
Try wsheet.Hpagebreaks.Count and Wsheet.VPageBreaks.Count.
and wsheet.HPageBreaks(Page Count).Location.Row
Regards
Ashish Jain
www.excelitems.com
Developer of OpenXL
---
On Apr 28, 9:24 am, vivek jain
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
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 tjeff...@gmail.com 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
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
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 the
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
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 akhiles...@gmail.com wrote:
Hi,
You can find the solution in the attached file. Try putting the values in
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
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:
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.
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
26 matches
Mail list logo