LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 88
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
prompting user for the directory to save an excel file to kiwiwulf Excel Programming 1 April 3rd 07 09:31 PM
need help w/ macro prompting with info and pasting the info based on user input drgka55 Excel Programming 8 August 28th 06 06:05 PM
Prompting User Alexis Excel Programming 6 March 8th 06 06:35 PM
Close Excel file without prompting user to save JDay01 Excel Programming 8 May 10th 05 09:14 PM
Excel VBA- Get user input, search the for match, output to text file gnileo Excel Programming 1 January 8th 04 07:59 PM


All times are GMT +1. The time now is 08:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"