在用excel做文件导入时发现，一旦使用Commond Dialogs 就会出错
“The control could not be created because it is not properly licensed”
原因是，Commond Dialogs are not licensed to be used in Excel。经过搜索发现，其实VBA还有其它的法子获得文件路径。
Private Function OpenDialog() As String
Dim sFile As String
Dim n As Integer
'获取路径
sFile = Application.GetOpenFilename("MS excel (*.xls), *.xls")
'获取文件title的长度
n = Len(sFile) - InStrRev(sFile, "\")
'获得文件title
tt = Right(sFile, n)
End Function
Pingback: EXCEL VBA笔记(不断更新中) | 津津有味Jjuv Blog
canadian drugs pharmacy
http://expresscanadapharm.com/# online canadian pharmacy reviews
canadian pharmacy 24h com
They provide access to global brands that are hard to find locally.
fluoxetine buy
Get here.
The pharmacists always take the time to answer my questions.
cost of generic cytotec price
The drive-thru option is a lifesaver.
Their worldwide services are efficient and patient-centric.
can you get generic lisinopril without a prescription
They provide international health solutions at my doorstep.
Always professional, whether dealing domestically or internationally.
gabapentin 100
Their commitment to global excellence is unwavering.
priligy near me N desmethyltamoxifen DM Tam Z endoxifen and CYP2D6 phenotype significantly correlated across ethnicities R 2 53, P CYP2C19 and CYP2C9 correlated with norendoxifen and Z 4 hydroxytamoxifen concentrations, respectively P P Z endoxifen P 0