I am trying to write small macro with two buttions where one will open the file from some directory and another exports the file that file into some other direcotry after validation in the data. but I am having
Type Mismatch error, I am very beginer and not able to figure out also I am not sure I am doing it in right way, here in my code below
Please Login or Register to view this content.
Last edited by Leith Ross; 12-06-2010 at 12:28 PM. Reason: Added Code Tags
Hello smriti,
Welcome to the Forum!
Please use code tags when you post your code. It would help to know where the error occurs. Which line in the code is causing the problem?
Last edited by shg; 12-06-2010 at 01:29 PM.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
HI thanks for the reply and I will follow that next time, it says Type Mismatch in the
f.write Cells(ActiveCell.Row, 2).Value + "," 'RATECODE
in Sub ExportFile() section of the code
to give you a small overview of what im doing, I have two buttons open file and export file,
Open file opens the file and its working fine I can see the data but its not exporting to the different directory i want that is where I am having an error
Any help would be appreciated
Thanks
Hello smriti,
Since your file already exists and you want to add data to it, you need to make the change below.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks