|
|
#4
10-19-2023, 10:12 AM
|
|||
|
|||
A follow up question on this that I can't figure out.
I changed the extension of Form to .txt as that is all I am interested in, and change the code to read :- If extension = ".txt" Then path = directory & "" & VBComponent.Name & extension Call VBComponent.Export(path) ...... However, it still insists on producing an .frx file as well as a .txt file in the Visual Basic directory. Can't see how it is doing it. Must be somewhere in the VBComponent.Export bit I guess? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 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 |
|
VB Code in Excel Active worksheet
|
shakilhyd | Excel | 2 | 05-17-2010 07:50 AM |
Windows 10 
Office 2021
Threaded Mode