Click here to Skip to main content
15,867,308 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 ?

Thanks

What I have tried:

could not find any code to try this
Posted
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
 
Comments
Maciej Los 18-Jan-22 8:38am    
5ed!
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
 
v2
Comments
[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