Macros waiting for user input

H

HardBeatZ

New Member
Joined
Aug 11, 2009
Messages
11
I am trying to put together a macro that waits for the user to input data and then continue running the macro.

All user input is for one cell and I am looking at more of an entire sheet worth of data.

Here is the scenerio.

I have one tab that pulls data out of a sharepoint list. I then have another tab that I dump data from another database into and then use vlookups to compare the data.

The problem is I need it update the sharepoint list. Then wait for the user to dump in the new data from the external database before continuing the macro and working with the vlookups.

Currently I am working this by running a few different macros to do it all, but I would like to condense it down to running one macro.

Thanks for any input and help.
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
Sort by date Sort by votes
I try to keep macros seperate based on their specific function, this way you can call repeated code rather than writing it all over. Just good practice.

So let me get the steps straight:
1. Dump from SharePoint into sheet A
2. Dump from db in Sheet B
3. Use Vlookup to compare Sheet A and Sheet B


And step two is the user intervention?

Why not include the table dump in the macro and eliminate user intervention?
 
Upvote 0
Welcome to the Board!

If the user input is only for one cell/value, you can just use an InputBox.

I.E.

<font face=Calibri>    <SPAN style="color:#00007F">Dim</SPAN> i <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Double</SPAN><br>        i = Application.InputBox("Please input a value", "Input Needed", Type:=1)<br>        MsgBox i</FONT>

Hope that helps,
 
Upvote 0
@Goofy

Yes step 2 is the user input and can't be done with a macro because it is being exported out of a system application that doesn't support macros, thus the need for the end user to locate the data export and then copy and paste into the excel sheet with the forumlas.

@Smitty

That is great for one cell and one value, but the average user dump is actually 17 columns and 300+ rows worth of data.
 
Upvote 0
What would be nice is to have a dialog box that tells the user to input the data into sheet 2 and then click continue to keep running the macro

Would that be possible?

Then the user can run the macro, it will update the sharepoint list it will pull the new data over. Then the user can get the pop up telling them to get the data for sheet two. Go to Siebel, export the data out and put into sheet two, then click continue and the macro will continue running.
 
Upvote 0
Can you export from Siebel, to a text, csv, or xls file? Siebel is just an Oracle CRM is it not? You should be able to send a query to the db, from excel.
 
Upvote 0
It is an Oracle CRM that we use to track data in. I only want to pull out a weeks worth of data, so this week I would pull out last week's data.

Currently what I do is run a macro update sharepoint and pull out that weeks data. Then export the data out of Siebel as a xls file and move to the other sheet. Then run another macro to compare the two.

Are you saying there is away in Siebel to tell it to go to Siebel and pull that data out already without having to open up the application?
 
Upvote 0
If it is like most db, there is a way to access the information without going through the user interface. I would ask an admin if they can create a sql file for you regarding the export you need.

Aside from that, you can use the macro you currently have to pull information directly from the xls export you get out of Siebel. There is no need to copy the information from one excel sheet to another manually. Look in this forum for help on copying from one workbook to another.
 
Upvote 0
You must log in or register to reply here.

Similar threads

Z
  • Question
Print-to-PDF is corrupted in WIN11
Replies
1
Views
97
zombiemaster
Z
N
  • Question
Double Click Macro that creates new sheet using SQL query
Replies
1
Views
114
Fluff
Fluff
K
  • Question
Excel macro book problem
Replies
0
Views
225
kamikhan
K
W
  • Question
VBA Script to Move a Row to a New Tab
Replies
0
Views
224
wangaa11
W
C
  • Solved
Way to stop blinking between workbooks
Replies
1
Views
119
MARK858
MARK858

Forum statistics

Threads
1,214,649
Messages
6,120,732
Members
448,987
Latest member
marion_davis

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top