|
Hi Guys,
Have a good day.
I am just new to VBA Macro programing in Excel. I hope you can give me a sample code on how to do it.
How will I code this one - dynamic worksheets with 3 columns inside each worksheets and I will display the content of all worksheets by creating another summary worksheet?
I hope you can send me a copy of your sample code in kind at hifiger2004@yahoo.com.
Thanks in advance and God Bless
Example: TestWorksheet.xls
CONTENT of WORKSHEET #1:
Column1 Column2 Column3
aaa 1 100.00
bbb 2 200.00
ccc 3 300.00
... etc.
CONTENT of WORKSHEET #2:
Column1 Column2 Column3
aaa 1 100.00
bbb 2 200.00
ccc 3 300.00
... etc.
CONTENT of WORKSHEET #3,#4,#5... and so on...
MACRO PROGRAM - When I click the button it will generate another worksheet with the content summary from Worksheet1, Worksheet2, Worsheet3..., etc.
CONTENT OF WORKSHEETSUMMARY:
Column1 Column2 Column3 Column4
Worksheet1 aaa 1 100.00
bbb 2 200.00
ccc 3 300.00
Worksheet2 aaa 1 100.00
bbb 2 200.00
ccc 3 300.00
Worksheet3 aaa 1 100.00
bbb 2 200.00
ccc 3 300.00
...etc.
hifiger2004
|
|
|
|
|
The idea of this site is generally that you try to fix your problem and ask when you're stuck, not that you ask people to email you code.
It's also not common for people to ask VBA questions, you're welcome to do so, but I'd suspect there would be other sites more suited to VBA.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hello Christian,
By the way, I would like to comment out by saying to me - asking people to email the code. As you read my email, this is my first time to do programming in macro. And as you can see concept is that complicated. The concept is there but the "How to do it" is a big question for me.
And you know Christ it is not that complicated, it is more easier than what I thought.
Anyway, nothing is personal.
Have a nice day Christian 
hifiger2004
|
|
|
|
|
i want my application to upload a file to a folder in the server using code. i want to know how to login to the server and upload my file in a specified location or folder
thanks in advance
abdelhameed81
|
|
|
|
|
Take a look at the System.Net.WebClient class.
---
single minded; short sighted; long gone;
|
|
|
|
|
Hi,
What I want is to list all the folders in another folder
ie GameFolder >
Folder 1
Folder 2
Folder 3
I don't know where on the users computer the GameFolder will be placed so I need the program to go and find it and then list all the names of the folders that are inside.
Hope I've explained this well enough to be understood.
Thanks
Graham
|
|
|
|
|
You have a problem. Not only can the user change the name of the GameFolder, they can also change the name of it. So, what are you going to use to positively identify the REAL GameFolder?
Are you going to look for certain .EXE's or .DLL's?? Do these games write some consistent values to the registry, in consistant places?
You could look for folder names, starting at the root, but this can be a very time consuming process. You would normall start your search using the default names of folders on their default home paths, like under the Program Files folder.
|
|
|
|
|
i want to use ftp browser thats why i can upload or download any file from ftp
plz help me
|
|
|
|
|
You're looking to write your own FTP client? Or do you want to automate uploading/downloading files in your own app?
FTP Samples[^]
|
|
|
|
|
Does anyone know how I can reset the identifier seed in an sql table back to 1, using vb .net?
I have to transfer data from an access database, and I need to clear out the sql server table before the transfer.
Thanks
David Loring
!! Keep Music Live !!
|
|
|
|
|
You just need to RESEED[^] it.
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5
Ready to Give up - Your help will be much appreciated.
My website
|
|
|
|
|
Sir,
Whil;e I'm using your currecytoword function when I try to convert 1 it will display one thousand one.Please help me to rectify this problem
With regards
hashim
|
|
|
|
|
Can you post the snippet of code your using that gives you the undesired result?
|
|
|
|
|
1 - everything on this forum is a question or an answer, try a more descriptive header
2 - there is no one person you're addressing here, this is a public forum. If you found the function you're referring to in an article, that article has it's own forum where you can address it's author directly. We have no idea what you're talkng about.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi!
I have two files, "./main.exe" and "./d/code.dll" using a third file, common.dll, as a reference. VS creates two of this latest in the two directories. How can I make main.exe to use the "./d/common.dll" instead of "./common.dll"? All 3 projects are VB.NET2005
Thanks for your help
Thomas Szekeres
|
|
|
|
|
Remove the references, recreate a new reference to the dll, compile, voila. That should take of it.
I think I'm going to call my next project "Chuck Norris". It's a sure way to guarantee it's unbreakable.
|
|
|
|
|
no, it doesn't. both project's copy local property stays true by default, so it copies itself, and if I remove either dll, the whole thing collapses. If I turn one of the copy local to false, it's all the same.
Let me rephrase this... Let's take an exe project, and an already compiled "common.dll". I create a reference in the project for the dll file. What else do I have to set in the project's properties to force it to look for that given dll at "./dir/common.dll" instead of "./common.dll", relative to the exe file's location?
-- modified at 16:12 Saturday 23rd June, 2007
|
|
|
|
|
i was populating the treeview with the hard drives items.
For that i am using the following code under the TreeView1_AfterExpand method
If (e.Action = TreeViewAction.Unknown) Then<br />
Exit Sub<br />
End If<br />
If (e.Node.Nodes.Count > 0) Then<br />
e.Node.Nodes.Clear()<br />
End If<br />
Dim dirinfo() As String = Directory.GetDirectories(e.Node.Text)<br />
For count As Integer = 0 To dirinfo.Length - 1<br />
Dim dir As New DirectoryInfo(dirinfo(count))<br />
If (dir.Attributes = FileAttributes.Directory Or dir.Attributes = 17) Then<br />
e.Node.Nodes.Add(dir.Name)<br />
End If<br />
dir = Nothing<br />
Next
can i improve the code.
i am asking for the improvement because to the speed limitations.
i think there is some unuseful code which i am writing.
|
|
|
|
|
The code you've got will work about as fast as anything else. The problem is the disk I/O speed and the number of nodes you have to add to the treeview. There's really nothing you can do to speed this up, unless you populate the entire tree on your apps startup. This will greatly increase your apps startup time and limit its flexibility to adapting to changes in the file system during the execution of your app.
|
|
|
|
|
Hello,
How can I read and/or write direcly to a specified sector in the HDD ?
I need something like
"read(clusterNum, sectorNum, dataToRead)"
"write(clusterNum, sectorNum, dataToWrite)"
thanks.
|
|
|
|
|
hi everyone...
I m looking for an example code for making my exe run while startup...
Any help will be appreciated...
|
|
|
|
|
there are two options:
1.Place a shortcut in the startup item of the programs menu
2.Place a registry key in the HKey -> currentuser -> software -> windows -> current version -> run
you can find out how to do these through google1
Posted by The ANZAC : "WWBD, What Would Buffy Do?" : "I don't know man, she's stronger than me"
|
|
|
|
|
hi everyone,
i have a datagridview with 10 column at design time. At run time i add one more column(column11) to this datagridview. Now i m unable to set the position of this column(column11). i want to show column 11 as a first column of datagridview. how can i accomplish this task in vb.net
any help will be greately appreciated.
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
You can try this :
'Assume dgv is your DataGridView, col is your DataGridViewColumn<br />
dgv.Columns.Insert(0, col) ' 0 is the position of first column
|
|
|
|
|
Thanks a lot.
its work.
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
