关于mycount的讨论汇总 - 话题女王

全部话题 - 话题: mycount

T*******n
发帖数: 493

Not sure what you want:
\newcounter{mycounter}
\setcounter{mycounter}{1234}
\Roman{mycounter}
\MakeUppercase{\romannumeral1234} % for a constant, no {} around constant

i**M
发帖数: 108

来自主题: Quant版 - VBA code sos

ThisWorkbook.Activate
Sheets("aa").Activate
mycount = Application.CountA(Range("A5:A100"))

For i = 2 To mycount

transdate = Cells(i, 1).Text
NameFile1 = "C:\Documents and Settings\Desktop" & bb& ".xlsx"
Set wb =Workbooks.Open(Filename:=NameFile1)
Next i
I want to read files' name from a spreadsheet and open those files. The
above is the vba code I wrote, but i got "application defined or object
defined error". I am a beginner of vba, anyone ple... 阅读全帖

topics