excel error visual basic compile error in hidden module distmon Collingswood New Jersey

Address 1805 S 18th St, Philadelphia, PA 19145
Phone (267) 293-9597
Website Link http://technesia.com

excel error visual basic compile error in hidden module distmon Collingswood, New Jersey

Excel looks at the last 3 letters, not the nam as a whole. Thanks, Tamsin Like Show 0 Likes(0) Actions 31. Thread Status: Not open for further replies. The file is located on a shared drive and when other users access it they are getting the message that there is a compile error in module 2, i.e.

Should I repair Excel 2007 - or go back to Excel 2003?? The new laptop already had Adobe 8.0 installed. I then waited patiently about 15 minutes for the install and... Just remove them.

I couldn't understand why the fix wasn't working. Close the Visual Basic editor 4a. Are you looking for the solution to your computer problem? What settings do I need to change to enable the Macro to run?

This is not limited to occurence with one specific bit of code but happens intermittently. What is a Macro? A macro is a smal ... OBVIOUSLY WHEN I SAY THE SAME ERROR I WENT THROUGH ALL THE FOLDERS ADMIN, DEFAULT, MY CLIENTS NAME THEN YOU KNOW THE REST DELETE THE CRAP FILE AND OFF I WAS Transkript Das interaktive Transkript konnte nicht geladen werden.

When I open the same Excel file on my laptop (running Excel 2010) I get a Microsoft Visual Basic screen (that relates to one of the Macros) pop up and the userform2 i think its referring to. Once removed, I opened up Excel 2007 and the error was gone. Any ideas?

Does anyone know why? I've tried something like this: Sub FirstModule() 'Code 'Code 'Code SecondModule End Sub Sub SecondModule() 'Code 'Code 'Code End Sub ...but I'm getting an error that says "Compile error: Expected variable I also deleted previous versions of Adobe on my systems, don't think that made a difference. Click the visual Basic editor button on the developer tab 2.

What might cause that error message? I have converted the file from *.xls to *.xlsm. Similar Excel Tutorials Error bars in Charts in Excel How to add, manage, and remove error bars in charts in Excel. Chart Hidden Data in Excel How to show data from hidden rows and columns on a chart in Excel.

Tech Support Guy is completely free -- paid for by advertisers and donations. Like Show 0 Likes(0) Actions 14. I have added the Solver Add-in and enabled Macros after I open the Workbook. Thanks for the help - that message was so annoying.

Advertisement alexenjen Thread Starter Joined: Aug 3, 2000 Messages: 526 I'm getting the following error after opening any office program(s), such as; Word, Excel, Outlook.... Any ideas about how to fix? Removing PDFMaker.xla from the profile directory seems to have eliminated the message. I attempted this solution, but failed: http://www.adobeforums.com/cgi-bin/webx/.3bc307c7 http://support.microsoft.com/?id=307410 - I've uninstalled and reinstalled Office 2003; run repair w/in Excel; no effect - In Internet Explorer, I can open a PDF successfully,

Cheers Reply Basetty Srinivasulu says: October 9, 2009 at 7:10 am It works well. Like Show 0 Likes(0) Actions 38. Share it with others Like this thread? Reply Jim Barta says: September 9, 2008 at 1:52 pm I just did a search for files and folders PDFMaker.xla and got two results.

All rights reserved. By using our website you consent to all cookies issued by this website. The following is a list of repairs:" "Lost Visual Basic project." Any idea why I'm getting this? Bitte versuche es später erneut.

That didn't make any difference. Please help! renaming the file in the profile settings did not work but deleting it did! I have had this issue with some users in my network running Acrobat 8.1 and Office 2003 on brand new machines.

Wird verarbeitet... Long story short the tech dept did not have the answer and after an hour of troublshooting he said it was an issue with MS. Insert -> Module 2. Like Show 0 Likes(0) Actions 39.

Voila.. Thanks Like Show 0 Likes(0) Actions 3. I have created an Excel file on my desktop (in Excel 2007) that contains some basic macro commands. I found two of the files under documents and settings.

Reply Jesal says: November 19, 2010 at 7:11 am Thanks - did the trick :) Reply Rick Malamed says: September 24, 2010 at 2:50 am I found PDFMarker.xla in several locations Re: "Compile Error in Hidden Module: Distmon" (David_P._Hahn) Apr 25, 2007 9:01 AM (in response to (dork_92618)) I called Adobe first for support... also I can't understand, Sheet3 has no subs, so why is data populating into an empty sheet and THEN generating a compile issue (which is what it sounds like)? Like Show 0 Likes(0) Actions 17.

Re: "Compile Error in Hidden Module: Distmon" (Summer_Folsom) May 3, 2007 11:31 AM (in response to (dork_92618)) I am having the same problem today. I understand that it's not allowing me to use the name of a module as a procedure, but I can't find any information on how to call the second module. The full messages says: "Compile error in hidden module: M_Base" Reply Donna Thompson says: November 24, 2010 at 5:44 pm I deleted two different PDFMaker.xla files and all works great now. I can not save or do anything and the only way I can get rid of this box is to bring up "Task Manager" and "End Task" on the Excel spread

Please turn JavaScript back on and reload this page. I deleted the pdfmaker.xla file and Adobe 6.0. Hope this helps. And should I remove Reader 7.0.9 altogether if it's not a good idea to have both Acrobat and Reader?

dph Like Show 0 Likes(0) Actions 11. Nächstes Video Microsfot Excel Macro How to fix error Compile Error User Defined type not dectected - Dauer: 1:05 Vis Dotnet 13.266 Aufrufe 1:05 Enable macros - Dauer: 4:08 John Girshovich