ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro and FileDialog (https://www.excelbanter.com/excel-programming/348768-macro-filedialog.html)

A.Q[_2_]

Macro and FileDialog
 
Hi all,
I recorded a macro: the steps that I need to open a text file from excel and
assign new header for each column. I have a class name "clsFileDialog" from
my manager, he said using that class to open the path instead of the hardcode
Path (from record macro) C:\TextFiles\myfilenames.txt, How do I call the
class? How do I code this? and also How can I assign this macro to all
user?
Thanks in advance for your help.

AQ


All times are GMT +1. The time now is 03:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com