Member Avatar for solutionland

hello
thank you for your good solution but your solution always assume external workbook to be open, how to work with current opened workbook?

Dim oxcel As Excel.Application
Dim owb As Excel.Workbook
Dim osht As Excel.Worksheet

oxcel= New Excel.Application
oxcel.Visible = True
owb= oxcel.Workbooks.Open(Path)
osht= owb.Worksheets(1)

now I developing add-in and I want when user click on special button in new ribbon then he get results in the workbook he working on it, not to open new workbbookbut until now I can't find solution.
please help me to work with activeworkbook.
thank you
hossein

Edited by Dani because: Formatting fixed
  • 1 Contributor
  • 1 Reply
  • 393 Views
  • 15 Hours Discussion Span
  • Latest Post Latest Post by solutionland
Member Avatar for solutionland

hello
Please help me, really i should finish this in short time.
I need help.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.