Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing an Excel file and prompting user for input
I'm still new to this, but I'm looking at WMI to maybe do this. (Please
correct me if I should just use .net to do this.) I'm looking at a 'report file' in Excel, I can either CSV it or keep it in the same format. I need to copy that information and basically 'add' specific information say, name, invoice, item and cost, and prompt the user for a special note, or say if it's not a unique order. Is this possible in Excel (Prompting for a file import, then prompting the user for input via dialogue boxes?) Or should I look at a script file to just handle the construction of the file? Mitch |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing an Excel file and prompting user for input
On 20 Sep, 16:06, Mitch wrote:
I'm still new to this, but I'm looking at WMI to maybe do this. (Please correct me if I should just use .net to do this.) I'm looking at a 'report file' in Excel, I can either CSV it or keep it in the same format. I need to copy that information and basically 'add' specific information say, name, invoice, item and cost, and prompt the user for a special note, or say if it's not a unique order. Is this possible in Excel (Prompting for a file import, then prompting the user for input via dialogue boxes?) Or should I look at a script file to just handle the construction of the file? Mitch Its possible in Excel, this should get you started: File import in vba would be: dim TestName as Variant TestName = Application.GetOpenFileName() if TestName = False then Msgbox "No File Selected" Exit Sub End if Workbooks.open TestName An input box would be: dim TmpStr as String TmpStr = InputBox("Enter Note", "Please Enter a note") Range("A1") = TmpStr 'Users Note in cell A1 James |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing an Excel file and prompting user for input
Well, that looks like it'll open the document. What about reading the
document and copying specific information out of it into a new document? Does Excel have a 'read file' command? Hmm.. thanks though that will start heading me in the right direction. " wrote: On 20 Sep, 16:06, Mitch wrote: I'm still new to this, but I'm looking at WMI to maybe do this. (Please correct me if I should just use .net to do this.) I'm looking at a 'report file' in Excel, I can either CSV it or keep it in the same format. I need to copy that information and basically 'add' specific information say, name, invoice, item and cost, and prompt the user for a special note, or say if it's not a unique order. Is this possible in Excel (Prompting for a file import, then prompting the user for input via dialogue boxes?) Or should I look at a script file to just handle the construction of the file? Mitch Its possible in Excel, this should get you started: File import in vba would be: dim TestName as Variant TestName = Application.GetOpenFileName() if TestName = False then Msgbox "No File Selected" Exit Sub End if Workbooks.open TestName An input box would be: dim TmpStr as String TmpStr = InputBox("Enter Note", "Please Enter a note") Range("A1") = TmpStr 'Users Note in cell A1 James |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
prompting user for the directory to save an excel file to | Excel Programming | |||
need help w/ macro prompting with info and pasting the info based on user input | Excel Programming | |||
Prompting User | Excel Programming | |||
Close Excel file without prompting user to save | Excel Programming | |||
Excel VBA- Get user input, search the for match, output to text file | Excel Programming |