View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Stone Frank Stone is offline
external usenet poster
 
Posts: 134
Default Exporting & Importing Macros

Your module was exported with a .bas file extention and if
you are trying to find it with excel's open file dialog
box, you wont see it unless you have selected all files in
the type of file box. but if you open in with excel all
you will get is a text file with the code. To import your
module into another file, do that in the VB editor.
Fileinport. make sure the file you want it in is open.

-----Original Message-----
I have a large macro which I urgently need to copy to

another PC.
Currently it is in Personal.xls on PC.1
I've tired exporting from Visual Basic Editor but cann't

seem to find
where it goes when I import it. Also I don't appear to

have
Personal.xls on the 2nd PC - do I need to create it & if

so how.
All help gratefully received with thanks. (& please make

it simple !)
John


---
Message posted from http://www.ExcelForum.com/

.