No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
Hi All, I'm a student who really need help in this problem...what I need to do is to call/run/execute a subroutine using a varaible name from a subroutine. [code] Public Sub Main(ByVal subName as String) Call subName ' subName may be contain the value AAA or BBB End Sub '=========================== …
|
|
|
Hello All, I need some help to convert the macro I recorded in Excel into a working Vb.Net application. It involves attaching a file into a Excel cell. The file is a Word document named "File.doc". Here's the recorded macro: Sub DemoAttachFile() Workbooks("Book1").Activate Sheets("Sheet1").Select Range("B2").Select ActiveSheet.OLEObjects.Add(Filename:= _ "C:\Documents and Settings\File.doc", … |
|
|
Hello All, I am in a roadblock right now and I really need some help on the code below. What I wanted to do is close all opened workbooks. This code does the work IF there is at least one or more opened workbooks. My problem is IF there is …
|