Here is a sample of the code i am using
---------
Dim objexcel As Object
Dim wkbook As Object
Dim sheet As Object
Set objexcel = CreateObject("Excel.Application")
Set wkbook = CreateObject("excel.Workbook")
Set sheet = CreateObject("excel.Worksheet")
wkbook = objexcel.Workbooks.Add
objexcel.Visible = True
sheet.Visible = True
sheet.SetFocus
---------
What this does is open a blank excel sheet.
Know during this time i have information saved onto the clipboard. What i want to do is paste that information automatically when the sheet opens. As of now, after the excel sheet opens i can go to..the edit menu..paste. And all of my information is their.
I thought it would look something like this
wkbook = objexcel.Workbooks.Add
objexcel.Visible = True
sheet.Visible = True
sheet.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70
But that doesnt work. Any help would be appreciated
---------
Dim objexcel As Object
Dim wkbook As Object
Dim sheet As Object
Set objexcel = CreateObject("Excel.Application")
Set wkbook = CreateObject("excel.Workbook")
Set sheet = CreateObject("excel.Worksheet")
wkbook = objexcel.Workbooks.Add
objexcel.Visible = True
sheet.Visible = True
sheet.SetFocus
---------
What this does is open a blank excel sheet.
Know during this time i have information saved onto the clipboard. What i want to do is paste that information automatically when the sheet opens. As of now, after the excel sheet opens i can go to..the edit menu..paste. And all of my information is their.
I thought it would look something like this
wkbook = objexcel.Workbooks.Add
objexcel.Visible = True
sheet.Visible = True
sheet.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70
But that doesnt work. Any help would be appreciated