Search results for query: *

Hopefully this is an easy question. I am in excel and have the manufacture year and week number for a product. I would like to convert this to a Friday date for the week of manufacture since we only ship on Fridays. Does anyone have a simple solution?

Thanks Skip, I had a brain freeze this morning and was making this much more difficult than it needed to be.

I have an Excel workbook that has several command buttons tied to macros on a main worksheet. I would like to prompt the user to enter a password when they click on a command button to allow the macro to run. Not every command button in the workbook requires this level of protection. Does...

Thanks Andy - I was making it much more complicated than it needed to be.

I have a simple macro that opens an WorkbookA, copies worksheetA, pastes the data into worksheetB in workbookB, then closes the workbookA. On closing of workbookA, I want to automatically clear the clipboard and not be prompted as to whether I want to keep the data on the clipboard. How do I...

Thanks - this looks useful

I am the administrator on a multiuser Access DB. Periodically I need to have exclusive access to the database. How do I kick out the other users?

I have an Access report that when it is exported to Excel, some of the data is being changed. The problem is a text field with a part number. All of the part numbers are formatted with 9999999-9. The part numbers starting as 2034XXX-X are changing to a 6 digit number (as an example 2034080-1...

AnotherHiggins - thanks for the reply. Although the reformatting to text using format cells didn't work it did get me searching Excel help for other ways to convert numbers to text. I was able to resolve the #NUM! issue when viewing a linked table in Access by using the TEXT function in...

I have a link from Access to an excel spreadsheet. Several columns have text data with a periodic cell that the data is a number. When I look at the table from access, I see #NUM! in the cells that have numbers instead of text. I have tried reformatting the data in Excel to be generically...

I got the problem solved. I just needed to comment out the appl.DoCmd.RunMacro line.

Oops - the open access works fine, but when I toggle back to Excel, I get a run time error 2485. I have to clear the error to do anything else in Excel. What am I missing in my code to allow toggling back to excel? Here is the code: Sub OpenAccess() 'Public Sub OpenAccess() Dim app As...

Thanks - just what I was looking for. [thumbsup]

I have an excel spreadsheet that is linked to an Access Database. Right now I have the operator open the spreadsheet, run a macro to manipulate a text file then open the database from a desk top short cut. I would like to give them a button in Excel that takes them to the database directly so...

Sorry it took so long to get back. I ended up with a FindFile command. As I started digging into my Txt files, they were generically identical, but the column spacings needed to be moved a character or 2 in some cases. The find file allowed me to verify that the column breaks were in the...

Thanks SkipVought, the data import is how I normally pull the data in. I have several users that are not Excel savvy so I am trying to make the spreadsheet very user friendly for them by prompting them to find the file then importing the information. I used the macro recorder, and got this...

I would like to build a macro that prompts a user to locate a text file then import it into a work sheet in Excel. I wasn't able to fine any information on how to do this by browsing with Windows Explorer

PHV - Works like a charm!! Thanks

PHV and Skip Vought Thanks for getting back to me so quickly. PHV - I changed the selection to select (I missed that on the first try). Unfortunately that wasn't the problem but the code is now correct. I also tried manually inserting a blank row and copying the data to the top using...

I receive a series of files with differing numbers of rows. The field names information are always the last row in the file and I would like to move it to the 1st row using a cut/paste insert command. Because the number of rows differs from file to file, I am using a do until loop to find the...