Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-19-2023, 11:44 AM
MC147 MC147 is offline Copy the Code from an Excel Form to a Worksheet automatically Windows 10 Copy the Code from an Excel Form to a Worksheet automatically Office 2021
Advanced Beginner
Copy the Code from an Excel Form to a Worksheet automatically
 
Join Date: Feb 2022
Posts: 50
MC147 is on a distinguished road
Default


Yes, it is but I changed the Case Form to .txt so it could be opened easily. The point is, though my following line If Extension = 'txt' is meant to exclude anything that no longer has an extension of text. I have debugged the code and no file other than extension of.txt get through to the Call VBComponent line, so how is it still producing files with extension of .frx ? Or am I missing something obvious here?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy the Code from an Excel Form to a Worksheet automatically Link UserForm checkbox to corresponding shape on one worksheet and copy to 'template' worksheet kiwimtnbkr Excel Programming 23 10-08-2020 02:32 AM
Need to copy specific ranges column data as row data from one worksheet to another using excel VBA ganesang Excel Programming 1 03-26-2020 06:18 AM
How to get Excel to automatically continue a pattern which is form as 001-01-01 ....003-03-03 anakonda93 Excel 3 04-16-2018 12:01 AM
Automatically copy/paste a form field onto new pages, with user input included Pindar Word VBA 3 01-13-2017 11:49 AM
Copy the Code from an Excel Form to a Worksheet automatically VB Code in Excel Active worksheet shakilhyd Excel 2 05-17-2010 07:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:14 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft