Macro and FileDialog

A

A.Q

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top