I'm generating an excel program using VB from an Access Document. What
I'd like to have also is a macro in the generated excel document which
is incerted into this document via the access code. For example,
supose my access document generates an excel document with a single

As soon as I try to put a control on my form, I get this message:
The control could not be created because it is not properly licensed
This is not the case with standard controls which are on the toolbar by
default (label, textbox, etc).

I would like to move the cursor to the first or any coloumn in the same row
writing a macro.  Can anyone help.
Thanks in advance

I have 2 spreadsheet (A & B) with same column headings.  I am trying to put a
macro button in Spreadsheet A in which it will
1. copy the last row of data in Spreadsheet A
2. paste the row of data as last record (first empty row) in Spreadsheet B

Can anyone give me a simple way of providing third parties with an
excel spreadsheet with command buttons that would pull in data from
stored procedures in my online sql database, with the connection
properties "hard coded" so that they cannot see them - ie I don't want

I have many graphical buttons on a sheet with different names/properties but
all initiate the same macro.  I need the macro to get the name/properties of
the initiating button.  
Is there a "who started me" value I can get?

Hello,
For example I have 400 option buttons, so i want to find on which cell they
are.
I mean, if option button is on cell (2,2) I want to know this.

I need to create a sub procedure to do this:
(1) load a range (i.e. B2:G2) of numbers from a sheet into an array.
(2) randomly sort this array
(3) paste this resorted array back to the original location.

I am trying to insert and copy rows over multiple sheets, here is what
i have:
Sub SetParam()
'

I'm having a problem where I have a web query looking at an XML file.
When it spits it into the spreadsheet, its formatted in rows.  The
problem is, it doesn't have enough space to spit out the whole feed.
I need it to be formatted into columns.  It needs to do this

I have set up a macro to automatically save and promt the  user to PDF the
worksheet and print on a set printer on the network, it all works well on my
computer but on others computers the links to the printer don't work or
PDFing the file don't work, how do I fix this. An ...

With MS Word (97-2007) you can place a command (see below) in the header or
footer (Ctrl-F9) that will tell your printer with PostScript drivers to put
a watermark on the page.
Can you issue a PostScript print command in an Excel header or footer?  (I

I have created a userForm in Access.  When I open a specific Excel spread
sheet I want this form to open.  Basically, on-open populate excel with the
UserForm.  This is an entry program to format the spread sheet based on user
entry in form.

Hi Im totally new to Execl.I have a table which shows which emp is dependent
on his superior.I want to sort it hierarchially.
Example table is like this
EmpId      Dependent ID    level

Const AFile as string = "C:\xxxxx\xxxxx\xxxx.mdb" placed at the top of a  
standard module but fails to show in the procedures other than the top
procedure.
Any ideas why??