Open Excel file with filedialog and copy it into sheet 2

HI I have now an working macro to open csv file and copy it into sheet 2 as an excel file

Its working perfect and i can edit in the file.And search

For people at my work i would not like them to have this option.
But i would like them to be able to open the edited excel file and copy it into sheet 2.

So they can search from there.

When i open the csv file and copy it into sheet2 it looks like this.

So how can i make a new one similar, so they can open the excel file, and copy it to sheet 2?

I have my search option in sheet1 and its perfect

My Code for opening the csv file in sheet 2 is:
Please have a look, how i can make one similar but for the opening of excel files, and copy it to sheet2

Thanks in advance

Sincerely
Abjac

Please Login or Register  to view this content.

Ok Sorry Patel i will tell in other way ok

1. I want to open an excelfile(big 65000 Rows) With an macro(Button)
"Openfiledialog select file"
2. Then i want to have a button, like before to search for word.
"Search text in open excelfile"
When it find the rows with the "Found Rows with text i put in",
copy all rows to new sheet2 in same workbook

Before i use this code, but now not work, because
when i open excelfile, it has name( not sheet2)

No reason to copy excelfile(from Open filedialog) to new sheet. I just need to open it
But i need to copy found rows with "found text" to new sheet.

Summary:

1.One Button for openfiledialog("Select excelfile to open")
2. Onebutton for Search for text in openfile(Insensitive) and
copy found rows to seperate sheet(Sheet2), same workbook

Please have a look

My Old code to "find text" in rows are this:

Please Login or Register  to view this content.

Or Better Patal see attachments. This is how it shall work. Thanks

Originally Posted by abjac

No reason to copy excelfile(from Open filedialog) to new sheet. I just need to open it

For you no reason, but are you able to do in this way ?
I'm not. I also don't like the idea of the 3 buttons, there is a problem after file opening

edit:
test attached file

HI Patel. Its work Perfect, Perfect. I can open 4 files(65000 Rows each) And save result in one file.

This is perfect. Thanks alot.

One thing

Have a look at file.

How can i
Save Sheet3 (GetSaveAsFilename) Savefiledialog(Would like to choose with safefiledialog)
Close Sheet3( Saved)
Close SearchAllTransActions(Workbook) With no changes

All with one button "Save Sheet3"

All is working, but not with savefiledialog

I send you file have a look and see i you can find out please.

P.s File 59 kb is the last one

Thanks alot
Sincerely Abjac

Hi Patel.,
Nearly working
But SaveFileDialog comes 2 times for safe.
Try file
Please have a look if you can change so only 1 time.

Error message also not work "MsgBox Not found, Try again with another search Word"

Try with excel file Test Sheet search for other word than "mail"
No error message

Hope you can fix it.



Thanks in advance

Sincerely Abjac