Jump to content
Fórum Script Brasil
  • 0

Access Com Excel

Guest --Wellington --


8 answers to this question

Recommended Posts

  • 0
Guest --Wellington --

tenho um processo no access q no meio dele, preciso abrir um arquivo do excel ( q contem uma macro no alto_open) q executa e fecha o escel depois), como posso chamar para abrir o arquivo do excel, atráves de códigos no vba do access ?

Link to comment
Share on other sites

  • 0
Guest --Wellington --

Consegui criar essa macro, mas ao abrir o arquivo do excel, não roda o comando do auto_open do excel e tb não consegui fechar o excel depois, onde está meu erro?

Sub teste()

Dim oApp As Object

Dim FileName As String

Dim wb As Object

FileName = "C:\Wellington\Particular\Pasta1.xls"

'Set ExcelApp = CreateObject("Excel.Application")

Set ExcelApp = CreateObject("Excel.Application")

Set wb = ExcelApp.Workbooks.Open(FileName)

ExcelApp.Visible = True

ExcelApp.Visible = False

End Sub



Link to comment
Share on other sites

  • 0

Fera agora num lembro qual era o link (me desculpem), porém falava algo sobre a o item abaixo que seleciona (ativa) uma determinada planilha dentro do arquivo xls.

chWorkSheet = excelApp:Sheets:ITEM(1)

Infelizmente agora toh um pouco enrrolado e num toh podendo pesquisar e localisar para você, mais acredito que não seja dificil achar!

Link to comment
Share on other sites

  • 0
Guest Andre Luiz Bernardes

Hello Everybody i am trying to develop an application which will have a link to an excel file. i.e if the user wants to look at some data he can click on the link and it will open the file in excel.

I dont want to embed the file because every user will have his own excel file. There should also be a way for him to select the file he wants to link to(kindof like a file Dialog box).

Any suggestions will do.. is this possible.... anything similar to it??

Thanks a lot


Download my Job: http://www.slideshare.net/bernardes/organi...-dados/download

My Profile: http://al-bernardes.sites.uol.com.br/

In LinkedIn: http://www.linkedin.com/in/andrebernardes

In Plaxo: http://andrebernardes.myplaxo.com/

In Jobster: http://www.jobster.com/people/andrebernardes

Access my Feed:


My experiences:



MSN: [email protected]

SKYPE: inanyplace

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Forum Statistics

    • Total Topics
    • Total Posts
  • Create New...