Re: VBA & User Form modules vanish

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks for that Tom - I've checked the settings and there seems to be
no hint of a transition default hijacking the code. I'm starting to
wonder if my Excel installation is corrupt in some way - I'm also
having trouble killing a custom toolbar despite erasing all the
personal.xls and .xlb files I could find! Will ask IT to re-install and
see if that helps


Tom Ogilvy wrote:
It could be that at some point the file is being saved in the Excel5/95
format. This format does not support Userforms or sheet module code and this
code and userforms are removed. I would see it being accidentially saved in
this format because of the default format setting in the Transformation tab
of tools => Options rather than some 3rd party program.

--
Regards,
Tom Ogilvy



"Pete" wrote:

Can anyone shed any light on why/how an Excel spreadsheet could
mysteriously "lose" the modules for both user forms and VBA? It seems
to be happening on emailing using Outlook, but the real mystery is that
it's intermittent - a spreadsheet sent one day will arrive without the
modules but if I re-send it then it will in all likelihood keep the
modules.

I have been told it might be 3rd party email safety software but if
that's true then why aren't all my spreadsheets stripped of the modules
when I send them?

Any hints gratefully accepted

Peter UK



.

Relevant Pages

  • Re: fixed length file to excel? VBA macro possible?
    ... Tom was pointing out that Excel expects every row to be the same, ... Because i need to format the lines that start with say 02 differently ... Dim FileName As String ...
    (microsoft.public.excel.programming)
  • Re: Combo box problem
    ... Tom ... > Remove the fixed in the format so that it is blank ... >>> many other words are reserved words in ACCESS, ... >>> List of Microsoft Jet 4.0 reserved words ...
    (microsoft.public.access.forms)
  • RE: CANT CONNECT TO AD (VERY URGENT!!)
    ... If you can ping the gateway and DC, it may be your settings. ... DNS that is provided points to you primary and secondary DNS servers. ... "Tom B" wrote: ... to fix the active directory. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Query Help Please! Is a Weekly data format Possible?
    ... Thanks for the reminder, Tom. ... "Tom Ellison" wrote: ... the DatePart function I used will work on a date that is in string ... That is why I asked for the format. ...
    (microsoft.public.access.queries)
  • Re: Combo box problem
    ... Remove the fixed in the format so that it is blank ... "Tom" wrote: ... >> many other words are reserved words in ACCESS, ... >> List of Microsoft Jet 4.0 reserved words ...
    (microsoft.public.access.forms)