Jump to content
Fórum Script Brasil
  • 0

Access Com Excel


Guest --Wellington --
 Share

Question

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

Abraços,

Wéééé

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

ANDRÉ LUIZ BERNARDES

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:

http://www.google.com/reader/shared/17429357110218427555

My experiences:

http://andrelbernardes.sites.uol.com.br/MIS.html

http://andrelbernardes.sites.uol.com.br/XLS.html

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.

Guest
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.

 Share



  • Forum Statistics

    • Total Topics
      150.1k
    • Total Posts
      647.1k
×
×
  • Create New...