Hi,
I am trying to create a macro to import a data file into an excel sheet. I was able to record a macro,but i was only able to import the same file each time.
Can anyone help me create a macro to open a file popup menu such that i can choose the file to be imported.
I can send you my recorded macro code if you need.
One more thing, this is my first encounter with VBasic.
Please help me........
Thank you.
I am trying to create a macro to import a data file into an excel sheet. I was able to record a macro,but i was only able to import the same file each time.
Can anyone help me create a macro to open a file popup menu such that i can choose the file to be imported.
I can send you my recorded macro code if you need.
One more thing, this is my first encounter with VBasic.
Please help me........
Thank you.