akashraog
01-07-2009, 03:58 AM
Hi All,
I am using VBA to pupulate Ms-Excel from Ms-Access. Once done i activate the excel sheet, so that i can see the data in excel.
Now, if another excel sheet is open, then the excel-sheet that i populated does not get activated(neither is it hidden in the background). It just doesn't show up or open.
My code to open excel :-
Set oApp = CreateObject("Excel.Application")
Set xlWrkBk = GetObject("C:\Excel Form.xls")
Set xlSht = xlWrkBk.Worksheets(1)
'code to populate excel
'other code
xlWrkBk.Application.Visible = True
Can anyone help me with this?
:beerchug:
Thanks
Akash
I am using VBA to pupulate Ms-Excel from Ms-Access. Once done i activate the excel sheet, so that i can see the data in excel.
Now, if another excel sheet is open, then the excel-sheet that i populated does not get activated(neither is it hidden in the background). It just doesn't show up or open.
My code to open excel :-
Set oApp = CreateObject("Excel.Application")
Set xlWrkBk = GetObject("C:\Excel Form.xls")
Set xlSht = xlWrkBk.Worksheets(1)
'code to populate excel
'other code
xlWrkBk.Application.Visible = True
Can anyone help me with this?
:beerchug:
Thanks
Akash