Solved To an import excel file exists (1 Viewer)

smtazulislam

Member
Local time
Today, 04:55
Joined
Mar 27, 2020
Messages
806
Hello,
In this form browse button VBA code is string and instant successfully in the path box.
But problem is file not exists as same name. where import table field are same. It was instant between name LIKE filename._xlsx1, filename_xlsx2,. I want to import table append copy in same table name.

Can help any ? Thank You
 

Attachments

  • Capture.JPG
    Capture.JPG
    28.5 KB · Views: 88
Last edited:

June7

AWF VIP
Local time
Yesterday, 17:55
Joined
Mar 9, 2014
Messages
5,466
The file name examples are odd. Why?
 

June7

AWF VIP
Local time
Yesterday, 17:55
Joined
Mar 9, 2014
Messages
5,466
Never seen a file extension with underscore. Nor underscore and no period. Nor Excel file name with number suffix
 

Pat Hartman

Super Moderator
Staff member
Local time
Yesterday, 21:55
Joined
Feb 19, 2002
Messages
43,233
Why is your browse button not opening a windows file dialog? Then the user just picks a file and gets an error if he doesn't.
 

smtazulislam

Member
Local time
Today, 04:55
Joined
Mar 27, 2020
Messages
806
I draw your attention to an Edit I made to your Post:-
I am sorry for late reply.
I am appropriate your kinds help. Thank you so much for there are your nice advice and also your thread point is nice,. MajP is give helpful solution what I exactly needs. And this thread is Solved
 

Users who are viewing this thread

Top Bottom