Search:
Type: Posts; User: MarkGinAZ
Search:
Search took 0.02 seconds.
-
Ok, This helped, I'm able to get values from the cells now.
Public Sub WriteToFile(ByVal objWriter As StreamWriter, ByRef arrayName(,) As Object)
Dim numOfRows As Long, numOfCols As Long
-
Hi, my program allows the user to select a group of cells in Excel and then store them in an array, but when I try to get he values from the array, it crashes. I know it has something to do with the...
-
Thank you both for your help. I really appreciate it. I did find similar information. This is what I have now:
Dim myRange As Excel.Range
myRange = CType(xlApp.Selection,...
-
Ok, never mind. I think I have it.
Best regards,
Mark
-
Thank you for the code snippet, I tried it and it works in that it grabs the cells. How would I get individual cell information from that?
-
Yeah I've seen a lot of code, but it's always either "All of the cells", or cells that have been selected in VB and given a range already. I need to be able to let the user select the group of cells...
-
Hi Luke,
No, the Excel file name will change every time. The selection cells will also change every time.
All I have is what I think may work to recognize the already open Excel file:
Public...
-
Hello,
I would like to extract user selected data from an already open Excel file. I have looked all over the Internet and have found pieces I could use, but they always open a file, not use a file...
-
Never mind I figured it out. I got rid of the Main, and am now just using frmMain.vb. I moved the code from Main into frmMain_Load.
-
Hello, I have a "Main.vb" and a "frmMain.vb". In the Main I have the following:
Module Main
Dim oForm As New frmMain()
Public exciteArray()
Sub Main()
Dim oAnsoftApp
...
|
Click Here to Expand Forum to Full Width
|