Export/Import Question

[Ken Loomis]

I am trying to send a friend of mine a utility for her to use at work but
her company's virus protect is stripping out all the macros. She doesn't get
the option to just save the file.

I thought I might be able to export the VBA and then have her import it.
This seems to work well for the module, however, much of the code is in the
workbook and when I export that, it get saved with ".cls" extension, which I
assume means 'class'. When I import that, it creates a new Class Module.

Is there anyway around that?

TIA,
Ken

 

[Tim Williams]

Have you tried zipping up the workbook before sending it?

Tim.

 

[Ken Loomis]

Thanks, Tim. I hadn't thought about that.

I can't test this again on her system until Tuesday, but my virus filters
were also trapping the workbook when I sent it to myself.

I just tested the zipped file idea and unfortunately that got trapped by my
virus filter.

However, I have tried the following methods to see if I could get it past my
anti-virus system:

1) Changed the extension to '.txt'

2) Cut out the VBA code and saved it as text, so now I have an Excel file
and 2 text files to be inserted using the VBE

3) Exported the workbook code and the module code, to be imported on her end
in the VBE. The workbook code is imported as a Class Module, so that code
will need to be copied to the workbook and the class module deleted.

All three of those methods got past the anti-virus system

Thanks for the suggestion.

Ken

 

[Ken Loomis]

Another note.

After Tim suggested zipping the file, I thought about using StuffIt, which
is very popular on the Mac platform and is available for Windows. It
compresses/expands many different formats, one of which is proprietary.

I compressed the workbook using their proprietary compression format and
then email that to myself. This worked and got past the virus filtering
system.

Then I used StuffIt to create a self-extracting archive and sent that to
myself. That also got past my virus filters.

So I think at least one of these methods will get past her virus detection.
I hope anyway.

Thanks,
Ken


There is a free download called