load

Hello, Below is the code I have been working on to open up google using send keys. Normally I use the waitime function I made below to guess when a page has loaded all the way. However sometimes the web page takes longer to open than other times. Is there any way that I can make the loop I have...

What would be the best method of loading a .txt file with 14 million records into 1 spreadsheet? Is this possible? If not, what are my best alternative methods that you all would suggest? Thanks for your help! :)

I have 2 userforms name "Home" and "Permanent". Home has several command buttons on it and one of them is set to close home and open permanent as follows. Unload Home Permanent.Show The "Permanent" userform has several controls on it that are editable by the user however, I do not want to...

Hi There. Is there a way to prevent excel from loading and displaying charts on worksheets and tabs when the file is opened? We have charts that plot many data points and opening the file can be lengthy when you wait for the chart to load. Also, when you scroll through a sheet it pauses at the...

The following code loads a table for "Contact Types" (Customer, Vendor, Shipper, etc.) While trying to bulletproof the code I discovered that when the table is empty that this line generates an unexpected result: row_ContactType = .Range.Rows.Count - 1 'Do not count the header" The...

Hey Guys, This is my first post on your wonderful forum.:) I have been looked through this forum but cant seem to find what I am looking for. I have a file on my hard-drive with all my product images, I would like to create a Marco to assign the product image next to the product code. The...

Hi ... PowerPivot consistently refuses to Load at Startup with Excel 2010 (32-bit) on Windows XP. At least 80% of the time, I have to navigate thru File:Options:Add-Ins:Com Add-Ins : Go where I find the Power Pivot for Excel option unchecked. Checking it and then clicking OK usually causes it to...

Hi All. I have a userform with a combobox from which the user can select any suburb in a certain country. When the form loads it populates this combobox by VBA. Depending on how far down the list the suburb is, this action can take a second or two and slows the form load down more than...

Hi I am new to VBA and would like assistance in completing my code below. I am trying to create a spreadsheet on Customers and the first form would allow user too input new customer and I would also like to build from this a form and code to allow user to 'Edit' customer information. Any and all...

Hello, I'm using Excel 2007. I have 60 calculated fields from a pivot table that I would like to use on a new data source. The new data source has 20 new columns that original did not have. The existing calculated fields from the original pivot table will work with the new data set and I...

I have some code that runs with a number of calculations, Intially I pop up a message box to the user to proceed.If they click "Ok" or "yes".Then i need to display a message box without any button stating that " Please wait " Is there a way to automatically display the Msgbox and continue with...

Dear all, I am in need of code for displaying some image loading.. process when i click my macro button. In detail : I have developed a macro with some calculations process, when the user click that macro button , It will ask for ok cancel message box, if the user click the ok button...

I have a form that I always want sorted by Rank_Order, then by Ind_Ser, every time the form loads. I can do this using the form property sheet, order by, then entering: [qry_Update_Personnel_Data_Filter].[Rank_Order], [qry_Update_Personnel_Data_Filter].[Ind_Ser] However, this is lost if I...

Hello, I hope someone can help me. I have created a form in excel vba that stores data in a row with a header. Everything works fine, however I would like users to be able to edit a certain row, using the same form that they used for entering the data. So, I would like to have a vba code that...

I need to load a excel workbook when the user clicks a command button. I have not been able to get any code to work.

Hi All, I have listbox1 which lists all the userforms in my Activeworkbook. I am trying to load a userform based on the value selected in the listbox but can't get it to work, can someone please help with a script to load/ show the userform, the userform would be activated by a commandbutton...

Hi - I've got a workbook that I load/refresh on multiple sheets. I want to load each sheet separately. Right now, every time I export, the entire workbook exports up into Hyperion Enterprise. How do I change this? Is this something I can change? I have other workbooks with a similar setup...