Join or sign in Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below. Use Your Email Use FacebookUse Linkedin

Switchboard in Excell

Locked

I have been tasked to write a user interface in Excell, which will allow a user to 1) Enter work Orders. 2) Send and Receive Info as a CSV file. and 3) Print reports based upon the CSV files. I realize that ACCESS would be a much better platform BUT I have been told that this ios not an Option. My question is, “Is there a way to Create and Open a Switchboard form upon the start of the worksheet?

Thanks,
Gary

Topic

Reply To: Switchboard in Excell

In reply to Switchboard in Excell

It will not be very hard to create a small form with macro buttons that perform those tasks. YOu could save it as the default template and it would pull up each time. Macros can open other forms, clear values, save in CSV and print very easily.

Here’s some examples code lines:
ActiveWorkbook.SaveAs “C:\me.xls”, xlCSVWindows
ActiveWorkbook.PrintOut
Workbooks.Open “WORKORDER.XLS”

See if that helps you out!

[Author]

Replies