Hey, need help on some basic stuff related to macro

[suryu]

I have opened workbook using macros in access and want to do below steps
1) I have workbook open with some specific columns, i need validation on first column and it should take data from another sheet(distinct value)
2)how to take data in another sheet from query

 

[theDBguy]

Hi. This sounds like an Excel problem. If so, I'll ask the mods to move it out of the Access Forum.

 

[suryu]

Hey no, using macros i need to do, check once again my post

 

[theDBguy]

Hey no, using macros i need to do, check once again my post

Okay, I'm just saying. Macros between Access and Excel are not the same.

 

[suryu]

i am working on access, and open workbook using below query

set oXL= Createobject("excel.application")
oXL.visible = tRue
set wkbk=oXl.Workbooks.add
set sht = wkbk.sheets(1)

after that i set field value and now i want to take data from query to another sheet

could you tell me how to take data from query to another sheet?

 

[theDBguy]

i am working on access, and open workbook using below query

set oXL= Createobject("excel.application")
oXL.visible = tRue
set wkbk=oXl.Workbooks.add
set sht = wkbk.sheets(1)

after that i set field value and now i want to take data from query to another sheet

could you tell me how to take data from query to another sheet?

Hi. Have you tried something like?

Set sht2 = wkbk.sheets(2)

 

[suryu]

yes, i have created another sheet too.

let me brief u again

i have query where one columns data is there.

I want to take distinct data from query 1 to sheet2.

something i am doing code like set qd= currentDb.queryDefs("query1")

after that how to do ?

 

[theDBguy]

yes, i have created another sheet too.

let me brief u again

i have query where one columns data is there.

I want to take distinct data from query 1 to sheet2.

something i am doing code like set qd= currentDb.queryDefs("query1")

after that how to do ?

Hi. Have you tried the CopyFromRecordset method?

Range.CopyFromRecordset method (Excel)

Office VBA reference topic

docs.microsoft.com

 

[suryu]

no, i have not tried

how to copy from query to directly paste to active sheet

 

[theDBguy]

no, i have not tried

how to copy from query to directly paste to active sheet

There's a sample code in the link I posted above.

 

[suryu]

Thanks , i was doing from other logic but now its done

 

[theDBguy]

Thanks , i was doing from other logic but now its done

Hi. Congratulations! Good luck with your project.

 

[suryu]

Hi. Congratulations! Good luck with your project.

thank you so much

 

[suryu]

Hi,

I am facing issues with data validation property.
I have one column data in second sheet and want to take those data from second sheet to first sheet in drop down list using vba code in access.

Could you please help me with that.

thank u in advance

 

[theDBguy]

Hi,

I am facing issues with data validation property.
I have one column data in second sheet and want to take those data from second sheet to first sheet in drop down list using vba code in access.

Could you please help me with that.

thank u in advance

Hi. I really don't do much Excel, but take a look at the VBA example at the end of this article. Hope it helps...

Excel VBA Drop Down Lists Using Data Validation - VBA and VB.Net Tutorials, Education and Programming Services

In this article I will explain how you can create drop down lists using data validation. Jump To: Creating Data Validation (Manually) Creating Data Validation (Using VBA) Selection Change Modifying, Adding, Inserting and Removing Items (Usin VBA) You can download the file and code related

software-solutions-online.com

 

[suryu]

Hi. I really don't do much Excel, but take a look at the VBA example at the end of this article. Hope it helps...

Excel VBA Drop Down Lists Using Data Validation - VBA and VB.Net Tutorials, Education and Programming Services

In this article I will explain how you can create drop down lists using data validation. Jump To: Creating Data Validation (Manually) Creating Data Validation (Using VBA) Selection Change Modifying, Adding, Inserting and Removing Items (Usin VBA) You can download the file and code related

software-solutions-online.com

thanks

 

[theDBguy]

thanks

Good luck!