wizard

  1. J

    Please help

    Is there a way I can convert the letter A to 13 and B to 15 number won’t be in order with the letter. need to be able to type a word and for it to spit out a very long number. For example if I was to type hello need a number 22 23 26 26 35. its for an old alarm panel I need to program and it...
  2. S

    Data Importing Wizard - Terrible Data Set - delimiter issue

    Hello, I have a wonky .txt file. I have to import the data into excel and I use data import wizard. Column B and C have data in there that should be split out into different fields (ie, anothercolumnthing, trans id, anothercolumn, event-time). However, I cannot get the data to be delimited...
  3. S

    Data Importing Wizard - Terrible Data Set - delimiter issue

    Hello, I have a wonky .txt file. I have to import the data into excel and I use data import wizard. Column B and C have data in there that should be split out into different fields (ie, anothercolumnthing, trans id, anothercolumn, event-time). However, I cannot get the data to be delimited...
  4. M

    MSQuery Wizard

    I can't run a Query using the the Query Wizard in my profile on my laptop, which i was doing regularly before. It just opens Msquery in the background and just freezes. If i log in using a different profile on the same laptop it works perfectly Any ideas on how to resolve without re creating...
  5. H

    microsoft query wizard

    Can anyone help me with the answer to this question? when using the Microsoft query wizard what feature is used to designate the rows to include in a query? source selector data filer data validator row selector limited query I had a feeling it was row selector or source selector but I've...
  6. Kdbailey

    Suppress Analysis Services Connection Wizard

    Hello, What I'm looking for is a way to suppress the Analysis Services Connection wizard from popping up if a user inputs an incorrect variable for a OLEDB connection. Basically I have 3 variables. Server, cube and user. I build the connection and then prior to using it, I test it by using...
  7. K

    Standard notes wizard

    I would like to set up a Standard Notes wizard for our drafters. For my example, we make three different types of drawings: Assembly, Welding, and Sheet Metal. I would set up a table with notes in the rows and drawing types in the headers. <tbody> NOTE ASSY WELD SHTMTL INTERPRET DRAWING PER...
  8. M

    Conditional Formatting not working in a Form

    I have a form and the conditional formatting does not work consistently. It’s a columnar form with tabs within it. It was created from a wizard originally and then heavily modified (both the layout of the form and also the underlying query created by the wizard) When I open the form, the CF...
  9. S

    Microsoft Query Data not coming over

    Hi, I used the Microsoft Query to access data from an access DB that I maintain. when I import it, I view the data in the Wizard tool and it has the correct data but once I close out of it, the data that is imported into the Excel (in table form) is not right. Particularly any columns that have...
  10. G

    Microsoft Access Issues

    At work I had Access 2016, but do to some compatibility issues with my other Microsoft Office programs that were 2013, IT uninstalled all my Microsoft Office. They reloaded Microsoft Office 2013 with Access. So now all my Microsoft Office is 2013. Since they did this, I have two issues. The...
  11. T

    Trying to automate a document with some variables on the first page

    =LOOKUP(Wizard!B4,{"Annually","Monthly","Hourly";annual cost, monthly cost, hourly cost}) This is the formula I am using. The front page has two drop down menus. One with the number of users, and one that is the time frame (above). The goal is to be able to select the number of users, and the...
  12. B

    Wizard Program

    Is it possible to create an wizard to fill in a form created in excel like a step by step that only specific cells are filled
  13. E

    Excel to Word, using mail merge drops the leading 0 in zip codes. How to preserve 0's in 5 digit zip codes, when leading zero?

    I have 5 digit and 5+4 = 9 digit zip codes in Excel. Some start with 0 such as 01122. Using the mail merge wizard, the zip codes that begin with zero are getting dropped, which is not what I want. I dont want it to convert a zip from 01122 to 1122, because a zip code should include the...
  14. G

    VBA Form1.Hide is unloading the form

    I am running a VBA wizard, and part way through I HIDE the form to allow the users to modify some items directly in one of the worksheets. After this is done, I SHOW the form, but all the information has reset. Series of events: 1. Run the form SetupWizard 2. Information is entered in a...

Watch MrExcel Video

This Week's Hot Topics

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
Top