Copy Data From Mshflexgrid To Excel
Hello,
In the Mshflexgrid, I have highlighted some rows with yellow color, how can I copy that to excel.
I am able to copy all the data correctly from mshflexgrid to excel, but only the color is not getting copied.
is there any way I can do that.
Thanks a lot
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
MSHFlexgrid Data To Excel
hi
i have grid that display data in below format:
Year | Amt1 | Amt2 | Tot1 | Amt3 | Tot2
2000| 100 | 200 | 300 | 400 | 700
2001| 200 | 300 | 500 | 500 | 1000
I have been able to display the data in Excel in below format:
Year | 2000 | 2001
Amt1| 100 | 200
Amt2| 200 | 300
Tot1 | 300 | 500
Amt3| 400 | 500
Tot2 | 700 | 700
Now what I want is to format the Tot1 and Tot2 and corresponding values of Tot1 and Tot2 in excel in BOLD Letter.
I can BOLD Tot1,Tot2 and so on if there is any, but not been able to bold the values of Tot1 and Tot2.
How is possible?
Thanks
Export Data In MSHFLEXGRID To EXCEL
Hi there peeps.
Can someone help me how to do export the data of MSHFLEXGRID to EXCEL. (note, I'm not sure if MSHFLEXGRID and FLEXGRID is same but I'm using MSHFLEXGRID) .
I think there is a thread here about this but I cannot find it already. Please help. Thanks!
Exporting Mshflexgrid Data To Excel
hi,
gurus
im having problems with exporting data from mshflexgrid to excel.
The problem is i display data thru mshflexgrid by setting datasource to a recordset.then i change the position of the columns for eg:i change the position of column one to two by dragging the columns.
Now is the problem that when i try to export the data where i have changed the column position ,it doesnt happen and it exports the data as it was visible on formload
the code i use to set the datasource:
set mshadd=recordset
i move the columns by:
mshadd.colposition(mshadd.colse)=mshadd.col
please help
and thanx in advance.
Export MSHFlexgrid Data To Excel Spreadsheet(Merge Row)
Hi,
How can i export MSHFlexgrid data that i entered and display using
Code:
With MSHFlexGrid1
.TextMatrix(2, 6) = Form7.Text12.Text
.TextMatrix(2, 7) = Form7.Text12.Text
.TextMatrix(2, 8) = Form7.Text12.Text
.MergeCells = flexMergeRestrictRows
.mergeRow(2) = True
.CellAlignment = 0
End With
Actually when i try to implement the code as been posted here, all the merge rows will be copied to Excel according to how many the Merge is. All i want is it only display the Merge for row 0 to row 8 of the MSHFlexGrid but for row 10 onward the data will be copied directly to Excel. Could u plz help me?Anyone?
Copy Excel Data To New Excel Workbook HELP!
I have a excel workbook with thousands of peoples names and info. A persons record can be in the workbook more than once. I want to create a macro or somthing in excel to copy all of the same people with the last name Smith for example to a new workbook. How do I go about doing this, anyone with example code or help.
Thanks
Copy Data In Excel
Hi Dears,
I have three sheets i.e sheet1, sheet2 and sheet3 in excel. How i can copy data from sheet1 and sheet2 into sheet3 assuming that col1 in sheet1 and sheet2 has date field i.e Column . I would like to use combobox in a userform to give specific range for sheet1 and sheet2 to copy data into sheet3.
Thanks
Syed Haider Ali
Copy Data From Excel To Access
To all expert programmmers out there
Any idea how to read thru a row in excel to test if there is any entries into columns, if no skip thru next line and read next row. If row entry exist insert into access database.
i tried to create an array for row_num and col_num not i get TYPE MISMATCH when trying to insert an excel row into the db.
My script is producing errors because there are some empty rows in excel before reading a row entry.
The insert into SQL build by the script is not able handle rows with NO entry.
Hope some of you out can be of further assistance...
Thanks a million
Copy Data From Excel To Word
Do you think I can read data from an Excel file opened within a Word document and paste the data into the word document? I already know how to open an excel file inside a word document, now I need to know how to copy data from the excel into word. Thank you
Copy Data From Excel To Access
Edit by Moderator:
Re: http://www.xtremevbtalk.com/showthread.php?t=197012
Hope I don't get in trouble for reopening this thread, but I saw that other
threads have been referenced to it and thought that this sumpliment, might
in some instances, be found to be useful.
In Reference to Post#8 the issue of changing column or cell data type
* In many cases, (not all), it is actually possible to avoid having to reenter
data, (in Excel), after changing cell formatting.
Code similar to below, will in many case, do the trick,
(However, do test it thoroughly, (while keeping a backup of the Excel File),
to be sure that this method, will in fact work, with your actual data.
Code:
Sub ConvertDataToNewFormat()
Columns("G").NumberFormat = "@"
'Line above changes all the cells in Column(G) to Text Format
Columns("G").Formula = Columns("G").Formula' it may be hard to believe, but
'this command can convert the dataType of pre-existing data, based on cells format
End Sub
Edit by Moderator: Well, the thread was over 1 month old... so it would make things easier if you started a new thread and added a link to the original in future.
Excel VBA Code For VB6 To Copy Data From Web
this is the excel vba code to copy data from web page to excel sheet How can I use it in vb6 to store data either in a database or excel file or text file so that saved data can be retrived later ?
ExcelVBA Code:
Code:
Sub Macro1()
Range("A1").Select
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://money.rediff.com/money/jsp/co_results_q.jsp?companyCode=15150021", _
Destination:=Range("A1"))
.Name = "co_results_q.jsp?companyCode=15150021_1"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlSpecifiedTables
.WebFormatting = xlWebFormattingNone
.WebTables = "16,17"
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With
ActiveWindow.SmallScroll Down:=-21
End Sub
Can this be done in vb6?
Copy Excel Data Onto A Flexgrid
Hi
I am having an employee.xls excel sheet ( C:Employee.xls ) . All the employee data is in the Sheet1.
I have a VB form form1 with a flexgrid Msflex1
One the Form Load event , the flex grid (Msflex1) should connect to the Excel sheet (C:Employee.xls ) and display all the data on the Flexgrid
How do I do that ? Could some one please suggest me the code
Thanks
Copy The Data In Excel To Datagrid
hi~
I would like to know if there is any method to copy the data in excel to datagrid by VB 6.0.
Do you know??
Moreover,
I have heard about an indirect method:
firstly, copy the excel's data to MS access
then, copy the data in Access to the datagrid.
Is it the only way to do the task???
Thanks for your help~
Copy Large Data From Access To Excel
I have about 5000 records I need to copy into an existing excel spreadsheet from an Access table. I have tried the below but it is way to slow. Does any one know of a much quicker way I can paste the 5000 records into Excel?
Thanks.
Code:
Do Until rsSelectedTrades.EOF = True
objExcel.Cells(RowActive, 80).Value = rsSelectedTrades!ShareCode 'Column 80 is CB
objExcel.Cells(RowActive, 81).Value = rsSelectedTrades!StockTradeNo
objExcel.Cells(RowActive, 82).Value = rsSelectedTrades!EntryDate
objExcel.Cells(RowActive, 83).Value = rsSelectedTrades!Enter
objExcel.Cells(RowActive, 84).Value = rsSelectedTrades!Direction
objExcel.Cells(RowActive, 85).Value = rsSelectedTrades!Exit
objExcel.Cells(RowActive, 86).Value = rsSelectedTrades!HoldPeriod
objExcel.Cells(RowActive, 87).Value = rsSelectedTrades!Profit
objExcel.Cells(RowActive, 88).Value = rsSelectedTrades!ProfitPer
objExcel.Cells(RowActive, 89).Value = rsSelectedTrades!Other
objExcel.Cells(RowActive, 90).Value = rsSelectedTrades!Signal
objExcel.Cells(RowActive, 91).Value = rsSelectedTrades!ExitDate 'Column 91 is CM
rsSelectedTrades.MoveNext
objExcel.ActiveCell.Offset(1, 0).Select
RowActive = RowActive + 1
Loop
Copy Data From Excel Into Word Document
Hi,
I need to some help with the following.
I want to copy over data from Excel into Word. I have managed to open a word file, name some bookmarks but then copying over the data... ik weet het niet. (dutch) Also, the Wordfile opens up as readonly, but only after running the macro 2 times.
Does someone has some code for me I can use to copy over data?
Very much appreciated out of the Netherlands!
Cheers
Cossy
Using Recordset Copy Data From Excel To Access
Can somebody help me with the code to transfer data from excel to Access database using DAO. I have to copy from range A4:CA150 to an Access table. I have the table created in Access with the exact columns in Excel, all I want to do is transfer the data.
Thanks
Reggie
Vbscript - Copy Data From Notepad To Excel
Hi
Could someone please provide me with sample vbscript code that loads all the data from my notepad file into an excel workbook. I am finding it very hard to do as I am new to this.
thx
HELP NEEDED!!!Copy Data From Excel To Access Using VB
To all EXPERT programmers out there
need a solution in VB on how to copy some column infomation in excel into predefine fields created in access using DAO or ADO (preferably DAO)method
My excel sheet (BOM.xls) contains 12 columns but i need only data in 6 columns to be inserted into BOM table in abc.mdb access database.
Excel columns
Idn
Lvl
Find No
Item Typ
Item No
Item Rev
Item Desc
Qty
UM
BOM Type
Item Status
Notes
BOM table structure
DocNo
FindNo
PartNo
Location
Alt
Desc
Qty
SmtQty
CadQty
Flag
fileId
pbaNo
Rev
prod
Family
Datestamp
PartType
StockRoom
Remarks
Needed information
Excel columns Access field
Find No FindNo
Item No PartNo
Item Rev Rev
Item Description Desc
Qty Qty
Notes Location
Rest of the fields can be hard coded with a fix value and date of insert
Can someone further assist?
Whatever assistance is much appreciated ?
Thanks a million
alvin
How To Copy Data From An Opened Textfile To A Excel Worksheet
Hi,
I have excel file which contains 3 worksheet and I want to save all text of all 3 work sheet in single text file how can I do it so ?
I have all ready tried looping through all the cell but its very time consuming coz it loop through 65535 rows and 256 columns for each worksheet.
So Is there anyway that I can copy whole sheet and paste it to the text file ?
I need urgent help in this matter...
Thanx in advanced....
Copy Large Data From Access To Excel *SOLVED*
I have about 5000 records I need to copy into an existing excel spreadsheet from an Access table. I have tried the below but it is way to slow. Does any one know of a much quicker way I can paste the 5000 records into Excel?
Thanks.
Code:
Do Until rsSelectedTrades.EOF = True
objExcel.Cells(RowActive, 80).Value = rsSelectedTrades!ShareCode 'Column 80 is CB
objExcel.Cells(RowActive, 81).Value = rsSelectedTrades!StockTradeNo
objExcel.Cells(RowActive, 82).Value = rsSelectedTrades!EntryDate
objExcel.Cells(RowActive, 83).Value = rsSelectedTrades!Enter
objExcel.Cells(RowActive, 84).Value = rsSelectedTrades!Direction
objExcel.Cells(RowActive, 85).Value = rsSelectedTrades!Exit
objExcel.Cells(RowActive, 86).Value = rsSelectedTrades!HoldPeriod
objExcel.Cells(RowActive, 87).Value = rsSelectedTrades!Profit
objExcel.Cells(RowActive, 88).Value = rsSelectedTrades!ProfitPer
objExcel.Cells(RowActive, 89).Value = rsSelectedTrades!Other
objExcel.Cells(RowActive, 90).Value = rsSelectedTrades!Signal
objExcel.Cells(RowActive, 91).Value = rsSelectedTrades!ExitDate 'Column 91 is CM
rsSelectedTrades.MoveNext
objExcel.ActiveCell.Offset(1, 0).Select
RowActive = RowActive + 1
Loop
Macro For Excel To Copy Data To Specific Worksheet - Help!
I need help creating a macro for Excel. My workbook has 13 worksheets in it. The first worksheet is for data entry - where the user types in the call information. Each of the other 12 worksheets are labeled by month. What I want is a macro that will copy the row of data (record) onto the corresponding month's worksheet.
For example, a call comes in on January 3, 2002. The employee puts in the date of the call, the problem and the solution in adjacent cells in the same row. I want a Macro to automatically copy that row's data onto the January worksheet, in the first empty row.
Any ideas?
Thanks!
Beth
Data Loss During Simple Vba Copy/paste Action In Excel
mysterious:
i´m loosing data with a simple copy/paste action in vba.
the data loss only occures when i perform the action automatically.
manual copy/paste works well!
and it concers only a few cells!
the sheet which i want to import was created by someone else, that´s why i got no idea what the problem could be...
thx in advance!
Read A Text File And Copy Data To Excel In New Column
I am trying to read a text file every half hour named Datacap.txt. It has 12 numbers all in a row in it. I would like to read that data and copy to a new column in a excel file named DC.xls every time I would run a batch file program. Could anyone help me on this? Thank you.
Copy Data From Excel As The Unformat Text THEN Paste It In Ms Word
I'm try to copy the data from Excel then paste it in Ms word as unformat Text
this is my code but for some reason the format of the data is still FORMATTED from excel and my bookmark does not work as well.. please help
Code:
Sub CopyWorksheetsToWord()
Dim r As Range
Dim w As Word.Application
Dim wd As Word.Document
Dim strText As String
Dim icount As Integer
Set w = New Word.Application
Set wd = w.Documents.Open("c: est1.doc")
With wd.Bookmarks("G") ' this bookmark does not work!!!!!
Range("a15").Select
strText = ""
End With
While ActiveCell.Value <> ""
icount = 1
strText = strText & ActiveCell.Value
While ActiveCell.Offset(0, icount).Value <> ""
strText = strText & " " & ActiveCell.Offset(0, icount).Value
icount = icount + 1
Wend
strText = strText & vbCr
ActiveCell.Offset(1, 0).Select
Wend
w.Visible = True
w.Selection.InsertAfter strText
End Sub
HELP NEEDED!!! Problem In INSERT INTO SQL Statement. Copy Data From Excel To Access
To all EXPERT programmers out there
need a solution in VB on how to copy some column infomation in excel into predefine fields created in access using DAO or ADO (preferably DAO)method
My excel sheet (BOM.xls) contains 12 columns but i need only data in 6 columns to be inserted into BOM table in abc.mdb access database.
Excel columns
Idn
Lvl
Find No
Item Typ
Item No
Item Rev
Item Desc
Qty
UM
BOM Type
Item Status
Notes
BOM table structure
DocNo
FindNo
PartNo
Location
Alt
Desc
Qty
SmtQty
CadQty
Flag
fileId
pbaNo
Rev
prod
Family
Datestamp
PartType
StockRoom
Remarks
Needed information
Excel columns Access field
Find No FindNo
Item No PartNo
Item Rev Rev
Item Description Desc
Qty Qty
Notes Location
Rest of the fields can be hard coded with a fix value and date of insert
Below is the solution i was working on but encountered problem
Is this SQL comand correct? Prompt INSERT INTO syntax err when execute
"INSERT INTO Books (FindNo,PartNo,Location,Desc,Qty,Rev)
VALUES (1,866469, U1J1','MOTHER BD',1,02)"
This is the code to build this query.
Dim excel_app As Object
Dim excel_sheet As Object
Dim max_row As Integer
Dim max_col As Integer
Dim row As Integer
Dim col As Integer
Dim conn As ADODB.Connection
Dim statement As String
Dim new_value As String
Screen.MousePointer = vbHourglass
DoEvents
' Create the Excel application.
Set excel_app = CreateObject("Excel.Application")
' Uncomment this line to make Excel visible.
' excel_app.Visible = True
' Open the Excel spreadsheet.
excel_app.Workbooks.Open FileName:=(dirBom & "" & TxtBom.Text)
' Check for later versions.
If Val(excel_app.Application.Version) >= 8 Then
Set excel_sheet = excel_app.ActiveSheet
Else
Set excel_sheet = excel_app
End If
' Get the last used row and column.
max_row = excel_sheet.UsedRange.Rows.Count
max_col = excel_sheet.UsedRange.Columns.Count
' Open the Access database.
Set conn = New ADODB.Connection
conn.ConnectionString = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & App.Path & "ikmeso1.mdb" & ";" & _
"Persist Security Info=False"
conn.Open
' Loop through the Excel spreadsheet rows,
' skipping the first row which contains
' the column headers.
For row = 6 To max_row
' Compose an INSERT statement.
statement = "INSERT INTO Books (FindNo,PartNo,Location,Desc,Qty,Rev) VALUES ("
For col = 1 To max_col
If col > 1 Then statement = statement & ","
'statement = statement & "'" & _
new_value = Trim$(excel_sheet.Cells(row, 3).Value) & "," & _
Trim$(excel_sheet.Cells(row, 5).Value) & "," & _
Trim$(excel_sheet.Cells(row, 12).Value) & "," & "'" & _
Trim$(excel_sheet.Cells(row, 7).Value) & "'" & "," & _
Trim$(excel_sheet.Cells(row, 8).Value) & "," & "'" & _
Trim$(excel_sheet.Cells(row, 6).Value) & "'"
statement = statement & new_value
conn.Execute statement, , adCmdText Next col
Next row
' Close the database.
conn.Close
Set conn = Nothing
' Comment the Close and Quit lines to keep
' Excel running so you can see it.
' Close the workbook saving changes.
excel_app.ActiveWorkbook.Close True
excel_app.Quit
Set excel_sheet = Nothing
Set excel_app = Nothing
end sub
Any help is much appreciated.
Thanks a million!!!
Copy Mshflexgrid To Clipboard
I know alot has been said about flexgrids and copieng and pasting, but I've searched all topics and can't find a solution for my problem. I've seen alot of questions of copieng data to a flexgrid, but i want to copy from a flexgrid. I'm looking for a way to copy all data from a flexgrid to the clipboard so I can paste it in what ever app I want, mail, excel, word whatever. If I paste it to excel, the rows and collumns have to be in tact. Is this possible?
Mshflexgrid Control [copy Rows]
I m working on project. The idea is, select 1 row and add to another Msflexgrid. Instead of 20 rows i might want to select 5 or 10 rows only from Mshflexgrid1 to be add in Mshflexgrid2.
coding bellow manage to copy all the rows form Mshflexgrid1 to Mshflexgris2.
WRow as Long
Dim WCol as Long
MSHF2.Clear
MSHF2.Rows = MSHF1.Rows
MSHF2.Cols = MSHF1.Cols
For WRow = 1 to MSHF1.Rows -1
MSHF1.Row = WRow
MSHF2.Row = WRow
For WCol = 0 to MSHF1.Cols - 1
MSHF1.Col = WCol
MSHF2.Col = WCol
MSHF2.Text = MSHF1.Text
Next WCol
Next WRow
But what i need is to select certain row form MSHF1 and copy it into MSHF2
MSHFlexgrid Search And Copy Row Text
I have a MSHFlexgrid that I am searching for a string. It works great but I want to continue searching all the rest of the rows and columns for the next iteration of the string.
I tried to add this:
VB Code:
For x = 1 To MSHFlexGrid1.Col - 1
To my following code but didn't work.
It only finds the first iteration and does not continue.
I also need to have the row text when it finds the string to be copied to another grid be it flexgrid or MSHFlexgrid.
VB Code:
If Len(Trim(Text1.Text)) = 0 Then Exit SubFor i = 1 To MSHFlexGrid1.Rows - 1 If Text1.Text = Mid(MSHFlexGrid1.TextMatrix(i, 2), 1, Len(Trim(Text1.Text))) Then Found = True MSHFlexGrid1.Row = i MSHFlexGrid1.Col = 0 MSHFlexGrid1.ColSel = MSHFlexGrid1.Cols - 1 Exit For End If Found = FalseNext iEnd Sub
THX !
MSHFlexGrid Copy Pasting Rows, Columns, Etc
I'm trying to be able to copy data (by rows or columns or selected cells) into the clipboard and be able to paste it into a excel data sheet.
I'm not sure what I'm suppose to do but I thought it would be using the SetText using the vbCFLink (DDE) settings?
Import New Data To MSHFlexgrid Without Affecting Existing Data..
Hi,
How can I import an Excel file containing data for example student ID and student name on a particular cell in the MSHFlexGrid without affecting the existing data in it. For example when "import" button is clicked it will prompt the user for the Excel file containing the value that will be imported. Then the value will be displayed in cell (3, 1) downwards and cell (3, 2) downwards.
My problem is whenever I perform the import action, the MSHFlexGrid will only display the value in the Excel file that I have selected in new MSHFlexGrid and the existing data in the previous MSHFlexGrid will be lost. How can I eliminate this problem? Any suggestions and examples? TQ in advance..
Import New Data To MSHFlexgrid Without Affecting Existing Data.
Hi,
How can I import an Excel file containing data for example student ID and student name on a particular cell in the MSHFlexGrid without affecting the existing data in it. For example when "import" button is clicked it will prompt the user for the Excel file containing the value that will be imported. Then the value will be displayed in cell (3, 1) downwards and cell (3, 2) downwards.
My problem is whenever I perform the import action, the MSHFlexGrid will only display the value in the Excel file that I have selected in new MSHFlexGrid and the existing data in the previous MSHFlexGrid will be lost. How can I eliminate this problem? Any suggestions and examples?
Copy-(special) Pasting Excel Table Into Word By Clicking Button In Excel
I have a table in excel which I want to be able to to copy paste into an empty letterhead word document which is already saved in 'my documents'. I want to add a button onto the excel spreadsheet which when clicked will call up the empty (read-only) letter headed document and paste itself in there. However, I want to special paste it (unformatted text) to remove it from the table, then change the font on the whole document. In the same macro I want to have it underline some designated phrases which appear in the freshly pasted text as well.
Is this at all possible?
Copy Excel Sheet To A Form's Excel Control
I have an Excel workbook. In this workbook I have a VBA form which contains an Excel Spreadsheet control. I want to copy a sheet from the actual workbook to the workbook of this control in my form. I've searched the forums and learned how to copy, but it doesn't seem to cooperate with the control. Any other methods? Thanks.
MSHFLexgrid To Excel
hi
i have grid that display data in below format:
Year | Amt1 | Amt2 | Tot1 | Amt3 | Tot2
2000| 100 | 200 | 300 | 400 | 700
2001| 200 | 300 | 500 | 500 | 1000
I have been able to display the data in Excel in below format:
Year | 2000 | 2001
Amt1| 100 | 200
Amt2| 200 | 300
Tot1 | 300 | 500
Amt3| 400 | 500
Tot2 | 700 | 700
Now what I want is to format the Tot1 and Tot2 and corresponding values of Tot1 and Tot2 in excel in BOLD Letter.
I can BOLD Tot1,Tot2 and so on if there is any, but not been able to bold the values of Tot1 and Tot2, can't figure out how to move forward in column.
How is possible?
Thanks
Excel With MShFlexGrid
I filtered some rows from an SQL Table to a MSHFlexgGrid, I need to send this grid to Excel file so I can imported to a Barcode Printer (Sato).
If any one now how, Please help by sending code or some lines to redirect me to do that.
Thans for all who read this and try to help.
MSHFLEXGRID To EXCEL?
i have a database which i made with ADO using ACCESS as database. is it possible to export MSHflexgrid to MS Excel? if so.. how? anyweis.. ill be glad to hear some answers. Im just a beginner - student. Thanks
MSHFlexGrid Excel Like
For anyone in need of a MSHFlexGrid that can be edited like an EXcel Spread Sheet, here is a project.
Navigate with:
Left, right, up and Down keys
Tab Key Forward and Backwards (Shift+Tab)
Enter key (like Tab Forward)
Edit cells
Excel And MSHFlexgrid
I have a typical problem, I have an excel sheet which is bound to an XML file (i guess so) which keeps on refreshing every 10 seconds or less.......Now I have a data environment which I am binding with the Excel file and then getting the records in MSHFlexgrid. Once the connection is established I can fetch only the current record, I dont know how to refresh the grid when the Excel file is refreshed.....
Regards
Jaideep
Copy Excel Worksheets To New Excel Document
As the title suggests, I am trying to get one worksheet from an excel sheet and copy it into a new excel document.
I am a complete beginner with VB but have a good idea about using COM object and opening and entering data into excel, word etc. But I've never copied a who worksheet. Is it possible and where would one start?
is there a .copysheet or some kind of function I could use?
Any help appreciated.
Mark.
|
TRACKER
