+ Reply to Thread
Results 1 to 11 of 11

VBA macros:Personal Macro Workbook

Hybrid View

Larry.LeBlanc@O VBA macros:Personal Macro... 03-18-2010, 04:25 PM
shg re: VBA macros:Personal Macro... 03-18-2010, 04:32 PM
Larry.LeBlanc@O re: VBA macros:Personal Macro... 03-18-2010, 04:47 PM
royUK re: VBA macros:Personal Macro... 03-18-2010, 04:49 PM
shg re: VBA macros:Personal Macro... 03-18-2010, 06:24 PM
romperstomper re: VBA macros:Personal Macro... 03-18-2010, 06:59 PM
shg re: VBA macros:Personal Macro... 03-18-2010, 07:04 PM
romperstomper re: VBA macros:Personal Macro... 03-18-2010, 07:12 PM
shg re: VBA macros:Personal Macro... 03-18-2010, 07:17 PM
romperstomper re: VBA macros:Personal Macro... 03-18-2010, 07:09 PM
romperstomper re: VBA macros:Personal Macro... 03-18-2010, 07:22 PM
  1. #1
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,971

    re: VBA macros:Personal Macro Workbook

    You could also just rename the file as .txt rather than .bas before emailing it. Simpler than altering the Level1Remove registry key.
    Everyone who confuses correlation and causation ends up dead.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    re: VBA macros:Personal Macro Workbook

    Level1Remove registry key
    Say what? Is that more osbcuria, more arcania?

    The only reason to keep the .bas extension is that it's compatible with importing in the VBE. If you're going to send a text file, just copy and paste into Notepad from the VBE.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,971

    re: VBA macros:Personal Macro Workbook

    Quote Originally Posted by shg View Post
    The only reason to keep the .bas extension is that it's compatible with importing in the VBE. If you're going to send a text file, just copy and paste into Notepad from the VBE.
    Whilst that is usually true, if you've tweaked it (e.g. to change the instancing or add a default property or the ability to enumerate your own collection) you want to export the module, not just copy it. That probably does count as arcana though...

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    re: VBA macros:Personal Macro Workbook

    I don't grok that at all. Is that unique to class modules? It results in the exported bas file including attributes other than just module name?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1