Click here to Skip to main content
15,664,273 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
Hi , Friends

Is it possible to extract phone books ( sim card , All ) in vba with Open Statement ?


What I have tried:

could not find any code to try this
Updated 18-Jan-22 2:45am

AFAIK You still cannot run VBA in Excel on Phones, and Microsoft had no plans to make it so (although you haven't said what platform you are using).
You would need to use Office-js instead, but even then I doubt you could use the equivalent of Open as the Phone Book is not stored as a Text File.
Share this answer
Maciej Los 18-Jan-22 8:38am    
If you did export phone book (contacts) to a text file (vCard), you can open it via VBA - using OpenTextFile method (Visual Basic for Applications) | Microsoft Docs[^].
Note: depending on version, you'll be able to extract less or more data. See: vCard - Wikipedia[^]
Share this answer
[no name] 18-Jan-22 9:23am    
So , How can we extract Phone number from cellphone

Is it possible tbrough Open Statement And using AT COMMAND , have been ever tried by someone?
Maciej Los 18-Jan-22 14:52pm    
Did i wasn't clear enough?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900