EXCEL VBA EXPERTS HELP!!!!!!!!!!!!!! - Sajha Mobile
SAJHA MOBILE
EXCEL VBA EXPERTS HELP!!!!!!!!!!!!!!
Posts 6 · Viewed 4383 · Go to Last Post
Sukuchha
· Snapshot
Like · Likedby · 0

Hello ,

I am a novice in a VBA excel and i am facing a problem which is as follows:  I need to open 50 xls files and store its filename as erray function  so that i can use it for further calculation.

Thanks

 

Maverick_
· Snapshot
Like · Liked by · 0
What is ur problem? to open or to save??
nepalikanchha
· Snapshot
Like · Liked by · 0

LOL! Yes, please elaborate.

Raj_Raj
· Snapshot
Like · Liked by · 0
Create a table in access and import all the spreadsheets in the table...Do you calculation or whatever..Much easier......
techGuy
· Snapshot
Like · Liked by · 0
jfgi
akawi
· Snapshot
Like · Liked by · 0
Make a file such as "files.txt" with the names of all excel files in it. In your macro add:

    Open "files.txt" For Input As #1
    For i = 1 To 100 '(number of files =100)
        Input #1, fName ' fName is the name of file.
***********     
'Add your macro here: eg.,
workbooks.open(fName)
' Other scripts


workbooks(fName).close 'better to close the excel file before opening next
************

    Next i
    Close #1 'don't forget to close the text file

Please log in to reply to this post

You can also log in using your Facebook
View in Desktop
What people are reading
Visitor is reading साझाबासिहरुलाई प्रियंकाको नया कोसेली
Visitor from US is reading EXCEL VBA EXPERTS HELP!!!!!!!!!!!!!!
Visitor is reading salman khan Getting Married
Visitor is reading Planning to buy my first car but need help from you guys..
Visitor is reading !!!HELP HELP HELP!!! I'm in a big trouble
Visitor is reading best calling card for nepal
Visitor is reading नेपालमा आमाले बच्चा मार्नपौने कहिले देखी कानून ले दियो
Visitor from SG is reading CAMPION ACADEMY
Visitor is reading Looking for a room/roommates in Richmond,VA
You might like these other discussions...
Sexy In Sari
Nepali Migrants Frustrate Indian Store Owner
· Posts 1 · Viewed 113
saipal » saipal
Quitting job and Rental income in USA and Nepal
· Posts 3 · Viewed 469
IamDJ » username619
TPS Re-registration case still pending ..
· Posts 96 · Viewed 22625 · Likes 22
haal haal pandit » haal haal pandit
" अनि ग्रिन कार्ड बन्यो त ?"
· Posts 4 · Viewed 572 · Likes 2
logan
कुनै कुनै state मा ढाल र गुलाफ बिक्रि बितरण बन्द हुने
· Posts 1 · Viewed 110
apunge » ShreeRaam
TPS EAD auto extended to June 2025 or just TPS?
· Posts 15 · Viewed 2430
haal haal pandit » haal haal pandit
TPS visa for future wife !
· Posts 24 · Viewed 2180
Tps8249 » ShreeRaam
Trump to Vegas Supporters: 'I Don't Care About You, I Just Want Your Vote'
· Posts 6 · Viewed 407
Sajha Classifieds
Classifieds Summary: Room/Apt in MA
· Posts 1 · Viewed 78
NepalNews Sajha
News Summary from Nepal for Monday, June 10, 2024
· Posts 1 · Viewed 83



Your Banner Here
Travel Partners
Travel House Nepal