On a different note, has any one used Microsoft office Spreadsheet Control
10.0 / 11.0. It can also serve my purpose but I have never used before and I
(really) can't file a good documentation for it on the internet. I think it
does not support the routine vba expressions as worksheets do. For example -
Num = Application.WorksheetFunction.CountA(Range("A:A")) works with active
sheet but,
Num = Application.WorksheetFunction.CountA(Spreasheet1.Range("A:A")) gives
an error.
This is just an example,I might need to do many such things with this
spreadsheet control.
I am not familiar with proper VBA syntax(es) I just play around with them.
Any idea folks ?
Best regards,
Abhishek
On Wed, Apr 7, 2010 at 1:40 PM, Abhishek Jain <abhishek....@gmail.com>wrote:
> Thanks Siva for your kind reply.
>
> The attached ocx file is showing the same error - "The control could not
> be created because it is not properly licensed." I've tried by registering
> it in regsvr32.exe too, still the same result. If you can create it
> successfully, please send a sample file, may be I can use it (copy/paste).
>
> Thanks again.
>
>
> Abhishek
>
> On Wed, Apr 7, 2010 at 12:33 PM, Siva Kumar Vemula <vemula...@gmail.com>wrote:
>
>> Hi Abhishek,
>>
>> Please find attached requested ocx file.
>>
>> Hope this may help you to resolve your problem.
>>
>> regards
>> siva
>>
>>
>> On 4/5/10, Abhishek Jain <abhishek....@gmail.com> wrote:
>>>
>>> Dear Group,
>>>
>>> Any update on this ?
>>>
>>> Regards...Abhishek
>>>
>>>
>>> On Tue, Mar 30, 2010 at 1:51 PM, Abhishek Jain
>>> <abhishek....@gmail.com>wrote:
>>>
>>>> Dear All,
>>>>
>>>> I am working on a project where I've prepared an userform for creating
>>>> Purchase Orders (PO). PO are Vendor wise, one PO for each vendor, no matter
>>>> how many items are in there. Now, the vendor part is okay, I have a list of
>>>> vendors from where the userform fetches the record.
>>>>
>>>> When the user has selected the vendor, I want a grid type control in the
>>>> userform where user can select the items to be purchased. Item Names will
>>>> come from another list,quantity will be filled in userform and the PO would
>>>> be generated and data will go in another sheet. It would be one entry per
>>>> item and each entry would have 6-7 fields.
>>>>
>>>> I am stuck here - How would I put a grid in userform whose fields are
>>>> linked to another sheet in Excel. I googled, found that there is a 'thing'
>>>> called MS Flexigrid which is somewhat the same I need. Here's my flexigrid
>>>> experience :
>>>>
>>>> ----------
>>>> The file of this control is MSFLXGRD.OCX and I was told that it would be
>>>> in C:\Wndows\System32 folder. I just have to add it in VBA (Tools >
>>>> References).
>>>> ----------
>>>> The ocx file was not there in my system32 folder.
>>>> ----------
>>>> I downloaded it from Net, copied it in system32, added in VBA references
>>>> and added the control in Toolbox.
>>>> ----------
>>>> When I tried to create the control on userform it said - "The control
>>>> could not be created because it is not properly lisenced."
>>>> ----------
>>>> I googled again, told that I have to open the file with regsvr32.exe
>>>> which is in system32 folder itself.
>>>> ----------
>>>> I did, it said - "Succeeded"
>>>> ----------
>>>> I unchecked the control from VBA references, re-checked, re-added it to
>>>> the toolbox.
>>>> ----------
>>>> Again I tried to create the control it said - "The control could not be
>>>> created because it is not properly lisenced."
>>>> ----------
>>>> Since the control indicates that it is for Windows XP (SP3) and I am
>>>> using Windows 2003 Server with Office 2003, I have tried this on - Windows
>>>> 7
>>>> - Office 2007 and Windows XP (SP3) - Office 2003 but with same result (it
>>>> failed with regsvr32.exe in Windows 7).
>>>> ----------
>>>> I gave up.
>>>> ----------
>>>>
>>>> Now there are two things -
>>>>
>>>> > Has anyone used this MSFlexigrid before ? If yes, How do I get this to
>>>> work ?
>>>>
>>>> > Forget flexigrid...anyone could suggest a way I am trying to achive in
>>>> userform. A database type grid, 15-20 rows, scroll bars, fields linked to
>>>> another sheets...thats it.
>>>>
>>>> Sorry for being long, I was just trying to be descriptive.
>>>>
>>>>
>>>> Any and all help is greatly appreciated.
>>>>
>>>>
>>>> Thanks,
>>>>
>>>> Abhishek Jain
>>>>
>>>> --
>>>>
>>>> ----------------------------------------------------------------------------------
>>>> Some important links for excel users:
>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>> http://twitter.com/exceldailytip
>>>> 2. Join our Facebook Group @
>>>> http://www.facebook.com/group.php?gid=287779555678
>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>>
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>> HELP US GROW !!
>>>>
>>>> We reach over 6,800 subscribers worldwide and receive many nice notes
>>>> about the learning and support from the group.Let friends and co-workers
>>>> know they can subscribe to group at
>>>> http://groups.google.com/group/excel-macros/subscribe
>>>>
>>>> To unsubscribe from this group, send email to excel-macros+
>>>> unsubscribegooglegroups.com or reply to this email with the words
>>>> "REMOVE ME" as the subject.
>>>>
>>>
>>> --
>>>
>>> ----------------------------------------------------------------------------------
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our Facebook Group @
>>> http://www.facebook.com/group.php?gid=287779555678
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> HELP US GROW !!
>>>
>>> We reach over 6,800 subscribers worldwide and receive many nice notes
>>> about the learning and support from the group.Let friends and co-workers
>>> know they can subscribe to group at
>>> http://groups.google.com/group/excel-macros/subscribe
>>>
>>
>>
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
