Excel 2 a Windows Application

[crobertson]

I have an excel workbook that is functioning perfectly and giving me the data I need. My macros are working great, but my goal is to incorporate the sheet into a Windows Application somehow?

Is there a way to build a windows app in VB that I could use to all the excel sheet and run the macros in the background, without the user seeing what is happening, just getting the csv file that is exported after the macros are run?

Any help is greatly appreciated.

 

[Smitty]

without the user seeing what is happening

Have you tried ScreenUpdating and DisplayAlerts?

Sub foo
  With Application
     .ScreenUpdating = False
     .DisplayAlerts = False

     '   Your Code

     .ScreenUpdating = True
     .DisplayAlerts = True
   End With
End Sub

That will suppress screen activity and program prompts.

You can make a process seem almost seamless to an end user witha little work.

Hope that helps,

Smitty

 

[crobertson]

So, how could I run this without running the excel document?

Could I call the excel document from a VB Script?

 

[Smitty]

I'm not real familiar with VB Script, but it seems that the Shell command would work.

Smitty

 

[crobertson]

Ok, I have everything incorporated into a UserForm, and that is almost working perfectly. How could I have the user run the xls file but only see the user form?

 

[Smitty]

See this post.

You can also use

Private Sub Workbook_Open()
   UserFormName.Show
End Sub

To show the UF when the WB is opened.

Smitty

 

[crobertson]

That works splendid!

Thank you !!!