Search results

This might help: http://www.java2s.com/Code/VBA-Excel-Access-Word/Excel/IsWorkbookOpen.htm

That would work but not with what I have to do, I have hundreds of workbooks and it would be a nuisance to have to put that in each of them. Thanks anyway, I'm sure it will help someone else here.

Thanks for your reply, but unfortunately it doesn't help my cause and I actually knew that already. I came up with a solution to just create a macro which will find / replace the name if it's the wrong one for the template.

That's what I thought from research but I was hoping there might have been a way. I was creating a template to gather information from 6 worksheets but one worksheet can have two different names.

So how can I use this to return the value in B1 in a cell formula?

I think I'm going to scrap this idea, I don't need to do the process this way anymore. Although I will still look to find out how to do it, in my own time, just incase I ever need to know how to, in the future. :) Thanks for all the replies guys!

Hello, Is there any way to reference a worksheet number in a cell formula in a different worksheet without having to know the worksheet name. Eg. I currently have: =Global!B1 This gets the value from the cell B1 in the global worksheet, but I want to be able to doing something like =...

I should probably have mentioned I'm using access 2007 (not my choice).

Haha, that should of been obvious, wasn't really looking at that, I cut / pasted from mbhw99's code. :)

Try this: CurrentDb.Execute ("INSERT INTO tblBosTracking ([Observed By], [Input Date]) SELECT [Observed By] , [Input Date] FROM tblForm2Input WHERE ((tblBosTracking.BOSID = " & Me.ID")))

I may be wrong but I would of done something like Forms!tblForm2Input!ID instead of & Me.ID.

I'm certainly not advanced nor am I a beginner, somwhere inbetween. I have done a lot of work using object code but not in saving worksheets to a different workbook it originated from. Setting a reference is no problem. No I'm not creating the excel workbook from code The workbooks will all be...

I was replying and searched just before posting and came across this: http://database.ittoolbox.com/groups/technical-functional/access-l/date-flag-in-access-2007-3918036 Some of the replies are exactly how I would go about doing it.

I'm not going to do that hundreds of times for each workbook! I've had a master spreadsheet from the start. I wanted to find an easy way to put the spreadsheet into hundreds of workbooks all with the same format but different values. Then I'll import all the spreadsheets into access and combine...

Your problem lies here : tblBosTracking.BOSID = " & Me.ID" Assuming you have a field called BOSID in the tblBostracking table your problem is: & Me.ID Is that meant to be getting a value from a form?

It will actually get imported right after. I made a template excel file to calculate values from a worksheet so I want to overwrite one worksheet then import another after it uses the imported one to get values. I can't do this manually as there are hundreds of excel files!

Maybe it's because you missed brackets: CurrentDb.Execute ("INSERT INTO tblBosTracking ([Observed By], [Input Date]) SELECT [Observed By] , [Input Date] FROM tblForm2Input")

This should help: http://allenbrowne.com/ser-57.html

Hello, Basically I want to save a worksheet from one workbook into a different workbook within access. How do i go about doing that? I was guessing I could open two excel application objects and open the workbooks or worksheets there but i wouldn't know how to save one onto the other. The...

Ok I scrapped this method and just added a unique field which will solve the problem but would still be good to know how to do this.