s*******n
发帖数: 24 | 1 如题，最好与ACCESS有关
我学了Java两年，C++一年
顺便问一下，学VBA容易吗 |
|
h**k
发帖数: 662 | 2 VBA debug 不要太容易，debug line by line 一分钟就能找到问题
Sub ypadtorightFor50CharacterString()
★ Sent from iPhone App: iReader Mitbbs Lite 7.56 |
|
|
a**h
发帖数: 1085 | 4 算法流程都有了，就是需要请熟练VBA EXCEL开发的写手，每小时要付多少啊？
如何验收code?比如说每小时50行，等等。 |
|
z**********i
发帖数: 102 | 5 我需要用VBA去读很多text file, 请问用什么方式读区是最优化的，占用内存最小的。
每个text file都很大。可以给个例子吗？谢谢 |
|
h******b
发帖数: 6055 | 6 VBA还是很handy的。
最近帮老板整一个大报告，需要很多数据支持，给他写了几个user defined function
节省我好多时间。不用重复劳动了。直接copy paste。 |
|
y********l
发帖数: 3970 | 7 我有时候用Excel里的VBA调用IE在网上抓点数据。但这个IE automation经常出问题。
最常见的问题是IE停止工作了。或者IE长时间不ready，也就是readystate=4这个条件
好久都不能满足。请问有哪些方法能让这个automation更robust 一些？如果有比
automation更好的解决方案，请赐教。谢谢。
我的程序的大致结构如下
Set IE = CreateObject("InternetExplorer.Application")
for i=1 to 1000
With IE
.Visible = False
.Navigate strWebAddress
Do Until .ReadyState = 4: DoEvents: Loop
End With
strWebContent=IE.Document.body.innertext
Process strWebContent
Next... 阅读全帖 |
|
p****e
发帖数: 3548 | 8 抓数据都用MSXML2.XMLHTTP吧，用IE automation太慢了
你可以把VBA当成python之类用，因为他们都是单线程，通过DLL或者COM来调用各种库
，实现多线程等的复杂功能 |
|
|
x****u
发帖数: 44466 | 10 vba可以调用activex，所以几乎可以当一切windows下软件的胶水 |
|
r****y
发帖数: 26819 | 11 ms office 2008 for mac? No VBA |
|
m**********2
发帖数: 2252 | 12 是，Mac excel 2008不能用VBA,我google了一下说要transfer成applescript，不知道
这个怎样用？ |
|
r****y
发帖数: 26819 | 13 try NeoOffice. It supports VBA |
|
m**********2
发帖数: 2252 | 14 谢谢。下个星期回去试试。
另外mac excel 2004是不是support VBA的？ |
|
|
s********y
发帖数: 979 | 16 想用VBA在PPT中插入一张图片，这个图片总是在PPT同一个目录下面，所以看网上说不
需要指定路径，但是老是出错。把MACRO写好直接运行没有问题，把PPTM关了再打开就
找不到文件，这是什么问题？
Sub test()
Dim objPresentaion As Presentation
Dim objSlide As Slide
Dim objImageBox As Shape
Set objPresentaion = ActivePresentation
Set objSlide = objPresentaion.Slides.Item(3)
Set objImageBox = objSlide.Shapes.AddPicture("apples.png", LinkToFile:=
msoTrue, SaveWithDocument:=msoTrue, Left:=90, Top:=130, Width:=250, Height:=
300)
End Sub |
|
S*********g
发帖数: 5298 | 17 The VBA is not case sensitive.
It will automatically change the case according the first occurence
of this name. |
|
s*****r
发帖数: 59 | 18 Here is an example, I need to search a row for a certain value, then I need to
search a colum for a certain value. Then I need to locate the value indexed b
y the row number and column which returned by my search.
How could I do it? especially when I use range object, how could specify the c
ell address by using the row number and column name which was returned by my p
revious search?
Also, to fill a column with certain pattern of values, when I write my VBA cod
e, I don't know how to let excel |
|
s******e
发帖数: 493 | 19 I believe that u can find ur ans from msdn vba programming for excel. I used t
he online lib to help me code in perl. It was very helpful. |
|
s*****r
发帖数: 59 | 20 in excel VBA, how could a person specify return a string B from string A,
where string B=start 4th charactor in string A, and string B's length is 5?
Thanks.
Also, when do a file search under a dir. , how could returned file name keep
its uppercase/undercase? like if the file name is "HelloWorld", how could
keep it the way it is instead of "helloworld" ? Thanks. |
|
s********n
发帖数: 154 | 21 由于我的数据很多，不得不用VBA来运算。我的计划是先用sort功能对n个数据排序(这
一步我已经实现了)，然后再来查找中间行(利用公式(n+1)/2 or n/2)。现在的问题是
我的数据是不完整的，也就是说有一些空格，如果有空格在里面，实际上的有效数据只
有k个，而且k值不定，在此情况下我该如何查找中间行？ |
|
s*****r
发帖数: 59 | 22 excel VBA: need to use global value, how to declare it, and where to assign
its initial value? Thanks. |
|
Z****e
发帖数: 2999 | 23 if it's just data that you cared about, use csv format; if there's also some
formatting required for the data, then it's a lot harder: you can use VBA
to extract data and save it to external format. The reason is that I don't
think there's a fortran compiler that supports calling Excel COM object from
Fortran...
, |
|
d********t
发帖数: 837 | 24 Hi all, I wonder if anyone knows how to save a VBA macro in a newly created
excel spreadsheet using vbscript? Thanks. |
|
p******n
发帖数: 874 | 25 VBA has it's own method to list all files and directories. |
|
h******e
发帖数: 1791 | 26 【 以下文字转载自 Statistics 讨论区 】
发信人: hehehehe (入了大圣教，心中充满喜乐), 信区: Statistics
标 题: 请VBA牛人现身。
发信站: BBS 未名空间站 (Fri Sep 17 09:48:45 2010, 美东)
请看下面的code，如何改写它以达到如下目的：
自动选择word里的路径和文本文件文件名（假设已经存在，可以编辑的），而不是像现
在这样是固定的。
Sub Macro1()
'
' Macro1 Macro
'
'
Selection.WholeStory
Selection.Copy
ChangeFileOpenDirectory _
"C:\Documents and Settings\UserXP\My Documents\My SAS Files"
Documents.Open FileName:="T16_7_2_1.txt", ConfirmConversions:=False, _
ReadOnly:=False, AddToRecentFile |
|
m******u
发帖数: 12400 | 27 但在excel sheet spread上，如果在cell内输入“=MOD(3, 2)”，excel会在相应cell
里填入“1”。这个用法表明它是个function。
诚如你说说的，在VBA里，改成 m = i Mod 2， 就work了。
其中两者肯定有些不同有什么原因。
谢谢你。 |
|
|
c********9
发帖数: 53 | 29 【 以下文字转载自 Programming 讨论区 】
发信人: chihuahua9 (吉吉), 信区: Programming
标 题: 求VBA sample
发信站: BBS 未名空间站 (Tue May 25 15:15:51 2010, 美东)
在每个月的10号generate PowerPoint slide from excel worksheet
求哪位大侠给个相关的codes，有包子报答！ |
|
m*********u
发帖数: 1491 | 30 Nice to know you 最近赶文章，需要机械化处理大批的数据.
See again, Bio people is doing 处理大批的数据 in their work.
Therefore, it is relatively easy for Bio people to switch to Database
Analyst filed.
About the ebook, Please google: free VBA ebook download
you will find many.
Good luck and enjoy 处理大批的数据.
文章 is not important, skill of 处理大批的数据 will help you find a better
job later. |
|
l**t
发帖数: 170 | 31 solver里option里那个load model到底怎么用，愣是不懂得说
还有用VBA如何用solver,查到几个函数，关于solver的，
但是还是不大懂，那里有example吗？
多谢！ |
|
p*********l
发帖数: 30 | 32 Could you recommend some good books to study Access VBA from beginner,
intermediate to advance level? Thank you! |
|
M******e
发帖数: 48 | 33 估计常看programming版的更熟悉VBA
可以自己先学，有问题写出来问 |
|
K***a
发帖数: 32 | 34 位高人帮忙推荐一本VBA的书。 本人零基础。多 谢 ! |
|
c********9
发帖数: 53 | 35 【 以下文字转载自 Programming 讨论区 】
发信人: chihuahua9 (吉吉), 信区: Programming
标 题: 求VBA sample
发信站: BBS 未名空间站 (Tue May 25 15:15:51 2010, 美东)
在每个月的10号generate PowerPoint slide from excel worksheet
求哪位大侠给个相关的codes，有包子报答！ |
|
t***o
发帖数: 9 | 36 The candidate has to be proficient in VBA and fluent in English. Will work
at Stamford, CT with the UBS IT support team. This is mainly a supporting
role, with some light development work. Knowledge in C# is a plus, but not
essential.
If you are interested, please send your resume to t*******[email protected]
Thank you very much. |
|
f***7
发帖数: 46 | 37 I have a xml file contains some long numbers (20 characters)
When I use vba to import the xml to excel, excel automatically converts it
to a scientific number such as 3.222E19 with last 6 characters replaced by 0
. I want the entire 20 characters as a text.
How to solve it?
Thank you |
|
a***m
发帖数: 666 | 38 不知道发在哪里好，就发这里了。这里能人多，能不能帮我一个忙。我正在学excel
VBA，今天遇到一个pivot table问题。The routine is to filter the page field
for the dates before 30 Nov 2013. But it doesn't work. The system pops up an
error message: object or application defined error. 可是我找死都找不到问题
在哪里。也许你们看到那个inputbox function 很奇怪。本来我想通过它输入一个日期
，然后pivot table根据输入的日期自动filter the pivot table。但是有问题。我就
用30/11/2013来测试。可惜还是没反应。愁呀，求大牛帮忙，不胜感激。
Sub Update()
Application.Calculation = xlCalculationManual
Worksheets("pivot").Select
ActiveSheet.Pivo... 阅读全帖 |
|
|
p*********l
发帖数: 30 | 40 Could anyone recommand some introduction readings in VBA, and/or CDO? Thank
you. |
|
K******r
发帖数: 152 | 41 Just google VBA, you should find lots of stuff about it |
|
m****d
发帖数: 331 | 42 hehe... let me change my question, MatLab+VBA are good enough for quant
positions in risk management? and/or any other areas? |
|
w*******1
发帖数: 3 | 43 Is there anyone proficient with VBA? Or any suggestion on the sources to use
for a beginner. Thanks! |
|
t*****l
发帖数: 121 | 44 All the VBA problems I had can be answered by google.
use |
|
w*******1
发帖数: 3 | 45 A zip file includs 10 monthly data sets and it is about 100 stocks each
month covering 5 countries. Some columns are date, sector, country, month
return ....I have import the data from text file into a workbook. Please
help with the following request:
1. How to write code that will caluculate and write out into a sheet the
sector return for each month by country. Should I generate a separate sheet
to loop through all the cells?
- New to VBA |
|
p******a
发帖数: 23 | 46 You can do it in Excel Pivot table. This is more straight.
Also, you canfollow your original idea, loop through each row and create
functions to process each row. You probably need to create data structure to
hold the intemediate result, more loops are needed when you aggregate the
data by country. month and sector. Then you need to write data to a seperate
sheet, in a loop. It's doable. y'll get solid VBA experience though this
excercise. |
|
d*g
发帖数: 66 | 47 偶然间看到几个VBA Developer 的职位
请问如果做software engineer, 这个在大公司是不是还不错？ |
|
d*g
发帖数: 66 | 48 Actually I am curious too. I saw some jobs on monster (NY investment bank)
as VBA Developer, about 80k-120k
Do not understand why they do this. |
|
n******y
发帖数: 192 | 49 I like you ID.我想学会vba得语法，金融的东西应该不难把 |
|
s***5
发帖数: 15 | 50 买一本VBA的教材，然后做点二叉树，就差不多会了 |
|
