Browse by Tags - Questions and answers to issues related to Microsoft: Windows, Applications, Development, Hardware, Server, Internet Protocols, Database, Exchange .

Open a workbook but make invisible to users

Is there a way in VBA to open a workbook in such a way that the user does not know it is open, or even in existence, but for VBA to still use and manipulate it whilst the user makes changes on their own workbooks?

Posted to Excel (Forum) by microsoft on 03-31-2010
VBA VLOOKUP from Another Workbook

I have two open workbooks; Book1 and Book2 Book2 has a lookup table on sheet1 I want to run code from book1 that will pick up a value from cell A1 and then lookup from sheet1 in book2 that value and return into B1 what is in column 2 The code I have tried is [B1] = Application.VLookup(Range("A1"...

Posted to Excel (Forum) by microsoft on 03-06-2010
Set Font For Workbook or Worksheet Through VBA

Hi, How can I set the font at the Workbook or Worksheet level so that all cells use this font? Somthing like: objWS.Range(EntireSheet).Font.Name = "arial" except at the beginning of the code, before I know what the range of the entire worksheet is. Thanks

Posted to Excel (Forum) by microsoft on 01-11-2010
Attempting to share workbook and when VBA runs on a particular sheet, get run time error 1004.

I am attempting to share a WB and when I open a particular sheet, JobTrac, it runs a VBA macro to update some graphical bars (shapes) that represent a visual indicator of percentages. I can't tell which of the operations are causing the offense since the macro editor is disabled when you share a...

Posted to Excel (Forum) by microsoft on 09-12-2009
VBA - Open multiple workbooks and copy sheet to new workbook

Hey all, I have been assigned a new project that will require a little VBA, and my VBA skills are very elementary. I have 100 files (Book1.xls through Book100.xls) All files reside in C:\Temp I need to open each workbook, copy Sheet1, paste to next available Sheet# in Summary.xls, close the workbook...

Posted to Excel (Forum) by microsoft on 08-20-2009
Workbook has lost its VBA project - Excel 2003

I have a user that gets the following message when opening existing Excel workbooks after upgrading Office XP to 2003 Professional: "This workbook has lost its VBA project, ActiveX controls and any other programmability-related features." The user is then able to open the spreadsheet with no...

Posted to Excel (Forum) by microsoft on 08-15-2009
VBA: Open multiple, uniquely-named workbooks and copy sheet to new workbook

Hello - I was looking through some solutions to try to adapt to my situation. This code (which works really well) was written to open similarly named workbooks ("Book1, Book2, etc.) and copy the same sheet from all of them. I'm hoping to modify in the following ways: 1) Instead of copying "Sheet1"...

Posted to Excel (Forum) by microsoft on 08-14-2009
Change workbook name without saving using VBA????

Can I rename a workbook, using VBA, without saving it?

Posted to Excel (Forum) by microsoft on 08-11-2009
Excel VBA : How to execute a subroutine in another workbook ?

Hi, I have a workbook (e.g. macro.xls) contains all VBA codes that need to process our data (no data contained in macro.xls). Yet, cause some of our user workbooks also contain some code and I don't want to copy or rewrite them in my macro.xls, therefore, in my code, I open that particular user workwork...

Posted to Excel (Forum) by microsoft on 07-09-2009
Access VBA and Saving Excel Workbook

I am accessing Excel thru Access VBA code. I open a file, calculate some fields, then close the file. When I close the file, I'm prompted if I want to save the changes to the file. I don't want to be prompted. Here is my code, any ideas on what I'm doing wrong. Set xlApp = New Excel.Application...

Posted to Access (Forum) by microsoft on 07-08-2009

Page 1 of 3 (21 items) 1 2 3 Next >