Moving Macro's to Citrix

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We are in the process of moving to Citrix. How do I copy my macros to Citrix?
 
Are you talking about addins or your personal workbook (personal.xls) or...
 
Have you tried just copying your code out of your desktop version of XL and
pasting it into the personal workbook in Citrix (if I recall the ability to
have and use a personal workbook is at the Citrix admin's discression but
don't quote me on that). If that is not going to work for you then you will
probably want to change your personal workbook macro's into an addin which
you can link up to...
 
Where do I find the personal workbook?

Jim Thomlinson said:
Have you tried just copying your code out of your desktop version of XL and
pasting it into the personal workbook in Citrix (if I recall the ability to
have and use a personal workbook is at the Citrix admin's discression but
don't quote me on that). If that is not going to work for you then you will
probably want to change your personal workbook macro's into an addin which
you can link up to...
 
On your desktop version just select Tools -> Macros -> Select any of your
macros in personal.xls and select Step Into. In the VBE which will open up
Click the Stop button. You are now in one of the modules of your personal.xls
file.

In Citrix write any old macro and store it in your personal workbook. Copy
the text of the macors in each of your modules on your desktop to a module in
your Citrix VBE.
 
Thanks!

Jim Thomlinson said:
On your desktop version just select Tools -> Macros -> Select any of your
macros in personal.xls and select Step Into. In the VBE which will open up
Click the Stop button. You are now in one of the modules of your personal.xls
file.

In Citrix write any old macro and store it in your personal workbook. Copy
the text of the macors in each of your modules on your desktop to a module in
your Citrix VBE.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top